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