Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Setting check pending status back for a tablespace.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Wed Jul 17, 2013 2:30 pm    Post subject: Setting check pending status back for a tablespace.
Reply with quote

Hi,

Recently, I added a foreign key on a table to make it dependent on a table - with delete rule as cascade delete.

After adding the foreign key the tablespace went into check pending status as expected.

I ran the check data utility with DELETE NO option to just check for any exceptions. There were around 10 stale records in the child table which did not had a matching parent.

Later, I forced the CHKP flag, and re-ran the check data utility with DELETE NO option, this time also 10 stale records were listed as expected but the tablespace was still in RW mode. I think the tablespace flag should have been reset to CHKP status. but this did not happen as expected.

Please let me know my if my understanding is correct? If the check data utility does not set the CHKP flag again, then how we can set the CHKP flag in case of RI violations?
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Wed Jul 17, 2013 4:11 pm    Post subject:
Reply with quote

What doesn Foreign key do then?
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Wed Jul 17, 2013 5:10 pm    Post subject:
Reply with quote

I did not understand.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Jul 18, 2013 10:19 am    Post subject:
Reply with quote

Tablespace had status just RW or RW,CHKP...
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Jul 18, 2013 1:39 pm    Post subject:
Reply with quote

Hi,

I found the issue.. we recently migrated to v10 and there is a zparm which determines if the flag has to be set for CHECK DATA utility.

From Manual:
If the utility finds any violation of constraints, the table space that is checked is not
put into the CHECK-pending status. You can force the prior behavior, that a table
space is put into CHECK-pending status when violations or constraints are
detected, by specifying CHECK_SETCHKP=Y on the CHECK_SETCHKP system
parameter.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Jul 18, 2013 3:46 pm    Post subject:
Reply with quote

gylbharat,

You said in the beginning, you have FORCEd off the CHECK-PENDING. If this zParm setting is set, you never would have got check-pending in the first place.

Anyhow Interesting zPARM. Have you checked in your site, whether it is set or not.

I don't why somebody would want an inconsistent data and that too they don't want to know about it and convinced IBM to make a zParm for it.

Regards,
Sushanth
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Jul 18, 2013 6:52 pm    Post subject:
Reply with quote

I added a foreign key... which set the flag to check pending...

This Zparm option only affects check data utility... yes at our site it is set to NO.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Jul 18, 2013 6:53 pm    Post subject:
Reply with quote

Check data will have RC as 04 if there are violations but will not put the table in restrictive state if this option is set as NO.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 6 Fri Nov 18, 2016 1:48 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts XFACILIT class setting for Fault Anal... egrove IBM Tools 2 Thu Aug 11, 2016 8:02 pm
No new posts How to resolve IMS DB status code FM Priyanka Boga IMS DB/DC 3 Fri Jun 10, 2016 1:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us