RDBPROD: Foreign key constraint verification fails but no bad references seem to exist
edited Jan 10, 2014 7:20AM in Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC) 7 commentsAnswered
Oracle Rdb V7.2-411 on OpenVMS Alpha V8.3
Verifying a foreign key constraint produces the following:
$ rmu/verify/log/noroot/constraints=(constraints=CT_FK_DCAT_ASN_MCAT) ...
%RMU-I-BGNVCONST, beginning verification of constraints for database ...
%RMU-W-CONSTFAIL, Verification of constraint "CT_FK_DCAT_ASN_MCAT" has failed.
%RMU-I-ENDVCONST, completed verification of constraints for database ...
...
The constraint is defined as:
SQL> sho table(constraints) tb_dcat
Information for table TB_DCAT
...
Table constraints for TB_DCAT:
CT_FK_DCAT_ASN_MCAT
Foreign Key constraint
Table constraint for TB_DCAT
Evaluated on UPDATE, NOT DEFERRABLE
Source:
FOREIGN KEY (I_ASN,I_MCAT) REFERENCES TB_MCAT (I_ASN,I_MCAT)
0