Since regular logging is not performed, the load utility uses pending states to preserve database consistency. These states can be checked by using the LIST TABLESPACES command (see the Command Reference).
The load and build phases of the load process place any associated table spaces into load pending state. To remove the load pending state (if the load operation has failed, or was interrupted):
The delete phase places any associated table spaces into delete pending state.
Table spaces are placed in backup pending state if the load process completes, and:
The fourth possible state associated with the load process pertains to referential and check constraints. If an existing table is a parent table containing a primary key referenced by a foreign key in a dependent table, replacing data in the parent table places the dependent table (not the table space) in check pending state. To validate a table for referential integrity and check constraints, issue the SET INTEGRITY statement after the load process completes, if the table has been left in check pending state. For more information about the check pending state, see Checking for Constraints Violations.