IBM 000-8697 Manual Do Utilizador

Data Consistency, Recovery, and Migration

The .sql file does not contain all table information available from the existing
database. You can modify the .sql file to add the following information:

■

Initial and next extent values for a table (the default value of eight
pages is used)

■

Lock mode for a table (the default value of page-level locking is used)

■

Dbspace where a table should reside

■

Blobspace where a blob column should reside

If you export a database that stores blobs in a blobspace, you must edit the
.sql

 file to include the blobspace name in the

CREATE TABLE

 statement.

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 as

ANSI

-compliant.

■

Specify the dbspace where the database is to be created.

This section describes how you migrate data using the tbunload and tbload
utilities.

Refer to

 for an overview of this method. Refer to

 for

instructions and syntax for tbunload. Refer to

for instructions and

syntax for tbload.

To run tbunload or tbload, you must be logged in as user informix or have

DBA

 privileges. You must run both utilities from the current host machine.