what is copy pending and check pending ?
Answer / 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 |
Is the primary key a clustered index?
Explain about rct in db2?
What is runstats and reorg in db2?
What is host variable?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
what is the use of bind parameter, Replace?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is a collection in db2?
How do I import a csv file into db2?
Mention the location where the output received from explain statement is stored.
What are the functions in DB2?