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
- 22753 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 |
difference between group clause and order clause
How to retrieve rows from a db2 table in embedded sql?
List out the data types available.
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is tablespace?
What is a clustered index?
How to connect to db2 database from windows command line?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
What is Skeleton cursor table (SKCT)?
Where besides the DB2 catalog is database object information stored by DB2?
What are the benefits of using the db2 database?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
COBOL 
