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 |
Which catalog table stores referential constraints?
What is the use of reorg in db2?
What is runstats utility in db2?
What happens in bind step in a db2 program?
What is reorg?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What information is contained in a SYSCOPY entry?
How to resolve -818 sql code in DB2?
What techniques are used to retrieve data from more than one table in a single SQL statement?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Mention the downsides of page level lock.
What is difference between alias and synonym in db2?