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 sqlca’s maximum length?
What is the maximum number of columns in a db2 table?
What is dbrm? When it will be created?
What is difference between rollback and commit?
What do you mean by storage group (stogroup)?
Is db2 relational database?
What is query_cache_limit?
What is db2 look?
What is bufferpool in db2?
Give the name of some fields form sqlca.
is it compulsory commitment control in journal?
What are the two types of logging in the db2 database? Explain them.
What is data manager?
How can you classify the locks in db2?
How is deadlock resolved?