IBM 000-8697 Manual Do Utilizador

Data Consistency, Recovery, and Migration

■

creates a database without logging; you must initiate logging

after the database is loaded, either through

DB-M

onitor or with the

 utility.

■

When you use tbload to load a table into a logged database, you
must turn logging off for the database during the operation.

This section describes the information you need if you are migrating an
OnLine database to an

IBM I

nformix

SE

 database server.

Use the dbexport utility to prepare the data. Refer to

for instructions

and syntax for dbexport. Refer to

/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

uide for detailed instructions

about using dbimport to migrate the prepared OnLine data. After you
successfully migrate the data to

IBM I

nformix

SE

, ensure that the application

developers are aware of the differences between OnLine and

IBM I

nformix

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