RI Manager can be used to create table Referential Integrity (RI) that are not recognized by DB2, however are recognized by RC/Extract for DB2 for z/OS (RCX) and some other Database Management for DB2 tools. It is called User Defined RI and can be seen in RI Manager.
When an RCX Source Definition is created where User Defined RI are available the process of selecting parents and children is the same as when DB2 System RI are present. It is not obvious if the RI in use is DB2 System RI or User Defined RI.
To find out if RCX will in fact use User Defined RI during the extract first UPDATE the source Definition.
Type in the PLAN; EXPLODE commands in the command line
The fully expanded "Extract Plan Report" can be seen.
Looking down the report if you see something like this:
RI/MANAGER RELATIONSHIP rel-name INDICATES THAT THIS OBJECT IS A PARENT OF authid.table_name, WHICH WAS PROCESSED IN STEP(S) 1.
This tells you that an RI/MANAGER relationship will be used..........or User Defined RI created by RI/Manager.
If you see something like this:
DB2 RELATIONSHIP rel-name INDICATES THAT THIS OBJECT IS A CHILD OF authid.table_name, PROCESSED IN STEP(S) 1.
You can be sure it is a DB2 defined relationship.