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 is the physical storage length of date data type?
Discuss about db2 bind?
What are union and union all?
What does db2 mean?
What is the maximum size of varchar data type in db2?
What is meant by explain?
What is bufferpool in db2?
What language is db2 written in?
What are the full forms of spufi and dclgen and why are they used?
What is a collection in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is lock escalation in db2?
What is scrollable cursor in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Define buffer pool.
