Running LOAD RESUME YES SHRLEVEL CHANGE without logging

If you run the LOAD utility with the RESUME YES SHRLEVEL CHANGE options, you can improve the performance by limiting the logging that is done by DB2® during the LOAD operation.

Procedure

To run LOAD RESUME YES SHRLEVEL CHANGE without logging:

  1. Alter the table space to NOT LOGGED.
  2. Run the LOAD job with the RESUME YES SHRLEVEL CHANGE options.

    If the LOAD job fails, you cannot restart it, because the target is a NOT LOGGED table space. Instead terminate the job, recover the data from a previous image copy, and rerun the LOAD job.

  3. Alter the table space back to LOGGED.
  4. Take an image copy of the table space.