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 does sqlcabc has?
What is db2 command?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the role of the data page in the db2 database?
What is db2 purescale?
Why do we use cursor?
What is bind in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is alias in db2?
What is concurrency?
On which levels locks can be applied?
What is sqlca?
What is a system catalog table in db2?
Mention the different locking levels that are available in db2.
Which command is used to connect to a database in DB2 ? Give the Syntax.