A CA Fast Unload PART-INDEPENDENCE YES failure leaves the tablespace partition in RO status.

Document ID : KB000012136
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

A CA Fast Unload for DB2 for z/OS (PFU) PART-INDEPENDENCE YES execution is leaving the tablespace partition in RO status if a failure occurs.  What is the best method to reset the partition to RW status? 

Answer:

The -TERM CA UTIL(utilid) DB2 Command Processor command only deletes the restart entries.  This command will not affect the object status. 

Recommendation is to utilize the RESTART(TERM) option within the PFU utility execution.  Otherwise must issue both the -TERM CA UTIL(utilid) and -START DATABASE commands to delete the utility restart entries and reset the partition back to RW status.