Termination of LOAD

You can terminate a LOAD utility job.

If you terminate LOAD by using the TERM UTILITY command during the reload phase, the records are not erased. The table space remains in RECOVER-pending status, and indexes remain in the REBUILD-pending status.

If you terminate LOAD by using the TERM UTILITY command during the sort or build phases, the indexes that are not yet built remain in the REBUILD-pending status.

If you terminate a LOAD SHRLEVEL CHANGE, uncommitted records are rolled back, but committed records remain in the table. The table space is not in RECOVER-pending status, and the indexes are not in REBUILD-pending status.

If the LOAD job terminates during the RELOAD, SORT, BUILD, or SORTBLD phases, both RESTART and RESTART(PHASE) phases restart from the beginning of the RELOAD phase. However, restart of LOAD RESUME YES or LOAD PART RESUME YES in the BUILD or SORTBLD phase results in message DSNU257I.

Start of changeIf the LOAD job terminates during the DISCARD phase, a message is issued to indicate that the LOAD job was terminated, an RC=8 is issued, and discard processing completes. End of change

The following table lists the LOAD phases and their effects on any pending states when the utility is terminated in a particular phase.

Table 1. LOAD phases and their effects on pending states when terminated.
Phase Effect on pending status
Reload
  • Places table spaces in RECOVER-pending status, and then resets the status if there are no unique indexes.
  • Places indexes in REBUILD-pending status.
  • Places table spaces in COPY-pending status if there are no unique indexes.
  • Places table spaces in CHECK-pending status.
Build
  • Resets REBUILD-pending status for non-unique indexes.
  • Resets RECOVER-pending status for table spaces with unique indexes, if no INDEXVAL phase is needed.
  • Places table spaces in COPY-pending status.
Indexval
  • Resets REBUILD-pending status for unique indexes.
  • Resets RECOVER-pending status for table spaces with unique indexes.
  • Places table spaces in COPY-pending status.
Enforce
  • Resets CHECK-pending status for table spaces.