Access SYSVIEW Performance Management Option for Db2 from SYSVIEW
Article ID: 366857
Updated On:
Products
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:
- 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.
- Enter the IDB2 line command against a selected CICS or IMS transaction to invoke the SYSVIEW for Db2 thread details request (THRDDETL).
- 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.
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
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.
Feedback
