Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

what is copy pending and check pending ?

what is copy pending and check pending ?..

Answer / sasi

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

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 ?    8 Yes 3 No

Post New Answer

More DB2 Interview Questions

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

When Can you be sure that a query will return only one row?

4 Answers   IBM,

How do you retrieve the first 5 characters of firstname column of db2 table emp?

0 Answers  

What is a correlated sub query?

2 Answers  

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

select 100 records from million records ?

2 Answers   Verizon,

What is bind package and plan in db2?

0 Answers  

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

When is the access path determined for dynamic SQL?

2 Answers  

Explain what a plan is?

3 Answers   CTS,