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 is a trigger in the db2 database?
What are union and union all?
Which are the db2 tools to protect integrity of the database?
What is coalesce in db2?
What do you mean by commit and rollback?
Is it possible using max on a char column?
What is db2?
What is precompiler in db2?
Why cursor is used in db2?
is it compulsory commitment control in journal?
Why do we use cursor?
What are db2 tables?
Can we insert update delete in view?
What is the use of predicate?
Is ibm db2 free?
