4-66 IBM Informix OnLine Database Server Administrator’s Guide

Migrating Data from SE to OnLine

Formore information about the differences between the two database servers
and their interpretation ofSQL, refer to IBMInformix Guide to SQL: Reference.
Migrating Data from SE to OnLine
This section describes the information you need if you are migrating an
IBMInformix SE database to an OnLine database server.
Usethe IBM Informix SE dbexport utility to prepare the data and the OnLine
dbimportutility to load the data. Refer to the IBM Informix SE Administrator s
Guide for further information about preparing the data for migration to
OnLine.Refer to page 4-53for an overview of the dbexport/dbimport utility
pair.
Beforeyou execute dbimport, you might wish to edit the .sql file created by
dbexport to include OnLine information.
The.sql file does not contain the following table information that you might
wish to specify for your OnLine databases and tables:
Database logging modes
Initial and next extent values for a table (the default value of eight
pages is used)
Lockmode for a table (the default value of page-level locking is used)
Blobspace whereTEXT or BYTE data types should reside
Dbspace where the tables should reside
Run dbimport when you are ready to re-create and populate the exported
databases. (During the import, page-level locking is used unless otherwise
specified in the.sql file.)
The dbimport command-line options enable you to do these things:
Turn logging on for the imported database.
Specify the new database to be created asANSI-compliant.
Specify the dbspace where the database is to be created.
Afteryou successfully migrate the database to OnLine, ensure that the appli-
cation developers are aware of the differences between OnLine and
IBMInformix SE.