what needs to be done if a table is in copy pending / check
pending status?

Answer Posted / sasi

use repair utility
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCOPYPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NORCVRPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCHECKPEND

Is This Answer Correct ?    17 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db2 and what is the use of db2 optimizer?

635


What does a deadlock mean in DB2?

641


What is db2 command?

568


What is cursor in dbms?

571


How to access db2 tables in mainframe?

599






Give the name of some fields form sqlca.

605


How many databases can be created inside an instance in db2 ?

587


How many types of page locks can be held in db2?

581


What is a plan and package in db2?

607


Which are the db2 tools to protect integrity of the database?

675


What is db2? Explain.

593


What is a db2 collection?

595


Mention the downsides of page level lock.

694


Is ibm db2 free?

563


What is the maximum No of rows per page?

616