R/SYSSTATS panel displays release 13.1.100 for a Db2 12 member post Db2 13 upgrade of other members in the Data Sharing Group
search cancel

R/SYSSTATS panel displays release 13.1.100 for a Db2 12 member post Db2 13 upgrade of other members in the Data Sharing Group

book

Article ID: 399149

calendar_today

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

Issue/Introduction

Sysview Performance Management Option for Db2 for z/OS (IDB2) panel R/SYSSTATS displays Release as 13.1.100 for a Db2 12 member post Db2 13 upgrade
of other members in the Data sharing Group.  Is this expected behavior?


Menu  Print  Tools  Help    SYSVIEW for DB2     SSID LPAR     07/11/25 17:01:29

                                 20.0.16         XXXXXXXX               USERID
    1 SnapShot  2 Buffer Pool  3 EDM Pool  4 Logs  5 Acct Sum  6 More...
 
 R/SYSSTATS      System Snapshot - 30 Seconds                           Row 1/26
                                                                   Delta
 EXCEPTIONS Crit Warn Info   BUFFERS            EDM POOL
  Subsystem   15    6    4    Warnings       0   DBD Lds      0    % Rqsts   0.0
  Database     0    0    0    Act Pools     10   CT  Lds      0    % Rqsts   0.0
  Applicatn   17   10    1    % Act Pgs    0.8   PT  Lds      0    % Rqsts   0.0
                Pct  Max StIn Getpages      16   Dyn Ins      0    % Rqsts   0.0
 LIMITS Current Max  HWM  HWM Sync Rds       0
  Users      11   1   26   11 Cache Hit    0.0  LOCKING
  TSO         0   0    3    0 zHL Utilz    0.0   Suspend     10  LOGGING
  Batch      11   1   26   11 Read Eff  ******   Escalate     0   Dlyd Wrts    0
  DDF Actv    2   0    6    2 Buf Updts      0   Timeout      0   Arch Read    0
  DDF Inac    1   0   16    1 Pg Writes      0   Deadlock     0   Warnings     0
  Dataset  1082   5      1082 Write I/O      0
 
 SQL                     ADDRESS SPACES         THREADS       Active    Complete
  Dynamic          0      DBAS Pg/Sec  0.0       Count            11           2
  Ins+Upd+Dlt      0      SSAS Pg/Sec  0.0       Commits          78           2
  Open+Select      0      IRLM Pg/Sec  0.0       Aborts            0           0
  Accelerator      0      DIST Pg/Sec  0.0       DB2 CPU    18:07.04        0.00
                          DB2 Pct CPU  0.0       Indoubt           0
 STORED PROCEDURES        DB2 WSS (K)    544568
  SQL CALLs        0      DB2 Up Time 138:31:39
  Failures         0
                             POOL FAILURES
 MISCELLANEOUS                RID            0  DATA SHARING
  DDF ACTIVE    Rel 13.1.100  EDM            0   Group  DSNDD0G
  RLF INACTIVE  SRC !SSID                        Member DD0G
 
  Command ===>
   F1=Help       2=Split      3=End        4=Plot                    6=History
                              9=Swap                                12=Return

Resolution

 Menu  Print  Tools  Help    SYSVIEW for DB2     SSID LPARX     07/15/25 15:38:16
                                 20.0.16         SSIDPR20               USERID
   1 DB2 Commands  2 MVS Console  3 SYSVIEW for DB2 Commands
 
 DB2CMDS                 DB2 Commands                                   Row 1/16
 
 DB2 Command                                          Location SSIDPR20
    ===> -dis PROFILE
    ===> -STA PROFILE
    ===> -DIS GROUP
    ===>
 ------------------------------------------------------------------------------
 DSN7100I  !XXXX DSNXXXXX
 *** BEGIN DISPLAY OF GROUP(........) CATALOG LEVEL(V13R1M100)
                   CURRENT FUNCTION LEVEL(V13R1M100)
                   HIGHEST ACTIVATED FUNCTION LEVEL(V13R1M100)
                   HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M510)
                   PROTOCOL LEVEL(2)
                   GROUP ATTACH NAME(....)
 ---------------------------------------------------------------------
 DB2          SUB                     DB2    SYSTEM    IRLM
 MEMBER   ID  SYS  CMDPREF   STATUS   LVL    NAME      SUBSYS IRLMPROC
 -------- --- ---- --------  -------- ------ --------  ----   --------
 ........   0 SSID !SSID     ACTIVE   XXXXX LPAR      IXXX   XXXXIRLM
 ---------------------------------------------------------------------
 SPT01 INLINE LENGTH:        32138
 *** END DISPLAY OF GROUP(........)
 DSN9022I  !SSID DSNXXXXX 'DISPLAY GROUP ' NORMAL COMPLETION
 
 

Upon review of extracted SMF data the red values are as below:

 .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .
 View HGHLVL.LPARSMF.TYPE100.D250513.D1                     Columns 02612 02683
 047929 .            SSIDPTIB        SSID    SSID    \...V.        CLPARV13R1M100
        B000000000000CCFCDECC44444444CCFC4444CCFC4444EE76EB00000000CCFFEFFDFDFFF
        000010002000141077392000000004117000041170000014459010000003111513914100
 -------------------------------------------------------------------------------

1) The Subsystem Name (SSID) and

2) The version string (QWHS_MOD_LVL) from the QWHS (Standard Header). This is the value shown on the R/SYSSTATS screen.

IBM confirmed this is how the setting of the value QWHS_MOD_LVL in a Data Sharing complex with different Db2 versions functions.