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 |
What is a DB2 access path?
Which command is used to remove all rows from a table?
What is the function of the Data Manager?
What is the cascade rule and how does it relate to deletions made with a subselect?
Where do you specify them?
how can i pull up a query which was previously stored in qmf
What is dbrm?
Q3. How will you fetch duplicate values from a DB2 table?
What is Call attach facility? How does it work?
What are the advantages of using a PACKAGE?
How do you pull up a query which was previously saved in qmf?
What is db2 isolation?