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 are foreign keys in db2?
What is nvl in db2?
What is declare cursor?
How many databases can be created inside an instance in db2 ?
Which is faster delete or truncate?
What is difference between rollback and commit?
How connect db2 database to datastage?
What is reorg?
What are the uses of db2 optimizer?
How do I change the column size in db2?
What is db2 command?
What is a bind card?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the purpose of rollback and commit?
What is db2 catalog database?