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 meant by union and union all?
Explain about mirror activator disk mirroring?
What is the use of db2 optimizer?
What is page size in db2?
What is cursor with hold option in db2?
How to run db2 command in windows?
List out the data types available.
How do I connect my db2 database to ibm?
What is bind plan?
What is rct?
What is nvl in db2?
What is alias in db2?
What is the meaning concurrency in the db2 database?
Name the lockable units in DB2?
What is the physical storage length of timestamp data type?
