what is copy pending and check pending ?
Answer / sasi
COPY PENDING status
A state in which, an image copy on a table needs to be
taken, In this status, the table is available only for
queries. You cannot update this table. To remove the COPY
PENDING status, you take an image copy or use REPAIR
utility.
CHECK PENDING
When a table is LOADed with ENFORCE NO option, then the
table is left in CHECK PENDING status. It means that the
LOAD utility did not perform constraint checking.
| Is This Answer Correct ? | 9 Yes | 3 No |
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is a root page?
What is db2 bind process?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is a Cartesian product?
Can I use LOCK TABLE on a view?
What is a base table?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What are column-name qualifiers used?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What is a Database Request Module(DBRM)?
What are db2 tables?