Answer Posted / 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 View All Answers
What is bufferpool in db2?
How do I optimize a query in db2?
What is rebind in db2?
Mention the downsides of page level lock.
What is dclgen in db2?
What is consistency token in db2?
What parameters are used to control the free space in DB2?
What is bind plan?
What is null in db2?
Define check constraint.
What is an instance database?
Is it possible using max on a char column?
What is load replace in db2?
What is precompiler in db2?
What are packages in db2?