Interested to Buy Any Domain ? << Click Here >> for more details...
what needs to be done if a table is in copy pending / check
pending status?
- 5 Answers
- 22817 Views
- Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / sudipta
sorry the last answer is
db2= >> set integrity for <table_name> all immediate unchecked
| Is This Answer Correct ? | 2 Yes | 4 No |
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 |
What is the physical storage length of the data types date, time, and timestamp?
Is db2 relational database?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What's the difference between DB2 active log and archive log? Thanks a lot...
Is db2 a mainframe database?
What is the database descriptor?
What is cursor with hold option in db2?
How to find schema of a table in db2?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
Are views updatable ?
What is image copy?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
COBOL 
