use repair utility REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCOPYPEN

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

Question Posted / sasi

5 Answers
22839 Views
Xansa, I also Faced
E-Mail Answers

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 check last update on table in db2?

1020

What is release/acquire in bind?

1079

What is a bind in db2?

1007

What is universal database?

1042

How do we specify index to include or not during bind process.

2088

Explain the function of data manager.

1011

How is deadlock resolved?

1103

Is db2 free?

1052

Which component is responsible for db2 startup and shutdown?

999

What are host variables in db2?

1007

What is rct?

1191

What r the comman abends in db2, jcl and cobol???????

2223

What is table space in db2?

977

What is rebind in db2?

1018

What is database manager in db2?

982