what needs to be done if a table is in copy pending / check
pending status?
Answer Posted / 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 |
Post New Answer View All Answers
What is page size in db2?
Is it possible using max on a char column?
What is the difference between cursor stability and repeatable read isolation levels?
How to connect to db2 database from windows command line?
What is the use of runstats in db2?
Explain how can you do the explain of a dynamic sql statement?
Define db2 and its databases?
Explain package in db2 and its advantages?
What is rebind in db2?
Are views updateable?
What is a buffer in memory?
Which command is used to remove all rows from a table?
How can deadlocks be resolved?
What are the various data types available in db2?
What is db2 bind?