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.
    Lok (Lock Manager Information - KDPLOK1)
    View information about current locking activity, latch statistics counters, and IRLM latch contentions.
    Start of changeAggre (Db2 Aggregated Accounting - KDPAGAC)End of change
    Start of changeView information about Db2 aggregated accounting times. Select a connection type to view additional details (Class 1,2,3, Suspensions, Other).End of change
    Start of changeProf (System Profiles - KDPPROF)End of change
    Start of changeView information about system profiles.End of change
    Start of changeDDF (DDF Statistics and DDF Location Statistics - KDPQDST)End of change
    Start of changeView DDF statistics and DDF location statistics.End of change
    Start of changeBind (Bind Statistics - KDPQTST)End of change
    Start of changeView bind statistics.End of change
    Start of changeCMD (Db2 Command Statistics - KDPQ9ST)End of change
    Start of changeView Db2 command statistics.End of change
    Start of changeDMData (Data Manager Stats Detail - KDPQIST)End of change
    Start of changeView Data Manager statistics.End of change
    Start of changeAppl (Remote Application Statistics - KDPAPPL)End of change
    Start of changeView detailed statistics about the remote application.End of change
    Start of changeUser (Remote User Statistics - KDPUSER)End of change
    Start of changeView detailed statistics about the remote user.End of change