
Reply to comment
Reply
Click the +1 button below to share it with your friends and colleagues
Share this if you liked it!
Click the +1 button below to share it with your friends and colleagues
t-decoration:none;text-underline:none'>IBM DB2 Certification
LOGOUT
Number of Registered users 713
|
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
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
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) .