Use index views to access DB2 performance topics

Several index views are available to simplify quick access by DB2 topic to related product views without multilevel drill down, as shown in the following figure:

    W1 =EZDTOPIC=TOPICA===DB2KLA===*========15AUG2008==16:07:25====MVDB2====D====1

DB2 Topic Index - A          View      SSI Monitor ZPARM     Acctg   Trace
Abnormal Terminations        STSERVD    Y   THDAB     -        HT(X)   SUM
Aborts (Rollbacks)           STSERVD    Y   THDAB     -        HT(X)   DTL
Accounting Data              THDACTV    Y    -        -        HT      SUM
  Active Classes              STDB2D     -    -       ZPTRACED   -       -
Active Logs                  STLOGD     Y   LOGUT    ZPLOGD     -       -
Active Threads               THDACTV    Y   THD*     ZPTHDD     -       -
Address Space CPU            STDBSYSD   Y    -        -         -       -
ADMF - Hiperpools            BFRPL      Y    -        -         -       -
Agent Services(Intl DB2)     STAGENTD   Y    -        -         -       -
Allocations-Plan/Package     STBINDD    Y    -        -         -      DTL
Application Defaults          -         -    -       ZPHDECPD   -       -
Archive Logs
  Allocations                 DLOGS      -   ARCWA    ZPARCALD   -       -
  Definitions                  -         -    -       ZPARCDFD   -       -
  Waits                        -         -    -        -        TSTAT   SUM
  Reads for Backout           STLOGD     Y   ARC*      -         -       -
Assistant - Sysplex PRLL     STQPARD    Y    -       ZPDSHRD   HT      SUM
Async I/O                    BFRPL      Y    -        -        TSTAT   SUM
  Totals, DB2                 STBFRPLD   Y   PFTIO     -        HT      SUM
  Totals by DB                PSDBSZ     Y    -        -         -       -
  Totals by Object            PSOBSZ     Y    -        -         -      IO
  Totals per Pool             BFRPL      Y   PFTIO     -        TSTAT   SUM
  Totals by Volume            PSVOLSZ    Y    -        -         -       -
Attach (Connect) Types        -         -    -        -        HT      SUM
Authorization
  Caching                     STAUTHD    Y    -        -         -       -
  Definition/Processing       STAUTHD    Y    -       ZPAUTHD    -       -
  Authorization Failures      STAUTHD    Y    -        -        HT      EV/DTL
Automatic BINDs, Package     STBINDD    Y   BN*      ZPTHDD     -       -
Automatic BINDs, Plan        STBINDD    Y   BIND*    ZPTHDD     -       -
Auxiliary Tables             STSQLD     Y    -        -        TSTAT   SUM

. Link to next page

Start by accessing the DB2 Topic Index Menu, EZDTOPIC, see the following figure:

W1 =EZDTOPIC==========DB2KLA===*========15AUG2008==16:07:25====MVDB2====D====1
DB2 Topic Index
                     . A . B . C . D . E . F . G . H
                     . I . J . K . L . M . N . O . P
                     . Q . R . S . T . U . V . W . X
                     . Y . Z

From this menu, you can select one index view for topics that begin with each letter of the alphabet. At any point when looking at another view, you can enter a view name TOPICx to directly access topics starting with that letter; for example, type TOPIC L for lock information.

From each list of DB2 topics, you can then access detailed information for each of the listed topics.

Multiple hyperlinks are provided for each topic, as applicable:

Field name	Description
View	Provides detailed statistics or status information for one DB2
SSI	Accesses a similar single system image view, for an SSI context with multiple DB2s
Monitor	Accesses the DSERV monitor list view, selecting related monitors if active From DSERV, monitor plot displays that show more history can be accessed.
ZPARM	Accesses a ZPARM view with one or more related DB2 parameters, if applicable
acctg	Accounting data Accesses thread history, if applicable HT indicates that data about this topic entry is included in the Thread History, Thread Query, and Thread Interval History views, and hyperlinks to HTLOGS to provide access to all available thread history data sources. HT(X) provides the same hyperlink, but indicates that this topic entry is also related to an exception category in the Thread Interval History views. TSTAT is shown if the data about the topic entry is only available in the full accounting data. The hyperlink accesses TSTAT for the current THRDHIST trace. A relevant section may be included as a parameter in the hyperlink to help identify where the data is; for example, in the ELAPSED or BPOOL section. (You can delete this parameter to see the complete TSTAT display.)
Trace	Accesses related DB2 trace data EV indicates that a system event trace is available. The hyperlink accesses a related system event view. These traces are only available if the MainView for DB2 - Data Collector component is active. SUM indicates that this item is available in the accounting data in a summary trace. The hyperlink accesses the current traces view (CT), where active trace data can be viewed. The event category (DTL, SQL, SCAN, LOCK, IO, DDF, DDFV) is shown if the event is captured in detail application traces. The hyperlink accesses the current traces view (CT), where active detail trace data can be viewed, or a new detail trace can be activated with the ST command. EV plus the event category (DTL, SQL, SCN, LCK, IO, DDF, DDV) is shown if the event is included in both a system event trace and a detail application trace. The hyperlink accesses a related system event view.

Use index views to access DB2 performance topics

On this page