Methods to Display Db2 DISPLAY GROUP information via Database Management Solutions and Sysview
Article ID: 267122
Updated On:
Products
SYSVIEW Performance Management Option for DB2 for z/OS
Database Management for DB2 for z/OS - Administration Suite
Database Management for DB2 for z/OS - Performance Suite
Database Management for DB2 for z/OS - Recovery Suite
Database Management for DB2 for z/OS - SQL Performance Suite
Database Management for DB2 for z/OS - Utilities Suite
DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
SYSVIEW Performance Management
Issue/Introduction
How to obtain Db2 DISPLAY GROUP information using the Database Management Solutions for Db2 for z/OS and Sysview.
Resolution
1. Using SYSVIEW PERFORMANCE MANAGEMENT OPTION FOR DB2 20
Menu item .....1
1 System Statistics
Then menu item....3
3 Display Group
Menu Print Tools Help SYSVIEW for DB2 xxx1 xxxx mm/dd/yy hh:mm:ss
20.0.07 xxxxxR20 authid1
1 Sysplex 2 Data Collectors 3 Display Group
R/DSGRPDTL DISPLAY GROUP DETAIL Item 1/15
SORT N/A
Group Name xxxxxx Catalog level V12R1M502
Attach Name xxx Function Level V12R1M502
Locking Protocol 2 Highest Activated V12R1M502
SCA Status AC Highest Possible V12R1M502
SCA Structure Size 17408 KB SCA in use: 23 %
Lock Structure Size 46080 KB Lock Entries Maximum 8388608
List Entries in Use 19 List Entries Maximum 88468 ( 0.0 % )
SPT01 Inline Length 32138
Encryption Key Label DB2.xxxx.xxx.SYSTEM.0001
Command Paral Paral
Member ID Prefix Status Version LPAR IRLM IRLMPROC Coord Assist
------ -- -------- -------- ------- ---- ---- -------- ----- ------
SSI1 3 !xxx1 ACTIVE 121510 xxxx xxxx xxx1IRLM NO NO
SSI2 1 !xxx2 ACTIVE 121510 xxxx xxxx xxx2IRLM NO NO
SSI3 2 !xxx3 ACTIVE 121510 xxxx xxxx xxx3IRLM NO NO
2. From the main menu of the Database Management Solutions for Db2 for z/OS
Enter command DB2C .........
20.0.08 Database Management Solutions for Db2 for z/OS
OPTION ===> db2C
and then enter the DG command code as below.
20.0.08 --------------- DB2 Command Processor -------------- yyyy/mm/dd hh:mm
COMMAND ===> SCROLL ===> CSR
------------------------------------------------------------- User ID: authid1
DB2 SSID: <ssid> COMMAND CODE: DG
Enter a DB2 Command, or a '?' for a selection list of your last 15 commands
¦ ¦
¦ ¦
¦ ¦
¦ ¦
START STOP DISPLAY
------------------ ------------------ --------------------------------------
SE Accelerator XE Accelerator DE Accelerator DG Group
SD Database XD Database DA Archive DO GrpBufpool
SQ DynQueryCapture XQ DynQueryCapture DB Bufferpool DL Location
SF DDF XB DB2 DZ DBM Active DM Procedure
SS Function Specif XF DDF DH DBM Hist DR Rlimit
SG Procedure XS Function Specif DC DBM Utility DP Stats
SR Rlimit XP Procedure DD Database DT Thread
SX Trace XR Rlimit DF DDF DX Trace
SI Profile XX Trace DQ DynQueryCapture DU IBM Utility
SV Restsvc XI Profile DS Function Specif DK Blockers
XV Restsvc DI Profile DJ Log
Then press enter on the next screen.
-------------------- Display Group Syntax ------------------- yyyy/mm/dd hh:mm
COMMAND ===>
------------------------------------------------------------- User ID: authid1
==> DB2 Command
¦ -DISPLAY GROUP ¦
¦ ¦
¦ ¦
¦ ¦
DISPLAY GROUP
DETAIL
Then this screen is displayed.
------------------- DB2 Command Processor ------------------- yyyy/mm/dd hh:mm
COMMAND ===> SCROLL ===> PAGE
------------------------------------------------------------ User ID: authid1
¦ -DISPLAY GROUP ¦
¦ ¦
¦ ¦
¦ ¦
********************************* TOP OF DATA *********************************
DSN7100I !SSI1 DSN7GCMD
*** BEGIN DISPLAY OF GROUP(xxxxxx ) CATALOG LEVEL(V12R1M502)
CURRENT FUNCTION LEVEL(V12R1M502)
HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M502)
HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M502)
PROTOCOL LEVEL(2)
GROUP ATTACH NAME(xxx )
ENCRYPTION KEY LABEL(DB2.xxxx.xxx.SYSTEM.0001)
---------------------------------------------------------------------
DB2 SUB DB2 SYSTEM IRLM
MEMBER ID SYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC
-------- --- ---- -------- -------- ------ -------- ---- --------
SSI1 3 xxx1 !xxx1 ACTIVE 121510 xxxx xxxx xxx1IRLM
SSI2 1 xxx2 !xxx2 ACTIVE 121510 xxxx xxxx xxx2IRLM
SSI3 2 xxx3 !xxx3 ACTIVE 121510 xxxx xxxx xxx3IRLM
---------------------------------------------------------------------
SCA STRUCTURE SIZE: 17408 KB, STATUS= AC, SCA IN USE: 23 %
LOCK1 STRUCTURE SIZE: 46080 KB
NUMBER LOCK ENTRIES: 8388608
NUMBER LIST ENTRIES: 88468, LIST ENTRIES IN USE: 18
SPT01 INLINE LENGTH: 32138
*** END DISPLAY OF GROUP(xxxxxx )
DSN9022I !xxx1 DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION
3. Using SYSVIEW PERFORMANCE MANAGEMENT R17.0
Menu item 6
6 MENU DB2
then menu item 1
1 DB2LIST
On the DB2LIST, DB2 Subsystem List screen....
Select Formats DEFAULT ACTIVE GROUP with the cursor.
This displays the list of subsystems.
Then use the ROW line command to Display the data row vertically of the subsystem of interest.
SYSVIEW 17.0 lpar ------- DB2LIST, DB2 Subsystem List ------- mm/dd/yy hh:mm:ss
Command ====> Scroll *===> PAGE
------------------------------------------------ Lvl 3 Row 1-32/35 Col 1-79/303
Formats DEFAULT ACTIVE GROUP
Status SRT NoLIM SEL NoDST NoPFX NoOWN NoUPD NoPRT NoCAP
Jobname ssidMSTR ASID 00D3 Jobid STC38204 Db2 12.1.510 SSID DP32
XNET Port 62000 Status CONNECTED
-------------------------------------------------------------------------------
Cmd Atch DSGroup SSID Jobname Status Mon Conn Version Cpf
ROW_____ ssid ssid ssidMSTR ACTIVE MON CONN 12.1.510 !ssid
and the next screen is displayed.
SYSVIEW 17.0 lpar ---------- ROWDISP, Row Display ----------- mm/dd/yy hh:mm:ss
Command ====> Scroll *===> PAGE
------------------------------------------------ Lvl 4 Row 1-30/30 Col 1-79/404
Options INFO NOHEX NOINPUT EXTENDED
Command DB2LIST Title DB2 Subsystem List
Screen DB2LIST Format GROUP RowCur 26 RowTot 35
-------------------------------------------------------------------------------
Jobname ssidMSTR ASID 00D3 Jobid STC38204 Db2 12.1.510 SSID ssid
XNET Port 62000 Status CONNECTED
-------------------------------------------------------------------------------
Cmd Header Stat T M Data
___ Cmd I ROW
___ Atch D ssd
___ DSGroup D DSNssi
___ SSID D ssid
___ Jobname HIGH D ssidMSTR
___ Status D ACTIVE
___ Mon D MON
___ Conn D CONN
___ Version D 12.1.510
___ Cpf D !ssid
___ Dispatch D
___ JobStat D NS
___ CPUTime D 00:03:31
___ . E 00:03:31.557900
___ RealStg D 8.63M
___ . E 9,043,968
___ IOCount D 1660992
___ ClockTime D 98:59:25
___ . E 4/02:59:25.884740
___ Type D STC
___ Jobnr D 38204
___ Stepname D ssidMSTR
___ Procstep D IEFPROC
___ JobClass D STC
___ ASID D 00D3
___ ASCB D 00F63780
___ JobReq D
___ Description D
___ XnetDirId D SYSV000000000377
___ XnetSock D 1
Additional Information
View System Statistics - 3 Display Group - Display Group Detail panel (DSGRPDTL1)
Displays a summary of the information that is provided by the -DISPLAY GROUP DETAIL command. Displays the information about the XCF status of the members. Displays the following information about the data sharing group to which a Db2 subsystem belongs: group mode, SCA status, available lock/list entries, and used lock/list entries.
SYSVIEW® PERFORMANCE MANAGEMENT 17.0 Command Resources
DB2LIST: The DB2LIST command displays information about DB2 address spaces and subsystems that are currently defined or executing.
Feedback
Yes
No
Powered by
