RI is not intended to apply to DDL statements in DB2. It is only intended maintain referential integrity for DML (insert, update, delete SQL statements). DB2 assumes that only DBA's will drop tables, and that they know what they are doing.
I believe that the child tables should be in check pending status if the parent table is dropped.
There is a way to specify that a table cannot be dropped with the RESTRICT ON DROP option of the create or alter table. You can set this on or off with an alter table. This is not related to RI constraints.
If you enable DROPPED TABLE RECOVERY on the create tablespace, you can in theory recover the table (if you have log retain set on).
Last edited by Marcus_A; 02-25-05 at 01:09.
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390