CA RI Manager can be used to create table Referential Integrity (RI) that are not recognized by DB2, however are recognized by CA RC/Extract for DB2 for z/OS (RCX) and some other CA Database Management for DB2 tools. It is called User Defined RI and can be seen in CA 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
This tells you that an RI/MANAGER relationship will be used.
If you see something like this:
DB2 RELATIONSHIP rel-name INDICATES THAT THIS OBJECT
IS A CHILD OF authid.table_name, PROCESSED IN
You can be sure it is a DB2 defined relationship.