What is COPY PENDING status ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is 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.

(Continued on next question...)

Other Job Interview Questions

• DB2 can implement a join in three ways using a merge join...
• What are the three lock types?
• Give some example of statistics collected during RUNSTATS?
• an I alter a table when other user is selecting some columns ...
• What is the error code for Unique Index Violation?
• What is the purpose of the QUIESE Utility?
• On the create tablespace, what does the CLOSE parameter do?
• What happens to a tablespace when its recovery information has been removed and a full recovery is no longer possible?
• When can an insert of a new primary key value threaten referential integrity ?
• What is the purpose of the WHENEVER statement?
• More...