Informix Migration Guide, February 1998 (G251-0273-00) PDF的目录

Informix Migration
Guide
®
February 1998
Part No. 000-4372
Informix Dynamic Server, Version 7.3
Informix Dynamic Server with Advanced Decision Support and Extended Parallel Options, Version 8.2
Informix Dynamic Server with Universal Data Option, Version 9.1x
Informix Dynamic Server, Developer Edition, Version 7.3
Informix Dynamic Server, Workgroup Edition, Version 7.3
INFORMIX-OnLine, Version 4.1x and 5.x
INFORMIX-OnLine Dynamic Server, Version 6.0 through 7.2x
INFORMIX-OnLine Workgroup Server, Version 7.12 and 7.22
INFORMIX-OnLine XPS, Version 8.1x
INFORMIX-SE, Version 4.1 through 7.2x
ii Informix Migration Guide
Published by INFORMIXÒ Press Informix Software, Inc.
4100 Bohannon Drive
Menlo Park, CA 94025-1032
Copyright Ó 1981-1998 by Informix Software, Inc. or its subsidiaries, provided that portions may be
copyrighted by third parties, as set forth in documentation. All rights reserved.
The following are worldwide trademarks of Informix Software, Inc., or its subsidiaries, registered in the
United States of America as indicated by “Ò,” and in numerous other countries worldwide:
Answers OnLineÔ; INFORMIXÒ; InformixÒ; IllustraÔ; C-ISAMÒ; DataBladeÒ; Dynamic ServerÔ; GatewayÔ;
NewEraÔ
All other names or marks may be registered trademarks or trademarks of their respective owners.
Documentation Team: Twila Booth, Beth Delson, Evelyn Eldridge-Diaz
RESTRICTED RIGHTS/SPECIAL LICENSE RIGHTS
Software and documentation acquired with US Government funds are provided with rights as follows: (1) if
for civilian agency use, with Restricted Rights as defined in FAR 52.227-19; (2) if for Dept. of Defense use, with
rights as restricted by vendor's standard license, unless superseded by negotiated vendor license as prescribed
in DFAR 227.7202. Any whole or partial reproduction of software or documentation marked with this legend
must reproduce the legend.

