Reply to comment

COPY PENDING
------------

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.ugref%2Fsrc%2Ftpc%2Fdb2z_copypendingstatus.htm

What is copy pending?

A state in which, an Image Copy on a table needs to be taken, When the table is in this status, it is available in read mode, only for queries. No update is allowed to

this table.

Why copy peding status is set?

The copy pending status will be set when image copies job fails while copying the data to a Tape or DASD. So the Tablespace status will be in copy pending status and

the table will be available in read only mode and no updates would be allowed to the table.

How to resolve copy pending?

1)To remove the COPY PENDING status, you take an image copy

OR

2)Use REPAIR utility

-REPAIR SET TABLESPACE NOCOPYPEND

or

3) You can execute the following query (This command will restart the tablespace and reset all the pending states on the tablespace and the table will be back in RW

(read write mode).

-START DATABASE(dbname) SPACE(tablespace-name) ACESS(FORCE) . 

 

CHECK PENDING
--------------

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.ugref%2Fsrc%2Ftpc%2Fdb2z_checkpendingstatus.htm

what is check pending status?

When a table is LOADed with ENFORCE NO option, then the table is set to CHECK PENDING status. This means that the LOAD utility did not perform constraint checking.
The check pending status will be set when Referential Intergrity voilation occurs between data in parent table with child table. 

 

How to resolve Check pending?

1)To remove the CHECK PENDING status, you can Use REPAIR utility

-REPAIR SET TABLESPACE NOCHECKPEND

or

2) You can execute the following query (This command will restart the tablespace and reset all the pending states on the tablespace and the table will be back in RW

(read write mode).

-START DATABASE(dbname) SPACE(tablespace-name) ACESS(FORCE) .