IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Check Pending State


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sonipankaj

New User


Joined: 23 Nov 2005
Posts: 10

PostPosted: Mon Jun 15, 2009 3:15 pm
Reply with quote

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
View user's profile Send private message
sonipankaj

New User


Joined: 23 Nov 2005
Posts: 10

PostPosted: Mon Jun 15, 2009 3:25 pm
Reply with quote

Just to avoid confusion,
TAB1 is Parent & TAB2 is Child(Tab1:1 to Tab2: ∞)
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 193
Location: chennai

PostPosted: Tue Jun 16, 2009 12:08 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts SCOPE PENDING option -check data DB2 2
No new posts Check data with Exception Table DB2 0
No new posts How to check whether who renamed the ... JCL & VSAM 3
No new posts No ++JCLIN, APPLY CHECK job JCL & VSAM 1
No new posts EMPTY file check scenario JCL & VSAM 6
Search our Forums:

Back to Top