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 ...)
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.
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.