Viewing statement-level dependencies for a package

Db2 13 FL 502 For those packages that have a DEPLEVEL value of S (statement), you can view the statement-level object dependencies. These dependencies help you determine which statements are impacted by a change to an object.

Procedure

To view statement-level dependencies for a package:
  1. On the DB2 Administration Menu (ADB2) panel, specify option 1, and press Enter.
  2. On the System Catalog (ADB21) panel, specify option K (for packages), and press Enter.
  3. On the Packages (ADB21K) panel, specify the DPS line command next to the package for which you want to view the statement-level dependencies. The package must have a value of S (statement) in the Dep Lev column; otherwise, the package has no statement-level dependencies.

    Alternatively, you can first enter the DP (show dependencies) line command, and then on the Package Dependencies (ADB21KD) panel, specify the DPS command.

    The Package Dependencies at Statement Level (ADB21KDS) panel displays the dependencies between statements in the package and the objects referenced by those statements (the information from the Db2® catalog table SYSPACKSTMTDEP):
    Figure 1. Package Dependencies at Statement Level (ADB21KDS) panel
    ADB21KDS  ---- DD1A Package Dependencies at Statement Level   Row 1 to 12 of 12  
Command ===>                                                   Scroll ===> 0010  

Line commands:                                                                   
 I - Interpretation  RO - Role as package owner  SB - show base object           
 SQ - Show the SQL statement  ? - Show all line commands                         
                                                Pkg
S  Object Name        Schema   Contoken         Type         Statement ID
   *                  *        *                *                       *
-- ------------------ -------- ---------------- ---- --------------------
   SYSTSTAB           DSNDB06  IB65DC10172C8E40                    695679
   SYSTABLES          SYSIBM   IB65DC10172C8E40                    695679
   SYSTABLESPACE      SYSIBM   IB65DC10172C8E40                    695679
   SYSTSSP            DSNDB06  IB65DC10172C8E40                    695679
   DSNDTX01           SYSIBM   IB65DC10172C8E40                    695679
   DSNDSX01           SYSIBM   IB65DC10172C8E40                    695679
   SYSTABLES          SYSIBM   IB65DC10172C8E40                    695680
   SYSTSTAB           DSNDB06  IB65DC10172C8E40                    695680
   DSNTSTX01          SYSIBM   IB65DC10172C8E40                    695680
   SYSTABLES          SYSIBM   IB65DC10172C8E40                    695681
   SYSTSTAB           DSNDB06  IB65DC10172C8E40                    695681
   DSNDTX01           SYSIBM   IB65DC10172C8E40                    695681
******************************* END OF DB2 DATA *******************************
  4. Optional: If you want to view the SQL statement for any of these dependencies, use the SQ line command.