Data Consistency, Recovery, and Migration 4-65

Migrating Data from OnLine to SE

tbloadcreates a database without logging; you must initiate logging
after the database is loaded, either throughDB-Monitor or with the
tbtape utility.
When you usetbload to load a table into a logged database, you
must turn logging off for the database during the operation.
Migrating Data from OnLine to SE
This section describes the information you need if you are migrating an
OnLine database to anIBM Informix SE database server.
Usethe dbexport utility to prepare the data. Refer to page 7-5 for instructions
and syntax fordbexport. Refer to page 4-53 for an overview of the
dbexport/dbimport utility pair.
Use a system editor to remove the following OnLine specifics fromCREATE
TABLE statements included in the.sql file created bydbexport:
Initial and next extent sizes
Dbspace and blobspace names
Lock modes
VARCHAR,BYTE, andTEXT columns
Refer to theIBM I nformix SE Administrator’s Guide for detailed instructions
about usingdbimport to migrate the prepared OnLine data. After you
successfullymigrate the data to IBM Informix SE, ensure that the application
developers are aware of the differences between OnLine andIBM Informix
SE.
ThreeSQL statements contain syntax that only OnLine recognizes:
SET CONSTRAINTSstatement
SET ISOLATIONstatement
SET LOGstatement
ThreeSQL statements contain extensions that only OnLine recognizes:
ALTERTABLE
CREATEDATABASE
CREATETABLE