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 catalog database in db2?
What is db2 command?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is db2? Explain.
What happens in bind step in a db2 program?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is dbrm? When it will be created?
What is db2 and what is the use of db2 optimizer?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How connect db2 database to datastage?
What is syscat in db2?
What is bind in db2?
What are host variables in db2?
How to get the ddl of a table in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.