what is copy pending and check pending ?



what is copy pending and check pending ?..

Answer / sasi

COPY PENDING status
A state in which, an image copy on a table needs to be
taken, In this status, the table is available only for
queries. You cannot update this table. To remove the COPY
PENDING status, you take an image copy or use REPAIR
utility.

CHECK PENDING
When a table is LOADed with ENFORCE NO option, then the
table is left in CHECK PENDING status. It means that the
LOAD utility did not perform constraint checking.

Is This Answer Correct ?    9 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is a DB2 access path?

1 Answers  


Which command is used to remove all rows from a table?

0 Answers  


What is the function of the Data Manager?

2 Answers  


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


Where do you specify them?

0 Answers  






how can i pull up a query which was previously stored in qmf

3 Answers  


What is dbrm?

0 Answers  


Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


What is Call attach facility? How does it work?

1 Answers   Syntel,


What are the advantages of using a PACKAGE?

2 Answers  


How do you pull up a query which was previously saved in qmf?

0 Answers  


What is db2 isolation?

2 Answers  


Categories