search cancel

RC/Update for DB2 for Z/OS : Quickly see what type of RI exist on a set of tables

book

Article ID: 243265

calendar_today

Updated On:

Products

RC/Update for DB2 for z/OS

Issue/Introduction

While preparing to edit a set of tables , how to see if there are SYSTEM or USER DEFINED referential integrity defined on the tables. 

Environment

Release : R20

DB2 for Z/OS 

Resolution

The RB (Referential Browse) or the RE (Referential Edit) functions are able to display a set of tables with their referential integrity shown. 

Using the RB or RE report displays the type of RI that are in place....while using a wildcard for the table an indented and referenced list is provided. 

The RI column below as a sample has "S" and "U" in the column.

The "S" means that the table has SYSTEM RI which is defined in DB2.

The "U" means that the table has USER DEFINED RI which was created by RI/Manager. Also, the User Defined items have an "A" on the same line.

This means that the USER DEFINED relationship is ACTIVE. If the User Defined Relationship has been made INACTIVE by RI/Manager it will not be seen on this list.

The full set can be viewed and maintained by RI/Manager.

SYSTEM or DB2 defined RI are always active. 

RUPLIST1 20.0   RC/Update Browse Table Selection -------   yyyy/mm/dd hh:mm:ss
COMMAND ===>                                                  SCROLL ===> CSR

Option      => RB                    Object  => T           Mode  => O ONLINE
Item Name   => T%                  > Creator => AUTHID1   > Where => N
SSID: DT32 ------------------------------------------------------ AUTHID1


Enter S to select the Base Browse Table.

S  XXXX  TABLE                               LVL   CREATOR  GROUP    RI
   ---------------------------------------------------------------------------
__    1. TBDEPT                               1    AUTHID1           S
__    2.   TBDEPT (1+)                        2    AUTHID1           S
__    3.   TBPROJECT                          2    AUTHID1           S
__    4.     TBPROJECT (3+)                   3    AUTHID1           S
__    5.     TBTASK                           3    AUTHID1           S
__    6.       TBEMP_TASK_ROLE                4    AUTHID1           S
__    7.   TBWORK_GROUP                       2    AUTHID1           S
__    8.     TBEMP                            3    AUTHID1           S
__    9.       TBDEPT (1+)                    4    AUTHID1           S
__   10.       TBEMP_TASK_ROLE (6)            4    AUTHID1           S
__   11.       TBPROJECT (3+)                 4    AUTHID1           S
__   12. TBROLE                               1    AUTHID1           S
__   13.   TBEMP_TASK_ROLE (6)                2    AUTHID1           S
   ---------------------------------------------------------------------------
__    1. TABLE1                               1    AUTHID1           U    A
__    2.   TABLE1 (1+)                        2    AUTHID1           U    A
__    3.   TABLE2                             2    AUTHID1           U    A
__    4.     TABLE3                           3    AUTHID1           U    A
__    5.     TABLE3 (4)                       3    AUTHID1           U    A
   ---------------------------------------------------------------------------

Additional Information

Use the RI Manager

RI/Edit Component

Interpreting the Edit Table Selection Panel