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
 

 

Sql Code +162 :: CHECK PENDING

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

New User


Joined: 02 Aug 2006
Posts: 9
Location: noida

PostPosted: Thu Jun 21, 2007 5:56 pm    Post subject: Sql Code +162 :: CHECK PENDING
Reply with quote

Hi all,
I'm facing a problem related to
"Sql Code : +162 TABLESPACE database-name.tablespace-name HAS BEEN PLACED IN CHECK PENDING "

Actually the scene is -

I have three tables - S,P,SP.
S & P are the Parent table while the SP is dependent on both.
So, there is referential integrity b/w the tables.

Now i'm trying to violate the referential integrity rules and trying to change the Primary key of the table S which is having the same value as there in the dependent table SP. So it just throw an error -531 saying that Parent key cann't be changed.
So i drop the primary key and changed that record succesfully ( as referential integrity breaks)
Bt as now i'm trying to set the referential integrity it simply throws the above error ( Check Pending ...)

Plz suggest- How to remove that one ????
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Thu Jun 21, 2007 5:59 pm    Post subject: Re: Sql Code +162 :: CHECK PENDING
Reply with quote

did You look at the manuals ???

Quote:
Explanation: The indicated table space is in check pending status because the ALTER TABLE statement was used to specify a referential constraint or a check constraint (while special register CURRENT RULES = 'DB2') on a populated table. The table space is not generally available until the check pending status is removed from the table space.

System Action: The table space was placed in check pending status.

Programmer Response: Run the CHECK DATA utility. The enforcement of the referential constraint or the check constraint is deferred until the CHECK DATA utility is run.
Back to top
View user's profile Send private message
vikas kumar jain

New User


Joined: 02 Aug 2006
Posts: 9
Location: noida

PostPosted: Thu Jun 21, 2007 6:02 pm    Post subject:
Reply with quote

yeah i've....bt cudn't able to run the "Check Data Utility"...
Actually don't kno how to run it... icon_sad.gif
Back to top
View user's profile Send private message
vikas kumar jain

New User


Joined: 02 Aug 2006
Posts: 9
Location: noida

PostPosted: Thu Jun 21, 2007 6:19 pm    Post subject:
Reply with quote

I also run the Check Data Utility
( By going in the DB2 Utility section and by just giving this name)
...bt it throws the error...
So how to run it...plz describe ?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 21, 2007 7:28 pm    Post subject:
Reply with quote

Hello,

Which error did it throw?

We can't be much help if we don't know what happened. . . icon_confused.gif

Are you one of the DBAs? If not, you may not have permission.
Back to top
View user's profile Send private message
Suryanarayana.tadala

New User


Joined: 03 Nov 2005
Posts: 43
Location: St.Louis

PostPosted: Sat Jun 23, 2007 1:39 am    Post subject:
Reply with quote

please drop down all the table constraints and have proper constraints
As you have dropped th eprimary key from one tabel but as might not have executed runstats/reorg it finds inconsistancy in these constraints..

So i suggest you to go thru this process or ask you DBA to execute a Reorg and Runstats so that your new DDL changes gets into active for all the dependent tables.
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 Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am


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