what needs to be done if a table is in copy pending / check
pending status?
- 5 Answers
- 21531 Views
- Xansa, I also Faced
- E-Mail Answers
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
Which component is responsible for processing sql statements and selecting access paths?
Give the name of some fields form sqlca.
What is check constraint. Explain with example.
What is difference between isnull and coalesce?
Can there be more than one cursor open for any program?
What is a Foreign Key?
What is the information associated with sysibm.syslinks table?
What is null in db2?
How to retrieve rows from a db2 table in embedded sql?
What is the use of db2 optimizer?
Why do we use cursor?
How to view db2 table structure?
What is view db2?
What is null indicator in db2?
What is the reason behind not using select * in embedded sql programs?
