what needs to be done if a table is in copy pending / check
pending status?
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 meant by repeatable read?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is a dbrm in db2?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
can we drop column from a table
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
what is the input to PLAN? what is the input to DBRM?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
what is sql abend code -801,-802?
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 are the full forms of spufi and dclgen and why are they used?
What are packages in db2?