IBM 000-8697 Manual Do Utilizador

Utilities

The tbunload utility writes a database or table to tape. The program unloads
the data in binary in disk-page units, making it more efficient than dbexport.

The tape created by tbunload is read using the tbload utility. The machine
receiving the data and the machine used to create the tape must share the
same page size (specified as

BUFFSIZE

 in the configuration file).

The logging mode is not preserved when a database is unloaded with
tbunload

. After you load the database with tbload, you can make a database

ANSI-complaint after it is loaded through the

DB-M

onitor Logical-Logs

menu, Databases option. You can add logging to a database either through

DB-M

onitor (same option) or by executing tbtape.

To unload a database, you must have DBA privileges for the database. To
unload a table, you must either own the table or have DBA privileges for the
database in which the table resides.

If you unload a table, only the data and index pages that are associated with
the table are unloaded. Access privileges defined for the table and synonyms
or views associated with the table are not unloaded to tape.

The tbunload utility unloads page images. If you load the pages to another
machine that stores numeric data types differently than your current
machine (for example, with the most significant byte last instead of first), the
contents of the data page could be misinterpreted.

During the unload operation, the new database or table is locked exclusively.
An error is returned if an exclusive lock cannot be obtained.