Data Consistency, Recovery, and Migration 4-63

Using tbunload and tbload

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)
■Lockmode 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 theCREATE TABLE statement.
Rundbimport 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.)
Thedbimport 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.
Using tbunload and tbload
Thissection describes how you migrate data using the tbunload and tbload
utilities.
Refer topage 4-53 for an overview of this method. Refer to page 7-107 for
instructionsand syntax for tbunload. Refer to page 7-47 for instructions and
syntax fortbload.
To ru ntbunload or tbload, you must be logged in as userinformix or have
DBA privileges. You must run both utilities from the current host machine.