Table of ContentsTable ofContentsIntroductionAbout This Manual . . . . . . . . . . . . . . . . . . 3Types of Users . . . . . . . . . . . . . . . . . . 4Assumptions About Your Locale. . . . . . . . . . . . 5Demonstration Databases . . . . . . . . . . . . . . 5New Features . . . . . . . . . . . . . . . . . . . . 6New Features in Version 7.3 . . . . . . . . . . . . . 6New Features in Version 8.2 . . . . . . . . . . . . . 6Documentation Conventions . . . . . . . . . . . . . . 7Typographical Conventions . . . . . . . . . . . . . 8Icon Conventions . . . . . . . . . . . . . . . . . 9Syntax Conventions . . . . . . . . . . . . . . . . 12Command-Line Conventions . . . . . . . . . . . . . 15Sample-Code Conventions. . . . . . . . . . . . . . 18Additional Documentation . . . . . . . . . . . . . . . 19On-Line Manuals . . . . . . . . . . . . . . . . . 19Printed Manuals . . . . . . . . . . . . . . . . . 19Error Message Files . . . . . . . . . . . . . . . . 20Documentation Notes, Release Notes, Machine Notes . . . . 20Compliance with Industry Standards . . . . . . . . . . . 22Informix Welcomes Your Comments . . . . . . . . . . . . 22iv Informix Migration GuideSection I Migrating DataChapter 1 Data Migration OverviewOverview of Informix Database Servers . . . . . . . . . . 1-3Planning for Data Migration . . . . . . . . . . . . . . 1-4Informix Database Server Versions . . . . . . . . . . . . 1-6Database Server Migration Paths . . . . . . . . . . . . . 1-7Automatic Migration Between Database Servers . . . . . . 1-9Migrating to a Different Operating System . . . . . . . . 1-9Tools for Moving Data . . . . . . . . . . . . . . . . 1-10Choosing the Appropriate Migration Utility . . . . . . . 1-13Chapter 2 Moving Between ComputersUsing onunload and onload to Migrate Data . . . . . . . . 2-3Steps for Using onunload and onload. . . . . . . . . . 2-5Other Migration Utilities . . . . . . . . . . . . . . . 2-8Importing Data from a Non-Informix Source . . . . . . . . 2-9Using the INFORMIX-Enterprise Gateway Products . . . . 2-9Using the High-Performance Loader . . . . . . . . . . 2-10Section II Migrating Versions of Database ServersChapter 3 Migrating OnLine Dynamic Server 7.2 to AD/XP 8.2Preparing to Migrate to Dynamic Server with ADand XP Options 8.2 . . . . . . . . . . . . . . 3-4Changes Introduced by Dynamic Server with ADand XP Options . . . . . . . . . . . . . . . 3-5High Degree of Parallelism . . . . . . . . . . . . . 3-5What are Coservers, Cogroups, and Dbslices?. . . . . . . 3-5Environment Variables. . . . . . . . . . . . . . . 3-6Configuration Parameters. . . . . . . . . . . . . . 3-7The sqlhosts File or Registry . . . . . . . . . . . . . 3-10Database Schema. . . . . . . . . . . . . . . . . 3-12Logging and Non-Logging Table Types . . . . . . . . . 3-15Utilities . . . . . . . . . . . . . . . . . . . . 3-17INFORMIX-Enterprise Command Center . . . . . . . . 3-19New Indexes . . . . . . . . . . . . . . . . . . 3-19Global Language Support. . . . . . . . . . . . . . 3-20Table of Contents vLoading and Unloading Data . . . . . . . . . . . . . . 3-20Express Mode . . . . . . . . . . . . . . . . . . 3-21Deluxe Mode . . . . . . . . . . . . . . . . . . 3-21Migrating From OnLine Dynamic Server 7.2 to DynamicServer with AD and XP Options 8.2 . . . . . . . . . 3-22File-System Variations . . . . . . . . . . . . . . . 3-23Migration Procedures. . . . . . . . . . . . . . . . 3-24Configure and Check Available Space . . . . . . . . . . 3-25Save Copies of the Current Configuration Files. . . . . . . 3-26Close All Transactions in OnLine Dynamic Server. . . . . . 3-27Go to Quiescent Mode . . . . . . . . . . . . . . . 3-27Verify the Integrity of the Data . . . . . . . . . . . . 3-28Verify the Mode. . . . . . . . . . . . . . . . . . 3-29Make a Final (Level-0) Backup . . . . . . . . . . . . 3-29Unload Your Data . . . . . . . . . . . . . . . . . 3-30Bring the Source Database Server Off-Line . . . . . . . . 3-30Reconfigure the Operating System . . . . . . . . . . . 3-31Install Dynamic Server with AD and XP Options . . . . . . 3-31Set Environment Variables . . . . . . . . . . . . . . 3-32Copy Utilities . . . . . . . . . . . . . . . . . . 3-33Update the ONCONFIG Configuration Files. . . . . . . . 3-33Bring Dynamic Server with AD and XP Options On-Line . . . 3-33Use onutil to Create Cogroups and Dbslices . . . . . . . . 3-34Create a Database . . . . . . . . . . . . . . . . . 3-34Load Data from External Tables . . . . . . . . . . . . 3-35Run UPDATE STATISTICS and Build Indexes . . . . . . . 3-38Verify the Integrity of the Data . . . . . . . . . . . . 3-38Make an Initial Backup . . . . . . . . . . . . . . . 3-39Check Rejection Files. . . . . . . . . . . . . . . . 3-39Recompile ESQL/C Programs. . . . . . . . . . . . . 3-40Migration Complete . . . . . . . . . . . . . . . . 3-40Reverting AD/XP 8.2 to OnLine Dynamic Server 7.2 . . . . 3-41Unloading to External Tables . . . . . . . . . . . . . 3-41Migrating Between OnLine XPS 8.1x and Dynamic Server withAD and XP Options 8.2 . . . . . . . . . . . . . 3-42Migration Procedures. . . . . . . . . . . . . . . . 3-42Migrating from Previous 8.x Versions . . . . . . . . . . 3-45vi Informix Migration GuideChapter 4 Migrating the 7.2 Database Server to Version 9.1xPreparing to Migrate to Universal Server or Informix DynamicServer with Universal Data Option . . . . . . . . . 4-4Changes Introduced by Universal Server . . . . . . . . . . 4-5Environment Variables. . . . . . . . . . . . . . . 4-5Configuration Parameters. . . . . . . . . . . . . . 4-5New Database Storage Spaces . . . . . . . . . . . . 4-6New Options Syntax in the Sqlhosts File or Registry . . . . 4-7Global Language Support. . . . . . . . . . . . . . 4-8Migrating from OnLine Dynamic Server 7.2x to UniversalServer or Dynamic Server with UD Option . . . . . . 4-9Migration Procedures . . . . . . . . . . . . . . . 4-9Check Available Space . . . . . . . . . . . . . . . 4-10Save Copies of the Current Configuration Files . . . . . . 4-12Close All Transactions . . . . . . . . . . . . . . . 4-13Initiate a Fast Recovery. . . . . . . . . . . . . . . 4-13Verify the Integrity of the Data . . . . . . . . . . . . 4-13Verify the Mode . . . . . . . . . . . . . . . . . 4-14Make a Final Backup . . . . . . . . . . . . . . . 4-15Bring the Source Database Server Off-Line . . . . . . . . 4-15Reconfigure the UNIX Operating System . . . . . . . . 4-16Install the Target Database Server . . . . . . . . . . . 4-16Verify That Environment Variables Are Set Correctly . . . . 4-17Update the ONCONFIG Configuration Files . . . . . . . 4-17Add a Communications Support Module (Optional) . . . . 4-18Update the ON-Archive Configuration Files . . . . . . . 4-18Bring The Target Database Server On-Line . . . . . . . . 4-19Verify the Integrity of the Data . . . . . . . . . . . . 4-20Make an Initial Target Database Server Backup . . . . . . 4-20Migration Complete. . . . . . . . . . . . . . . . 4-21Install and Configure Datablade Modules . . . . . . . . 4-21Reverting Universal Server or Dynamic Server with UDOption to OnLine Dynamic Server 7.2 . . . . . . . . 4-22Determine Whether Reversion Is Possible . . . . . . . . 4-23Save Copies of the Configuration Files . . . . . . . . . 4-23Verify the Integrity of the Data . . . . . . . . . . . . 4-24Back Up Your Source Database Server . . . . . . . . . 4-24Remove Universal Server or Dynamic Server with UDOption Features . . . . . . . . . . . . . . 4-24Run the Reversion Utility. . . . . . . . . . . . . . 4-28Modify Configuration Parameters . . . . . . . . . . . 4-29Reset Environment Variables. . . . . . . . . . . . . 4-29Remove Communications Support Module Settings. . . . . 4-29Install and Start the Target Database Server. . . . . . . . 4-29Table of Contents viiVerify the Integrity of the Data . . . . . . . . . . . . 4-30Back Up the Target Database Server. . . . . . . . . . . 4-30Return the Target Database Server to On-Line Mode . . . . . 4-30Upgrading Universal Server 9.10 to Dynamic Serverwith UD Option 9.13. . . . . . . . . . . . . 4-30Chapter 5 Migrating the Database Server 6.0 or Later to 7.3Changes Introduced in Database Server Version 6.0 toVersion 7.3 . . . . . . . . . . . . . . . . . . 5-6Environment Variables Introduced in Version 7.3 . . . . . . 5-6Configuration Parameters Introduced in Version 7.3 . . . . . 5-6Features Introduced in Version 7.3 . . . . . . . . . . . 5-7Environment Variable Changes in Version 7.2x . . . . . . . 5-9Configuration Parameter Changes in Version 7.2x . . . . . . 5-11Environment Variable Changes in Version 7.10.UD1 . . . . . 5-14Configuration Parameter Changes in Version 7.10.UD1 . . . . 5-15Changes to Blobspace Requirements in Version 7.10.UD1 . . . 5-16Environment Variable Changes in Version 7.1 . . . . . . . 5-16Configuration Parameter Changes in Version 7.1 . . . . . . 5-16ON-Archive Changes in Version 7.1. . . . . . . . . . . 5-17Environment Variable Changes in Version 6.0 . . . . . . . 5-17Preparing to Migrate Between Versions . . . . . . . . . . . 5-18Install the Latest Maintenance Release for theCurrent Version . . . . . . . . . . . . . . 5-19Check Available Space and System Requirements . . . . . . 5-19Save Copies of the Current Configuration Files. . . . . . . 5-20Shut Down the Database Server . . . . . . . . . . . . 5-21Verify the Integrity of the Data . . . . . . . . . . . . 5-22Back Up Your Database Server Files. . . . . . . . . . . 5-22Preparation Complete . . . . . . . . . . . . . . . 5-23Upgrading to Informix Dynamic Server, Version 7.3 . . . . . . 5-23Save an Output File of SQL Statements for Access Paths. . . . 5-24Bring the Source Database Server Off-Line . . . . . . . . 5-24Reconfigure the Operating System . . . . . . . . . . . 5-24Install the Target Database Server . . . . . . . . . . . 5-25Install INFORMIX-Enterprise Command Center . . . . . . 5-26Customize the Database Server Environment . . . . . . . 5-26Update the ONCONFIG Configuration Parameters . . . . . 5-27Configure the Database Server to Use EnterpriseReplication . . . . . . . . . . . . . . . . 5-27Installing and Configuring SNMP . . . . . . . . . . . 5-28Bring the Target Database Server On-Line. . . . . . . . . 5-29Run UPDATE STATISTICS. . . . . . . . . . . . . . 5-30Verify the Integrity of the Data . . . . . . . . . . . . 5-30viii Informix Migration GuideCheck Space Requirements for BYTE and TEXT Data . . . . 5-30Make an Initial Backup. . . . . . . . . . . . . . . 5-31Verify the Access Path of Your SQL Statements . . . . . . 5-31Migration Complete. . . . . . . . . . . . . . . . 5-32Changing Database Server Definitions . . . . . . . . . 5-32Migrating to a GLS Locale . . . . . . . . . . . . . . . 5-33Reverting to OnLine Dynamic Server . . . . . . . . . . . 5-33Reversion Steps . . . . . . . . . . . . . . . . . 5-34Remove Unsupported SQL Features . . . . . . . . . . 5-35Remove Fragmented Tables (Version 6.0 Only) . . . . . . 5-35Save System Catalog Information . . . . . . . . . . . 5-35Stop Enterprise or Workgroup Replication(Version 7.22 or Later) . . . . . . . . . . . . 5-36Uninstall the Database Server and Informix EnterpriseCommand Center . . . . . . . . . . . . . 5-37Modify In-Place ALTER TABLE (Version 7.24 and Later) . . . 5-37Close All Transactions and Bring the Database intoQuiescent Mode . . . . . . . . . . . . . . 5-38Verify the Integrity of the Data . . . . . . . . . . . . 5-39Back Up Your Database Server . . . . . . . . . . . . 5-39Run the Reversion Utility. . . . . . . . . . . . . . 5-40Remove GLS Features . . . . . . . . . . . . . . . 5-41Modify Configuration Parameters . . . . . . . . . . . 5-41Reset Environment Variables. . . . . . . . . . . . . 5-45Modify the sqlhosts File . . . . . . . . . . . . . . 5-47Reinstall the Earlier Version of the Database Server . . . . . 5-47Bring the Database Server On-Line . . . . . . . . . . 5-48Rename ON-Archive Files (Version 6.0 Only) . . . . . . . 5-49Restore System Catalog Information (Version 6.0 Only) . . . 5-49Verify the Integrity of the Data . . . . . . . . . . . . 5-49Back Up the Database Server Files. . . . . . . . . . . 5-50Return the Database Server to On-Line Mode . . . . . . . 5-50Reversion is Now Complete . . . . . . . . . . . . . 5-50Reverting from Version 7.10.UDI, 7.12, and 7.14 to 7.10.UCx . . . 5-50Verify the Integrity of the Data . . . . . . . . . . . . 5-51Back Up the Database Server. . . . . . . . . . . . . 5-51Reversion is Now Complete . . . . . . . . . . . . . 5-51Table of Contents ixChapter 6 Migrating Pre-6.0 to Informix Dynamic Server 7.3Preparing to Migrate Between Versions . . . . . . . . . . . 6-3Changes Introduced in Version 6.0 . . . . . . . . . . . . 6-4Changes to Database Utilities . . . . . . . . . . . . . 6-5Planning for Migration . . . . . . . . . . . . . . . . 6-6Operating-System Configuration Issues . . . . . . . . . 6-6Estimating the Size and Number of Shared-MemorySegments. . . . . . . . . . . . . . . . . 6-6Configuring Semaphore Parameters. . . . . . . . . . . 6-10Configuring the Number of Open-File Descriptors . . . . . 6-12Operating-System Updates. . . . . . . . . . . . . . 6-12Disk-Use Issues . . . . . . . . . . . . . . . . . . . 6-13Accommodating System Catalog Indexes. . . . . . . . . 6-14Accommodating the sysmaster Database . . . . . . . . . 6-15Locating Temporary Files and Tables . . . . . . . . . . 6-15Accommodating Data Distributions. . . . . . . . . . . 6-16Accommodating User-Table Indexes . . . . . . . . . . . . 6-17Accommodating the Conversion of User-Table Indexes . . . . 6-18Managing Secure-Auditing Log Files . . . . . . . . . . 6-20Database Server Configuration Issues . . . . . . . . . . . 6-21Changing Environment Variables . . . . . . . . . . . 6-21Revising Configuration Parameter Values. . . . . . . . . 6-21Increasing Logical-Log Space . . . . . . . . . . . . . 6-22Planning for Additional Shared-Memory Usage . . . . . . 6-22Saving Pre-Existing sysmaster Databases . . . . . . . . . 6-23Configuring Secondary Database Servers forData Replication . . . . . . . . . . . . . . 6-23Managing Backups . . . . . . . . . . . . . . . . 6-23Making Performance Comparisons . . . . . . . . . . . 6-23Migration from OnLine 4.1 or 5.0 to the DatabaseServer 6.0 or Later . . . . . . . . . . . . . . . 6-24Install the Latest Maintenance Release for theCurrent Version . . . . . . . . . . . . . . 6-24Capture Configuration and Chunk-Layout Information. . . . 6-25Close All Transactions and Make a Final Level-0 Backup . . . 6-26Bring OnLine 4.1 or 5.0 Off-Line . . . . . . . . . . . . 6-28Install and Configure the Target Database Server . . . . . . 6-29Reconfigure the UNIX Operating System . . . . . . . . . 6-31Bring the Target Database Server On-Line. . . . . . . . . 6-32Convert User-Table Indexes . . . . . . . . . . . . . 6-33Verify the Integrity of the Data . . . . . . . . . . . . 6-37Make an Initial Backup Under The Target Database Server . . . 6-37Add Rowids to Fragmented Tables . . . . . . . . . . . 6-38x Informix Migration GuideMigration Complete. . . . . . . . . . . . . . . . 6-38Global Language Support. . . . . . . . . . . . . . 6-38Reverting to OnLine 5.0 . . . . . . . . . . . . . . . . 6-39Save Configuration Files . . . . . . . . . . . . . . . 6-40Remove All Users from the Database Server . . . . . . . 6-40Verify the Integrity of the Data . . . . . . . . . . . . 6-40Back Up the Database Server Files. . . . . . . . . . . 6-40Remove Features Introduced by Later Versions of theDatabase Server . . . . . . . . . . . . . . 6-41Execute the Reversion Utility . . . . . . . . . . . . 6-42Prepare the TBCONFIG Configuration File. . . . . . . . 6-42Reset Environment Variables. . . . . . . . . . . . . 6-43Bring Up the Desired Version of The Database Server . . . . 6-43Verify the Integrity of the Data . . . . . . . . . . . . 6-43Back Up OnLine 5.0 Server Data . . . . . . . . . . . 6-44Return OnLine 5.0 to On-Line Mode . . . . . . . . . . 6-44Chapter 7 Migrating Workgroup Edition and OnLine Workgroup ServerUsing Different Server and Client Configurations . . . . . . . 7-4Workgroup Edition 7.3 and IECC, Version 3.0 . . . . . . . 7-4OnLine Workgroup Server 7.22 through 7.24 and IECC 3.0 . . 7-4OnLine Workgroup Server 7.12 and IECC 2.0 . . . . . . . 7-5OnLine Workgroup Server 7.22 and IECC 2.0 . . . . . . . 7-5OnLine Workgroup Server 7.12 and IECC 1.0 . . . . . . . 7-5Preparing to Migrate Between Versions . . . . . . . . . . 7-5Check Available Space and System Requirements . . . . . 7-6Save a Copy of the Current Configuration Files . . . . . . 7-7Place the Database Server in Quiescent Mode . . . . . . . 7-7Verify the Integrity of the Data . . . . . . . . . . . . 7-8Back Up Your Database Server . . . . . . . . . . . . 7-9Preparation Complete . . . . . . . . . . . . . . . 7-10Upgrading the Database Server to Version 7.3 . . . . . . . . 7-10Save an Output File of SQL Statements For Access Paths . . . 7-11Bring the Source Database Server Off-Line . . . . . . . . 7-11Reconfigure the Operating System. . . . . . . . . . . 7-11Install the Database Server and Administration Tools . . . . 7-11Install the Target Database Server . . . . . . . . . . . 7-12Install INFORMIX-Enterprise Command Center . . . . . . 7-13Customize the Database Server Environment . . . . . . . 7-14Update the ONCONFIG Configuration Parameters . . . . . 7-14Configure the Database Server to Use EnterpriseReplication. . . . . . . . . . . . . . . . 7-15Table of Contents xiInstalling and Configuring SNMP . . . . . . . . . . . 7-16Bring the Target Database Server On-Line. . . . . . . . . 7-16Run UPDATE STATISTICS. . . . . . . . . . . . . . 7-18Verify the Integrity of the Data . . . . . . . . . . . . 7-18Make a Complete Backup of the Target Database Server. . . . 7-18Verify the Access Path of Your SQL Statements . . . . . . . 7-19Migration Complete . . . . . . . . . . . . . . . . 7-19Changing Database Server Definitions. . . . . . . . . . 7-20Migrating to a GLS Locale . . . . . . . . . . . . . . 7-20Reverting the Database Server and IECC . . . . . . . . . . 7-21Remove Unsupported SQL Features . . . . . . . . . . 7-21Uninstall Enterprise or Workgroup Replication(Version 7.3). . . . . . . . . . . . . . . . 7-22Run the Reversion Utility . . . . . . . . . . . . . . 7-22Uninstall the Database Server and Informix EnterpriseCommand Center. . . . . . . . . . . . . . 7-23Remove GLS Features (only If Reverting to 7.12) . . . . . . 7-24Modify Configuration Parameters . . . . . . . . . . . 7-24Reset Environment Variables . . . . . . . . . . . . . 7-25Reinstall the Earlier Version of the Database Server . . . . . 7-26Bring the Database Server On-Line . . . . . . . . . . . 7-27Verify the Integrity of the Data . . . . . . . . . . . . 7-28Back Up the OnLine Workgroup Server Data . . . . . . . 7-28Reversion Complete . . . . . . . . . . . . . . . . 7-28Chapter 8 Migrating SEImporting and Exporting Data . . . . . . . . . . . . . . 8-3Migrating Between Different Versions of SE . . . . . . . . . 8-3Preparing to Migrate from a Pre-6.0 SE to SE 7.2x . . . . . . 8-4Preparing to Migrate from a Post-6.0 SE to SE 7.2x. . . . . . 8-5Reverting to an Earlier Version of SE . . . . . . . . . . . . 8-6Converting C-ISAM Files to SE . . . . . . . . . . . . . . 8-6Migrating from C-ISAM to Dynamic Server or Its Editions . . . . 8-7xii Informix Migration GuideChapter 9 Moving Between Database ServersChoosing a Migration Method . . . . . . . . . . . . . 9-5Moving Data from SE to Informix Dynamic Server or Its Editions . 9-6Using the dbexport and dbimport Utilities . . . . . . . . 9-6Using the UNLOAD Statement . . . . . . . . . . . . 9-8Adapting Your Programs for Informix Dynamic Serveror Dynamic Server, Workgroup and DeveloperEditions. . . . . . . . . . . . . . . . . 9-10Moving Data from Informix Dynamic Server or Dynamic Server,Workgroup and Developer Editions to SE . . . . . . 9-11Eliminating Features That SE Does Not Support . . . . . . 9-11Using the dbexport and dbimport Utilities . . . . . . . . 9-12Using the UNLOAD Statement . . . . . . . . . . . . 9-13Adapting Your Programs for SE. . . . . . . . . . . . 9-15Moving Data from Informix Dynamic Server to Dynamic Server,Workgroup and Developer Editions . . . . . . . . 9-16Moving Data in the Same Environment . . . . . . . . . 9-16Moving Data Between Different Environments . . . . . . 9-16Save a Copy of the Current Configuration Files . . . . . . 9-17Verify the Integrity of the Data . . . . . . . . . . . . 9-17Back Up the Source Database Server . . . . . . . . . . 9-18Export the Source Database Server. . . . . . . . . . . 9-18Shut Down the Database Server. . . . . . . . . . . . 9-18Install and Configure Dynamic Server, Workgroup andDeveloper Editions. . . . . . . . . . . . . 9-19Verify Port Numbers and Services File . . . . . . . . . 9-20Customize the Database Server Environment . . . . . . . 9-20Bring Dynamic Server, Workgroup and DeveloperEditions On-Line . . . . . . . . . . . . . 9-21Import the Databases to the Target Database Server. . . . . 9-21Verify the Integrity of the Data . . . . . . . . . . . . 9-22Back Up the Target Database Server . . . . . . . . . . 9-22Run UPDATE STATISTICS . . . . . . . . . . . . . 9-22Migration Complete. . . . . . . . . . . . . . . . 9-22Adapting Your Programs for Dynamic Server, Workgroupand Developer Editions . . . . . . . . . . . 9-23Using the dbexport and dbimport Utilities . . . . . . . . 9-23Using the UNLOAD Statement . . . . . . . . . . . . 9-24Moving Data from Dynamic Server, Workgroup and DeveloperEditions to Informix Dynamic Server . . . . . . . . 9-26Moving Data in the Same Environment . . . . . . . . . 9-26Moving Data Between Different Environments . . . . . . 9-27Save a Copy of the Current Configuration Files . . . . . . 9-28Table of Contents xiiiVerify the Integrity of the Data . . . . . . . . . . . . 9-28Back Up the Source Database Server . . . . . . . . . . 9-28Export the Source Database Server . . . . . . . . . . . 9-29Shut Down the Source Database Server . . . . . . . . . 9-29Install the Target Database Server . . . . . . . . . . . 9-29Verify Port Numbers and Services File. . . . . . . . . . 9-30Customize the Database Server Environment . . . . . . . 9-30Bring the Target Database Server On-Line. . . . . . . . . 9-30Import the Databases into the Target Database Server . . . . 9-31Verify the Integrity of the Data . . . . . . . . . . . . 9-31Back Up the Target Database Server. . . . . . . . . . . 9-31Run UPDATE STATISTICS. . . . . . . . . . . . . . 9-32Migration Complete . . . . . . . . . . . . . . . . 9-32Adapting Your Programs for Informix Dynamic Server . . . . 9-32Using the dbexport and dbimport Utilities . . . . . . . . 9-33Using the UNLOAD Statement . . . . . . . . . . . . 9-34Moving Informix Dynamic Server Data Between Environments . . 9-36Procedure for Moving Data Between Environments . . . . . 9-36Using the Migration Utilities . . . . . . . . . . . . . 9-37Adapting Your Programs for the UNIX or Windows NTEnvironment . . . . . . . . . . . . . . . 9-37Migration Complete . . . . . . . . . . . . . . . . 9-37Moving Dynamic Server, Workgroup and Developer EditionsData Between Environments . . . . . . . . . . . 9-38Procedure for Moving Data Between Environments . . . . . 9-38Using the Migration Utilities . . . . . . . . . . . . . 9-39Adapting Your Programs for the UNIX or Windows NTEnvironment . . . . . . . . . . . . . . . 9-39Migration Complete . . . . . . . . . . . . . . . . 9-40Chapter 10 Changing LocalesUnderstanding Informix Language Support . . . . . . . . . 10-3Global Language Support (GLS) . . . . . . . . . . . . 10-4Native Language Support (NLS). . . . . . . . . . . . 10-10Asian Language Support (ALS) . . . . . . . . . . . . 10-15Language Support in Informix Database Servers . . . . . . . . 10-20Universal Server and Universal Data Option. . . . . . . . 10-22INFORMIX-OnLine XPS and Advanced Decision Supportand Extended Parallel Options . . . . . . . . . 10-22Informix Dynamic Server and INFORMIX-OnLineDynamic Server . . . . . . . . . . . . . . 10-23xiv Informix Migration GuideINFORMIX-SE . . . . . . . . . . . . . . . . . 10-24Informix Dynamic Server, Workgroup andDeveloper Editions and INFORMIX-OnLineWorkgroup Server . . . . . . . . . . . . . 10-24Converting to GLS Language Support . . . . . . . . . . . 10-25Determining Existing Locale Support. . . . . . . . . . 10-25Converting from NLS to GLS Language Support. . . . . . 10-28Converting from ALS to GLS Language Support. . . . . . 10-35Reverting from GLS Language Support . . . . . . . . . . 10-42Reverting from GLS to NLS Language Support . . . . . . 10-42Reverting from GLS to ALS Language Support . . . . . . 10-44Section III ReferenceChapter 11 Utilities for Data MigrationSetting Environment Variables . . . . . . . . . . . . . 11-6The dbexport Utility . . . . . . . . . . . . . . . . . 11-7Using the -c Option . . . . . . . . . . . . . . . . 11-9Using the -ss Option. . . . . . . . . . . . . . . . 11-9Destination Options. . . . . . . . . . . . . . . . 11-10The Contents of the Schema File . . . . . . . . . . . 11-12Exporting Simple Large Objects. . . . . . . . . . . . 11-13The dbimport Utility . . . . . . . . . . . . . . . . . 11-14Using the -c Option . . . . . . . . . . . . . . . . 11-16Canceling dbimport. . . . . . . . . . . . . . . . 11-16Database-Logging Mode . . . . . . . . . . . . . . 11-16Input-File Location Options . . . . . . . . . . . . . 11-17Create Options . . . . . . . . . . . . . . . . . 11-19Using the -l Options. . . . . . . . . . . . . . . . 11-20Changing the Database Name . . . . . . . . . . . . 11-20Importing Simple Large Objects . . . . . . . . . . . 11-22Using dbimport to Change the Locale of a Database. . . . . 11-22The dbload Utility . . . . . . . . . . . . . . . . . . 11-23Using the dbload Utility . . . . . . . . . . . . . . 11-25Choosing Between dbload and LOAD . . . . . . . . . 11-27Creating a dbload Command File . . . . . . . . . . . 11-28Writing a dbload Command File for Complex Data Types. . . 11-39Table of Contents xvThe dbschema Utility . . . . . . . . . . . . . . . . . 11-44Creating the Schema for a Database. . . . . . . . . . . 11-46Obtaining the Role Schema. . . . . . . . . . . . . . 11-53Displaying the Distribution Information for Tables . . . . . 11-56Using DB-Access with Dbschema Output. . . . . . . . . 11-60The onload Utility . . . . . . . . . . . . . . . . . . 11-62Specify Source Parameters . . . . . . . . . . . . . . 11-64Create Options . . . . . . . . . . . . . . . . . . 11-65Constraints That Affect onload and onunload . . . . . . . 11-66Constraints That Affect onload . . . . . . . . . . . . 11-67Logging While Using onload . . . . . . . . . . . . . 11-67Moving Simple Large Objects to a Blobspace. . . . . . . . 11-68Ownership and Privileges . . . . . . . . . . . . . . 11-68Exclusive Locking During Load Operation . . . . . . . . 11-68The onmode Utility . . . . . . . . . . . . . . . . . . 11-69Preparing to Use the -b Option . . . . . . . . . . . . 11-69Reverting to OnLine Version 5.0 . . . . . . . . . . . . 11-70Reverting to OnLine Dynamic Server Version 6.0 . . . . . . 11-71Reverting to Version 7.2 . . . . . . . . . . . . . . . 11-72The onunload Utility . . . . . . . . . . . . . . . . . 11-73Syntax . . . . . . . . . . . . . . . . . . . . . 11-73Specify Destination Parameters . . . . . . . . . . . . 11-74Constraints That Affect onunload . . . . . . . . . . . 11-74Unloading a Database or Table . . . . . . . . . . . . 11-75Logging Mode . . . . . . . . . . . . . . . . . . 11-76Locking During Unload Operation . . . . . . . . . . . 11-76The LOAD Statement . . . . . . . . . . . . . . . . . 11-77The UNLOAD Statement . . . . . . . . . . . . . . . . 11-77onpload: The High-Performance Loader Utility . . . . . . . . 11-79Appendix A Database Server Environment VariablesIndex