I have a table(TAB1) which is having a referential constraint on another table(TAB2).
I am loading the TAB1 by using the LOAD utility and at the time of loading TAB2 doesn't have any record. Once, the load of TAB1 is done, the utility forces the TAB2 in check pending state. Then every time I have to run the repair utility, but there is no data in the TAB2, then why DB2 is forcing TAB2 in check pending state?
Is there any way, so that TAB2 will not go in Check pending state?