Show dependent Views of a View

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

A user has a number of VIEWs which are dependent on another VIEW.

Question:

Is there another method other than using the  DI Drop Impact report to see the dependent VIEW?

Environment:
DB2 for Z/OS
Answer:

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

Example : Three views. PRJMGRS3 is used by PRJMGRS2 and PRJMGRS2 is used by PRJMGRS1.


Page 1:

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

This shows that PRJMGRS2 (VIEW002) is used by PRJMGRS1(VIEW001)

PF11 to page 2


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

This shows that PRJMGRS3 (VIEW003) is used by PRJMGRS2 (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   PRJMGRS1__________  AUTHID_

 

The report produced looks like this:

                 DB2 SSID:SSID     ---------- RC/Q OBJECT DEPENDENCY
LOCATION: LOCAL
VIEW001             V001CRTR  VIEW002             V002CRTR  VIEW003  V003CRTR
PRJMGRS1            AUTHID
                              PRJMGRS2            AUTHID
                                                            PRJMGRS3 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.