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
Can we insert update delete in view?
What is commit in db2?
Define db2 and its databases?
What is check constraint. Explain with example.
What happens in bind step in a db2 program?
What is the picture clause of null indicator variable?
Explain how can you do the explain of a dynamic sql statement?
What is the difference between using bind () and rebind () methods of naming class?
How many types of page locks can be held in db2?
How do I delete a column in db2?
What is the difference between cursor stability and repeatable read isolation levels?
How do I delete a table in database?
Define db2.
What is the difference between bind and rebind in db2?
When reorg is used?