Access SYSVIEW Performance Management Option for Db2 from SYSVIEW
search cancel

Access SYSVIEW Performance Management Option for Db2 from SYSVIEW

book

Article ID: 366857

calendar_today

Updated On:

Products

SYSVIEW Performance Management SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

SYSVIEW Performance Management Option for Db2 and SYSVIEW┬« Performance Management have integration that allows a user to benefit from the sharing of DB2 performance data more effectively.  This is useful to display data for monitored Db2 subsystems in the SYSVIEW environment.  For convenience the SYSVIEW for Db2 main menu is able to be invoked from the SYSVIEW VTAM user interface with the IDB2 command.  

Environment

DB2 for Z/OS

Sysview R17

SYSVIEW Performance Management Option for Db2 R20

Resolution

In the SYSVIEW main menu, Sysview for Db2 can be accessed in these ways:

  1. Via the SYSVIEW menus : Option 16 MENU PRODUCTS and then option 14 IDB2. This transfers the user directly to the Sysview for Db2 main menu. 

  2. Enter the IDB2 line command against a selected CICS or IMS transaction to invoke the SYSVIEW for Db2 thread details request (THRDDETL).

  3. Directly from any screen with the "IDB2" command. This transfers the user to the Sysview for Db2 main menu. 

This article will describe (3) above in more detail. 

The "IDB2" command has optional parms : { ssid { db2 command }}

The ssid above is the targeted DB2 subsystem and the command above is a online command in SYSVIEW for DB2. In this context the db2 command passed after the ssid is a DB2 online command, in this sample it is the -DISPLAY GROUP command in DB2. 

Online Commands

So, as an example command such as

IDB2 ssid DB2 -DISPLAY GROUP

or

IDB2 ssid DB2CMDS  -DISPLAY GROUP

will transfer control to Sysview for Db2 then connect to db2 subsystem ssid and  then issue DB2 command "-DISPLAY GROUP". In the above example the "DB2" command in Sysview for DB2 is used to issue DB2 commands such as -DISPLAY but also many others. The "DB2CMDS" and "DB2" commands in SYSVIEW for DB2 are synonymous. 

The screen that will be displayed for this command is the DB2 commands screen showing the generated DISPLAY GROUP report:

Menu  Print  Tools  Help    SYSVIEW for DB2     ssid  LPAR     mm/dd/yy hh:mm:ss
                              20.0            location               authid1
  1 DB2 Commands  2 MVS Console  3 SYSVIEW for DB2 Commands

DB2CMDS                 DB2 Commands                                   Row 1/22

DB2 Command                                          Location location
   ===> -DISPLAY GROUP
   ===>
   ===>
   ===>
------------------------------------------------------------------------------
DSN7100I  !ssid DSN7GCMD
*** BEGIN DISPLAY OF GROUP(DSNssid ) CATALOG LEVEL(V12R1M500)
                  CURRENT FUNCTION LEVEL(V12R1M500)
                  HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M500)
                  HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M501)
                  PROTOCOL LEVEL(2)
                GROUP ATTACH NAME(grp1)
---------------------------------------------------------------------
DB2          SUB                     DB2    SYSTEM    IRLM
MEMBER   ID  SYS  CMDPREF   STATUS   LVL    NAME      SUBSYS IRLMPROC
-------- --- ---- --------  -------- ------ --------  ----   --------
sys1       1 ssid !ssid     ACTIVE   121510 lpar      sys1   ssidIRLM
sys2       2 ssid !ssid     ACTIVE   121510 lpar      sys2   ssidIRLM
sys3       3 ssid !ssid     ACTIVE   121510 lpar      sys3   ssidIRLM
---------------------------------------------------------------------
SCA   STRUCTURE SIZE:    17408 KB, STATUS= AC,   SCA IN USE:    70 %
LOCK1 STRUCTURE SIZE:    46080 KB
NUMBER  LOCK ENTRIES:     8388608
NUMBER  LIST ENTRIES:       86269, LIST ENTRIES  IN USE:          18
SPT01 INLINE LENGTH:        32138
*** END DISPLAY OF GROUP(DSNssid )
DSN9022I  !ssid DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION

 

The DB2 Commands screen can also be accessed in Sysview for DB2 via the TOOLS menu and Option 1 Commands. 

On the above screen the user can also enter other DB2 commands at this point.

The IDB2 command can also go directly to a report screen such as the Sysview for DB2 System Condition Monitor.

IDB2 ssid COND

Menu  Print  Tools  Help    SYSVIEW for DB2     ssid          mm/dd/yy hh:mm:ss
                              20.0            location               authid1


Condition               System Condition Monitor                      Item 1/1

Actions: S=Show Detail, X=Except, T=Threads, A=Subsystem Stats

                                Show
  *         DB2       CA11      Inactive N    Excpt            X     X     X
  Name      Type      System    Time          Count          Condition
  --------  --------  --------  --------   --------          ---------------
_ ssi1      DB2       lpar      hh:mm:ss          6
_ ssi2      DB2       lpar      hh:mm:ss          6
_ ssi3      DB2       lpar      hh:mm:ss          5
_ ssi4      DB2       lpar      hh:mm:ss          0

The System Condition Monitor can also be accessed in SYSVIEW for DB2 via the TOOLS menu and Option 2 CONDITION

To return to SYSVIEW just PF3 back. 

Additional Information

SYSVIEW Integration

Integrate with SYSVIEW for Db2

A site license for SYSVIEW for Db2 is required. To invoke SYSVIEW for DB2, you must have the product properly installed, including the SYSVIEW for DB2 VTAM User Interface.