View previous topic :: View next topic
|
Author |
Message |
vikas kumar jain
New User
Joined: 02 Aug 2006 Posts: 9 Location: noida
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
vikas kumar jain
New User
Joined: 02 Aug 2006 Posts: 9 Location: noida
|
|
|
|
yeah i've....bt cudn't able to run the "Check Data Utility"...
Actually don't kno how to run it... |
|
Back to top |
|
|
vikas kumar jain
New User
Joined: 02 Aug 2006 Posts: 9 Location: noida
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Which error did it throw?
We can't be much help if we don't know what happened. . .
Are you one of the DBAs? If not, you may not have permission. |
|
Back to top |
|
|
Suryanarayana.tadala
New User
Joined: 03 Nov 2005 Posts: 43 Location: St.Louis
|
|
|
|
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 |
|
|
|