View previous topic :: View next topic
|
Author |
Message |
sonipankaj
New User
Joined: 23 Nov 2005 Posts: 10
|
|
|
|
Hi,
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?
Thanks,
Soni |
|
Back to top |
|
|
sonipankaj
New User
Joined: 23 Nov 2005 Posts: 10
|
|
|
|
Just to avoid confusion,
TAB1 is Parent & TAB2 is Child(Tab1:1 to Tab2: ∞) |
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi sonipankaj
First of all you should avoid your confusion and don't try to confuse others.
When loading a "Parent" table, there will not be any check pending status.
If a check pending status occurred, then the table is a "Child" table, not a "Parent" table.
To avoid the CHECK PENDING, you can choose any one of the option below.
1.Drop the Referential Constraints between two tables and then Load the table.
2. Use SET CURRENT RULES = 'STD' before Loading.
3. Load data to the Parent table before loading the Child table.
If you are using the option 2, your utility will terminate if there is constraint violation.
Note: To remove CHECK PENDING, no need of using REPAIR utility. You can use CHECK DATA utility. That is the recommended utility.
Hope this will help you
Regards
Raghu |
|
Back to top |
|
|
|