Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / thiru
It is a state of the table being locked due to constraint
violation.
For eamaple if you try to nullify the master table alone
and reloading it with some additional records without
deleting detail table records or vise versa, the master and
the child tables whill go to the check pending state.
You can check the same with the help of the below query.
select tabname from syscat.tables where status='C';
To clear the same we can use the following statements.
set integrity for master immediate checked for exception in
master use exception_table;
the violated records will be moved to exception table and
the check pending will be cleared.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are concurrency issues?
What is the difference between nvl and coalesce?
What is the difference between drop table and delete table?
What is a db2 tablespace?
What is the maximum length of sqlca?
What is db2 purescale?
What is query_cache_limit?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Where can you declare a cursor in a cobol-db2 program?
Name the lockable units in DB2?
What is plan in cobol db2?
Is db2 free?
Explain about open switch business continuity software?
What is table space in db2?
