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

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

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

Question Posted / nimsatprasad

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

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / kiran bhamare

Hi,

You can do same by following tric.
STOP database and start it again using DB2 commands.
1)-DIS DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to dsisplay status of DB
2)-STOP DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to stop database.
3)-START DATABASE (DATABASENAME) SPACE (TABLESPACENAME) ACC
(FORCE)
to start database.

Is This Answer Correct ?

1 Yes

2 No

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

Answer / sudipta

first ckeck the ststus of the table by using the query:-

load query table <tab_name>;

load query table <tab_name> set all immidiate unchecked;

after the command execute all pending state will be removed

Is This Answer Correct ?

2 Yes

4 No

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

Answer / sudipta

sorry the last answer is

db2= >> set integrity for <table_name> all immediate unchecked

Is This Answer Correct ?

2 Yes

4 No

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

Answer / suresh

we need to clear the flags of that particular utilities and
try to load the data into the database.

Is This Answer Correct ?

1 Yes

4 No

Post New Answer