Show dependent Views of a View using RC/Query

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

A user has a number of views which are dependent on another view. Is there another method other than using the DI Drop Impact report to see the
dependent view within RC/Query for Db2 for z/OS (RCQ).

Resolution

The way to do this is to use the O=Object Dependency on the view.

Example : Three views TSTVIEW3 is used by TSTVIEW2 and TSTVIEW2 is used by TSTVIEW1


Page 1:

  DB2 Object ===> V                       Option  ===> O    Where => N
   View Name ===> TSTVIEW1              > Creator ===> *                      >
   Qualifier ===> *                     > N/A     ===> *                      >
 Loc: LOCAL ---------- SSID: SSID ----------AUTHID1 -          LINE 1 OF 3    >
 CMD      VIEW001             V001CRTR  VIEW002             V002CRTR
 ________ TSTVIEW1            AUTHID
 ________                               TSTVIEW2            AUTHID
 ________

 

This shows that TSTVIEW2 (VIEW002) is used by TSTVIEW1 (VIEW001)

 

PF11 to page 2

 DB2 Object ===> V                       Option  ===> O    Where => N
  View Name ===> PRJMGRS1              > Creator ===> *                      >
  Qualifier ===> *                     > N/A     ===> *                      >
Loc: LOCAL ---------- SSID: SSID ----------AUTHID1   -          LINE 1 OF 3  <
CMD      VIEW001             VIEW003             V003CRTR
________ TSTVIEW1
________
________                     TSTVIEW3            AUTHID

 

This shows that TSTVIEW3 (VIEW003) is used by TSTVIEW2 (VIEW002)

There is also a Batch Report via RC/Query command : BR           - Invoke batch reporting facility

 

OBJDEP   (O)  DEP OBJS STARTING WITH VIEWS

REPORT/QUERY     DESCRIPTION                    ITEM NAME          CREATOR
_  VIEW     (V)  INFORMATION RELATING TO VIEWS  __________________ ________
s OBJDEP   (O)  DEP OBJS STARTING WITH VIEWS   TSTVIEW1__________  AUTHID_

 

The report produced looks like this:

                 DB2 SSID:SSID     ---------- RC/Q OBJECT DEPENDENCY
LOCATION: LOCAL
VIEW001             V001CRTR  VIEW002             V002CRTR  VIEW003  V003CRTR
TSTVIEW1            AUTHID
                              TSTVIEW2            AUTHID
                                                            TSTVIEW3 AUTHID

Additional Information

View Reports section in the RC/Query User Guide.

O (View Object Dependency)

Displays all objects that are dependent upon the selected views. Creator IDs for certain objects are displayed when the Qualify feature is turned on. The View Level option controls the number of view levels that are displayed.

In the RC/Query PROFILE there is a value called "PROCESSING OPTIONS:   (For Query Reports) : VIEW LEVELS

This specifies how many view levels should be included in the object dependency reports. The value in this field can also be changed with the VLVL scrolling
command. Valid values are: ALL :- Display all view levels or :- 0-999 Display the specified number of view levels.

The VLVL (View Level) "command line" command limits the number of view levels generated in the object dependency reports without invoking the RC/QUERY Profile Variables screen.
The command will take effect the next time an object dependency report is generated. Valid values are the same as for the profile option.