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.