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:
- Alter the table space to NOT LOGGED.
- 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.
- Alter the table space back to LOGGED.
- Take an image copy of the table space.