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 do I add a column to a table in db2?
What parameters are used to control the free space in DB2?
What is host variable in db2 cobol?
How to check sequence on a table in db2?
Explain various types of locks in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the usage of open cursor command?
How to retrieve rows from a db2 table in embedded sql?
How do I change the column size in db2?
What is blu acceleration in db2?
How to fetch the last row from the table in SQL (db2)?
What is buffer pool and list some of them?
What are db2 objects?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Outputs of explain are with matchcols = 0. What does this signify?
