In DB2, copy-pending status can occur for various reasons, primarily during UNLOAD/LOAD.

“COPY PENDING” means restricted state of TS. TS means Table Space.

UNLOAD

When the TS, which is involved is in Copy pending status (Restricted status), we get an error during “UNLOAD”. The solution is to use “QUIESCE NO”  in the Unload card. The ‘YES” option states DB2 is notified that unload is done. The ‘NO’  option states DB2 is not notified.

LOAD

During LOAD with LOG NO option, and without taking an Image copy, it puts TS into “COPY PENDING” status.

The solution for this is possible in two ways:

•   a) We can take image copy (SHRLEVEL REFERENCE) and do the LOAD
•   b) Reorganize the TS and do the LOAD.

Other possible ways are as follows: (ref: IBM)

• LOAD REPLACE LOG YES
• LOAD REPLACE LOG NO with an inline copy
• REORG LOG YES
• REORG LOG NO with an inline copy
• REPAIR SET with NOCOPYPEND

Check here for more stuff on “Copy pending status in LOAD.“