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

Products

• RC/Extract for DB2 for z/OS

Issue/Introduction

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.

 

 

Environment

Release: R20
Component: RCX

Resolution

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.

Additional Information

Extract Plan Report

 

Expand Details of All Steps

 

Define RI Relationships