Utilities 7-107
tbunload: Transfer Binary Data in Page Units
tbunload: Transfer Binary Data in Page UnitsThetbunload utility writes a database or table to tape. The program unloads
thedata in binary in disk-page units, making it more efficient than dbexport.
The tape created bytbunload 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 asBUFFSIZE 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 theDB-Monitor Logical-Logs
menu, Databases option. You can add logging to a database either through
DB-Monitor (same option) or by executing tbtape.
To unload a database, you must have DBA privileges for the database. To
unloada table, you must either own the table or have DBA privileges for the
database in which the table resides.
Ifyou unload a table, only the data and index pages that are associated with
thetable 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.
Duringthe unload operation, the new database or table is locked exclusively.
An error is returned if an exclusive lock cannot be obtained.