Loading approx 200,000 rows into a 60 million row partitioned
table/space resume yes.
The reload phase completes indicating all rows were loaded to the
Then dfsort thows a message during the sort phase that states sort
capacity exceeded, abeding the utility with a s04e.
When the utility was cancelled the the tablespace was fine but all of
the indexes were in rebuild pending, which once done
Completed the load basically.
I am of the opinion that terminating the utility and rebuilding the
indexes in this way was the only way to proceed with this load, without
the obvious restore and try again.
Other staff in the office are asserting that I could have done a
restart(current) or a restart(phase) of the utility after correcting the
space issue with the sortwrks. However the manual on restarting a load
utility has two notes related to table 42, on restarting in the sort
4. The utility can be restarted with either RESTART or RESTART(PHASE).
However, because this phase does not take checkpoints, RESTART is always
re-executed from the beginning of the phase.
10. |Any job that finished abnormally in the RELOAD, SORT, BUILD, |or
SORTBUILD phase restarts from the beginning of the RELOAD phase.
Which means to my way of thinking that it would reload 200,000
duplicate rows, and really mess up the build index phase because there
would be 200,000 rows on the table with no keys to put into the index.
which basically means there is no restart capability for a load utility.
Am I interpreting this right or am I missing something?
This e-mail and any attachments are intended only for those to which it is addressed and may contain information which is privileged, confidential and prohibited from disclosure and unauthorized use under applicable law. If you are not the intended recipient of this e-mail, you are hereby notified that any use, dissemination, or copying of this e-mail or the information contained in this e-mail is strictly prohibited by the sender. If you have received this transmission in error, please return the material received to the sender and delete all copies from your system.
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm