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
define clustering index.
What is reorg?
Explain in brief how does db2 determine what lock-size to use?
What is a page in db2?
What is the use of with ur in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is coalesce in db2?
What is bind plan?
What is db2 look?
Can there be more than one cursor open for any program?
What is bind package and plan in db2?
What is universal database?
How and when does the db2 enforces the unique key?
Mention the location where the output received from explain statement is stored.
What is the purpose of using commit?