Clicky
Skip to Content
Custom Search

Reply to comment

Anonymous
RE:Difference between copy pending and check pending

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) . 

Reply

  • Allowed HTML tags:
      1. Lines and paragraphs break automatically.

    More information about formatting options

    CAPTCHA
    This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Navigation

Click the +1 button  below to share it with your friends and colleagues

 

Share this if you liked it!

 

Disclaimer



Number of Registered users 713
Theme by Dr. Radut.