Data Consistency, Recovery, and Migration 4-65
Migrating Data from OnLine to SE
■ tbload creates a database without logging; you must initiate logging
after the database is loaded, either through DB-Monitor or with the
tbtape utility.
■ When you use tbload 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 an IBM Informix SE database server.
Use the dbexport utility to prepare the data. Refer to page 7-5 for instructions
and syntax for dbexport. Refer to page 4-53 for an overview of the
dbexport/dbimport utility pair.
Use a system editor to remove the following OnLine specifics from CREATE
TABLE
statements included in the .sql file created by dbexport:
■ Initial and next extent sizes
■ Dbspace and blobspace names
■ Lock modes
■ VARCHAR, BYTE, and TEXT columns
Refer to the IBM Informix SE Administrator’s Guide for detailed instructions
about using dbimport to migrate the prepared OnLine data. After you
successfully migrate the data to IBM Informix SE, ensure that the application
developers are aware of the differences between OnLine and IBM Informix
SE.
Three SQL statements contain syntax that only OnLine recognizes:
■ SET CONSTRAINTS statement
■ SET ISOLATION statement
■ SET LOG statement
Three SQL statements contain extensions that only OnLine recognizes:
■ ALTER TABLE
■ CREATE DATABASE
■ CREATE TABLE
