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
What is db2 and what is the use of db2 optimizer?
What does a deadlock mean in DB2?
What is db2 command?
What is cursor in dbms?
How to access db2 tables in mainframe?
Give the name of some fields form sqlca.
How many databases can be created inside an instance in db2 ?
How many types of page locks can be held in db2?
What is a plan and package in db2?
Which are the db2 tools to protect integrity of the database?
What is db2? Explain.
What is a db2 collection?
Mention the downsides of page level lock.
Is ibm db2 free?
What is the maximum No of rows per page?