How to determine if CA RC/Extract is using User Defined RI to process tables.

Document ID : KB000021246
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

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.

 

Answer:

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.

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.