Download IBM Informix Migration Guide

Remove new BladeManager extensions . . . . . . . .
Reverting from Dynamic Server Version 11.50 . . . . . . .
Run the reversion utility . . . . . . . . . . . . .
Restore original configuration parameters. . . . . . . .
Restore original environment variables . . . . . . . .
Remove any Communications Support Module settings . . .
Recompile any Java UDRs that were compiled using JDK 5.0 .
Reinstall and start the earlier database server . . . . . .
Optionally update statistics on your tables after reverting . .
Update statistics on some system catalog tables after reverting
Verify the integrity of the reverted data . . . . . . . .
Back up the database server after reversion . . . . . . .
Return the database server to online mode . . . . . . .
Reverting clusters. . . . . . . . . . . . . . . .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
7-10
7-10
7-11
7-12
7-12
7-12
7-12
7-12
7-13
7-13
7-13
7-13
7-13
7-14
Part 3. Migration of data between database servers
Chapter 8. Migrating database servers to a new operating system . . . . . . . . . . 8-1
Choosing a tool for moving data before migrating between operating systems .
Adjusting database tables for file-system variations . . . . . . . . . .
Moving data to a database server on a different operating system . . . . .
Moving Data Between Dynamic Server and Workgroup Edition Version 7.24
Adapting your programs for a different operating system. . . . . . . .
Ensuring the successful creation of system databases . . . . . . . . .
.
.
.
on
.
.
. . .
. . .
. . .
Different
. . .
. . .
. . . . . . .
. . . . . . .
. . . . . . .
operating systems
. . . . . . .
. . . . . . .
. 8-1
. 8-1
. 8-2
8-2
. 8-3
. 8-3
Part 4. Data migration utilities
Chapter 9. The dbexport and dbimport utilities . . . . . . . . . . . . . . . . . . 9-1
Syntax of the dbexport command . . . . . . .
Termination of the dbexport utility . . . . .
dbexport errors . . . . . . . . . . . .
dbexport server-specific information . . . . .
dbexport destination options . . . . . . .
Contents of the schema file that dbexport creates .
Syntax of the dbimport command . . . . . .
Termination of the dbimport utility . . . . .
dbimport errors and warnings . . . . . . .
dbimport input-file location options . . . . .
dbimport create options . . . . . . . .
Database-logging mode . . . . . . . . .
Database renaming . . . . . . . . . .
Changing the database locale with dbimport. . .
Simple large objects (Version 9.21 or later versions)
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 9-2
. 9-4
. 9-4
. 9-4
. 9-4
. 9-6
. 9-6
. 9-8
. 9-8
. 9-8
. 9-10
. 9-10
. 9-11
. 9-11
. 9-12
Chapter 10. The dbload utility . . . . . . . . . . . . . . . . . . . . . . . . . 10-1
Syntax of the dbload command . . . . . . . . . . . . . . .
Table locking during a load operation . . . . . . . . . . . .
Rows to ignore during a load operation . . . . . . . . . . .
Bad-row limit during a load operation . . . . . . . . . . . .
Termination of the dbload utility . . . . . . . . . . . . .
Name and object guidelines for the dbload utility . . . . . . . .
Command file for the dbload utility . . . . . . . . . . . . .
Delimiter form of the FILE and INSERT statements . . . . . . .
Character-position form of the FILE and INSERT statements . . . .
Command file to load complex data types (Version 9.21 or later versions)
Using the dbload utility with named row types . . . . . . . .
Using the dbload utility with unnamed row types . . . . . . .
Using the dbload utility with collection data types . . . . . . .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 10-2
. 10-3
. 10-4
. 10-4
. 10-4
. 10-4
. 10-5
. 10-6
. 10-9
. 10-13
. 10-13
. 10-14
. 10-15
Contents
v