Viewing system statistics

Use the Subsystem Management Summary panel (KDPSUBSM) and related tabs to view information about Db2 subsystem resources.

Procedure

  1. Select the Db2 tab on the OMEGAMON Products panel to show the All Active Db2 Subsystems workspace.
  2. Type a / in the line command field next to the Db2 subsystem of interest and press Enter.
  3. In the option menu, select option 13 (S System Statistics) and press Enter.
    Figure 1. Subsystem Management Summary panel (KDPSUBSM)
    KDPSUBSM panel showing columns and fields
    The DB2 System Resource Manager panel (KDPSUBSM) shows the following tabs:
    Subsys (Subsystem Management Summary - KDPSUBSM)
    View information about workloads for a Db2 subsystem.
    BP (Db2 Buffer Pools - KDPBP54)
    View information about the buffer pools that are configured and in use for a Db2 subsystem.
    Log (Db2 Log Management - KDPLOGSB)
    View information about Db2 log manager active logging and archiving activity.
    EDM (Db2 EDM Pool - KDPEDMN)
    View information about Environmental Descriptor Manager (EDM) pool activity for a Db2 subsystem.
    SQL (SQL Counts - Data Manipulation Language - KDPSQL1)
    View information about the SQL counts for the Data Manipulation Language (DML) for a Db2 subsystem.
    DSQL (Dynamic SQL Cache Filter Options - KDPDSQLF)
    Specify filter options to manage the data returned from the Dynamic SQL cache. The default filter option settings display the first 100 statements in descending order of the accumulated CPU time. The results are displayed in the Db2 Dynamic SQL Cache Statement Statistics workspace (KDPDSQLS).
    SSQL (DB2 Static SQL Cache Statement Statistics - KDPSSQLS)
    View information about the static SQL cache to evaluate performance.
    Accel (Accelerators - KDPACCN)
    View information about configured accelerators.
    Stg (DBM1 and MVS Storage Below 2 GB - KDPSTO2A)
    View information about Db2 subsystem storage consumption.
    Z/OS (DB2 z/OS System Statistics - KDPZOS)
    View information about overall CPU usage, paging, real storage usage, and virtual storage usage by Db2.
    Lock (Lock Manager Information - KDPLOK1)
    View information about current locking activity, latch statistics counters, and IRLM latch contentions.