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
How is deadlock resolved?
What is runstats and reorg in db2?
Define check constraint.
Explain db2.
What is the purpose of rollback and commit?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is plan in cobol db2?
What r the comman abends in db2, jcl and cobol???????
What is copy pending and check pending in db2?
What is lock escalation in db2?
What is buffer pool?
What is performance tuning db2?
What is dbrm library?
What is dbrm?
What is database alias db2?