what is copy pending and check pending ?



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

Post New Answer

More DB2 Interview Questions

Which catalog table stores referential constraints?

1 Answers  


What is the use of reorg in db2?

0 Answers  


What is runstats utility in db2?

0 Answers  


What happens in bind step in a db2 program?

0 Answers  


What is reorg?

0 Answers  






Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


What information is contained in a SYSCOPY entry?

2 Answers  


How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,


What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  


Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,


Mention the downsides of page level lock.

0 Answers  


What is difference between alias and synonym in db2?

0 Answers  


Categories