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
- 22929 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 process of precompiler?
what's the error code for Unique Index Violation?
how to u check the query is executing or not ?where will u check for sqlcode ?
How do I copy a table in db2?
Which catalog tables contain authorization information?
What Utility is used to migrate DB2 from one release to the next?
What are iseries servers?
Is db2 a database?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What does CURRENTDATA option in bind indicate
What is concurrency?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
COBOL 
