Difference between copy pending and check pending

Can someone please throw some light on the differences between
copy pending and checkpending?

“; ; ; ;

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

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

Related Posts