Methods to Display Db2 DISPLAY GROUP information via Database Management Solutions and Sysview
search cancel

Methods to Display Db2 DISPLAY GROUP information via Database Management Solutions and Sysview

book

Article ID: 267122

calendar_today

Updated On: 03-13-2025

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.


Use the Db2 Command Processor

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.