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

How to run db2 command in windows?

652


What is query_cache_limit?

545


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

628


What is deadlock in db2?

583


What is plan in cobol db2?

595






Discuss about db2 bind?

671


What is the clustering index in the db2 database?

584


What is cursor in dbms?

593


What is the result of open cursor statement?

638


what is the role of the cursor in db2?

643


What is the max length of sqlca?

767


How to check last update on table in db2?

628


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

710


What is a cursor in programming?

594


List out the data types available.

704