S System Statistics (KDPSUBSM)
KDPSUBSM shows an overview of workload-related information about the DB2 subsystem that you are monitoring.
Navigating to KDPSUBSM
All Active DB2 Subsystems → S System Statistics
Select the corresponding tab to navigate
to:
- BP (Buffer Pools KDPBP52)
- A summary of the buffer pools that are configured and are in use for a DB2 subsystem. A drill down to buffer pool details is available. See Navigating from BP (Buffer Pools KDPBP52).
- Log (Log Management KDPLOGS9)
- An overview of the DB2 log manager active logging and archiving activity.
- EDM (EDM Pool KDPEDM2A)
- An overview of the Environmental Descriptor Manager (EDM) pool activity that is connected with DB2.
- SQL (SQL Count DML KDPSQL1)
- The SQL counts for the Data Manipulation Language (DML) for a DB2 subsystem. See Navigating from SQL Counts DML (KDPSQL1).
DSQL (DB2 Dynamic SQL Cache Filter Options KDPDSQLF)
- Filter options to manage the data returned from the
Dynamic SQL cache especially when many rows are returned. The default
filter option settings display the first 100 statements in descending
order of the accumulated CPU time. The
results are displayed in DB2 Dynamic SQL Cache Statement Statistics (KDPDSQLS),
see Zoom-in from DB2 Dynamic SQL Cache Statement Statistics (KDPDSQLS).
- SSQL (T Thread Detail SQL Text (KDPPSQLT) KDPSSQLS)
- A summary of the contents of the Static SQL cache so that you can determine their performance. See Zoom-in from T Thread Detail SQL Text (KDPPSQLT) (KDPSSQLS).
- Accelerators (KDPACCN)
- Accelerator statistics for all configured accelerators. See Zoom-in from Accelerators (KDPACCN).
- Storage (Storage Consumption KDPSTO2A)
- The DB2 subsystem storage consumption. See Navigating from Storage (KDPSTO2A).
- ZOS Statistics (KDPZOS)
- Overall CPU usage, paging real and virtual storage usage by DB2.
Navigating from BP (Buffer Pools KDPBP52)
Select
the corresponding tab to navigate to:
- Group Buffer Pools (KDPGPOOL)
- A list of active group buffer pools.
- Global Buffer Pool (KDPGBPOL)
- A summary of active group buffer pools for this member of the data sharing group.
Zoom-in from KDPBP52 and KDPGBPOL:
- S. Buffer Pool Details (KDPBPD52)
- The size and the usage of an individual DB2 buffer pool.
- H History
- Near-term History provides the capability to investigate problems that occurred in the recent past.
Zoom in from KDPGPOOL:
- A Sync Read \ GBP Write (KDPGBPSY)
- Sync reads, writes and the hit ratio of a group buffer pool.
- B Prefetch \ Castout (KDPGBPPF)
- Prefetch information and castout information about a group buffer pool.
- L P-Locks (KDPGBPLK)
- The P-Lock information for a group buffer pool.
- S Secondary GBP (KDPGBPSC)
- The DB2 Group Buffer Pool secondary information.
- H History
- Near-term History provides the capability to investigate problems that occurred in the recent past.
Navigating from SQL Counts DML (KDPSQL1)
- DCL (Data Control Language KDPSQL2)
- The system SQL counts for Data Control Language (DCL) for a DB2 subsystem.
- DDL (Data Definition Language KDPSQL3)
- The system SQL counts for Data Definition Language (DDL) for a DB2 subsystem.
- RID List Processing (KDPSQL4)
- The system SQL counts for Record Identifier (RID) List Processing for a DB2 subsystem.
- PARAL (Query Parallelism KDPSQL5)
- The system SQL counts for Query Parallelism for a DB2 subsystem.
- NESTED SQL (SQL Counts - SP/UDF/Triggers KDPSQL6)
- The system SQL counts for Stored Procedures, User Defined Functions, and Triggers for a DB2 subsystem.
- PREP (SQL Counts - Prepares KDPSQL7)
- The system SQL counts for Prepares for a DB2 subsystem.
- ROWID (Row ID KDPSQLD)
- The system SQL counts for Row ID access for a DB2 subsystem.
- CON STMT (Concentrate Statements KDPSQL8)
- The system SQL counts for Concentrate Literals for a DB2 subsystem.
- USE COMMITTED (User Currently Committed KDPSQLA)
- The system SQL counts for Use Committed for a DB2 subsystem.
- WORKFILE (Workfile Storage KDPSQLB)
- The system SQL counts for work files for a DB2 subsystem.
- MISC (Miscellaneous KDPSQLE)
- The system miscellaneous SQL counts for a DB2 subsystem.
Zoom-in from DB2 Dynamic SQL Cache Statement Statistics (KDPDSQLS)
- S. Statistics (KDPDYNST)
- Displays the statistics for a statement in the Dynamic SQL cache.
- T. SQL Text (KDPDYNTX)
- Displays the SQL text of statements in the Dynamic SQL cache.
Zoom-in from T Thread Detail SQL Text (KDPPSQLT) (KDPSSQLS)
- S. Statistics (KDPSTAST)
- Displays the statistics for a statement in the Static SQL cache.
- T. SQL Text (KDPSTATX)
- Displays the SQL text of statement in the Static SQL cache.
Zoom-in from Accelerators (KDPACCN)
- Accelerator Perspective (KDPACC41)
- Accelerator statistics for a selected accelerator.
- DB2 Perspective (KDPACC42)
- Accelerator statistics for a selected DB2.
Navigating from Storage (KDPSTO2A)
- MVS (Storage Above 2 GB KDPSTA2A)
- The MVS Storage Above 2 GB workspace provides an overview of MVS storage above the 2 GB bar. It shows information about storage allocation within the DBM1 and DIST address space.
- Subsy Shr (Subsystem Shared Storage Above 2GB KDPSTO2B)
- The Subsy Shr workspace displays subsystem shared storage above 2 GB including real storage and auxiliary storage.
- Common (Common Storage Below and Above KDPSTC2A)
- The Common Storage workspace provides an overview of the common storage above and below the 2 GB bar.
- LPAR (MVS LPAR Shared Storage Above 2GB KDPSTOLA)
- The LPAR workspace provides an overview of MVS LPAR shared storage above 2 GB.
- Real Aux (Real and Auxiliary Storage KDPSTU2A)
- The Real Aux workspace provides an overview of real and auxiliary storage allocation within DBM1 and DIST address space.
- STMT (Shared Storage above 2GB KDPSTS2A)
- The STMT workspace provides an overview of DB2 subsystem shared storage and shared variable storage above 2 GB.
- IRLM (IRLM Storage KDPSTOIB)
- The IRLM workspace provides an overview of DB2 IRLM storage allocation including HWM and thresholds.