Terminating an ALLOW READ ACCESS load operation

An interrupted or canceled load operation that specifies the ALLOW READ ACCESS parameter can also be terminated using the ALLOW READ ACCESS parameter. Using the ALLOW READ ACCESS parameter allows other applications to query the table data while the terminate operation is in progress. As with a load operation in ALLOW READ ACCESS mode, the table is locked exclusively before the data being committed.

About this task

If the index object is unavailable or marked invalid, a load terminate operation in ALLOW READ ACCESS mode is not permitted.

Issuing a LOAD TERMINATE command generally causes the interrupted or canceled load operation to be rolled back with minimal delay. However, when issuing a LOAD TERMINATE command for a load operation where ALLOW READ ACCESS and INDEXING MODE INCREMENTAL are specified, there might be a delay while the load utility scans the indexes and corrects any inconsistencies. The length of this delay depends on the size of the indexes and occurs whether the ALLOW READ ACCESS parameter is specified for the load terminate operation. The delay does not occur if the original load operation failed before the build phase.

Note: The delay resulting from corrections to inconsistencies in the index is considerably less than the delay caused by marking the indexes as invalid and rebuilding them.