Logging during loading

When you use the onload utility to create tables from an onunload input tape, onload can load information only into a database without logging. Thus, before you load a table into an existing, logged database, you must end logging for the database.

You also might want to consider loading during off-peak hours. Otherwise, you might fill the logical-log files or consume excessive shared-memory resources. After you load the table, create a level-0 dbspace backup before you resume database logging.

When you use onload to create databases from an onunload input tape, the databases that result are not ANSI-compliant and do not use transaction logging. You can make a database ANSI compliant or add logging after you load the database.

The onload utility performs all its loading within a transaction. This feature allows the changes to be rolled back if an error occurs.