DB2 Foreign Keys Are Not Differed From "ENFORCED" And "NOT ENFORCED"

(Doc ID 2345225.1)

Last updated on JANUARY 10, 2018

Applies to:

Oracle Enterprise Metadata Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After harvest from IBM DB2 database, Oracle Enterprise Metadata Management (OEMM) display the foreign keys (FKs) but it is not possible to differ what is ENFORCED and NOT ENFORCED.

 

Below is a representation from a SQL tool showing how the DB2 FKs are defined in the database:

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms