After running LOAD

After you run the LOAD utility, you might need take additional actions to make sure your objects are consistent and not in restricted status.

Copying the loaded table space or partition
If you ran the LOAD utility with the LOG YES option, consider taking a full image copy of the table space or partition that you loaded. Such a copy might reduce the processing time of subsequent recovery operations.
Resetting restricted status after running the LOAD utility
The LOAD utility can place a table space or an index space into a restricted status. Several types of restricted status are possible.
Running CHECK INDEX after loading a table that has indexes
The CHECK INDEX utility tests whether an index is consistent with the data it indexes and issues error messages if it finds an inconsistency.
Recovering data after a failed LOAD job
If a LOAD utility job fails, you can recover the data to a point in time before the LOAD job ran.
Reorganization of an auxiliary index after LOAD
Indexes on the auxiliary tables are not built during the BUILD phase. Instead, LOB values are inserted (not loaded) into auxiliary tables during the RELOAD phase as each row is loaded into the base table. Each index on the auxiliary table is also updated as part of the insert operation.

Parent topic: LOAD