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
Which command is used to remove all rows from a table?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What does sqlcabc has?
Can we update view in db2?
How to run db2 command in windows?
What types of tables are there in the db2 database?
Explain the function done by data manager?
Define db2 and its databases?
What is explain in db2?
Mention the location where the output received from explain statement is stored.
How to resolve deadlock issue
What is a bind in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is null in db2?
What is the latest version of ibm db2?