CA MICS Analyzer Option for DB2 (DB2) Queries › DB2TCT – DB2 Daily Thread Count by Connection Type

DB2TCT – DB2 Daily Thread Count by Connection Type

Overview

The DB2TCT query generates a daily pie chart for each DB2 region showing the percentage of DB2 threads initiated by each connection type.

The example shows the pie chart for DB2 region RDEA running on SYSID ETET. Most threads, 61 percent, were initiated by DB2CALL. IMSE and SERVER accounted for 17.1 percent and 16.4 percent of the threads, respectively. BATCH accounted for 5.5 percent.

Uses

This query is useful for determining where DB2 activity is originating for each DB2 region. You can refer to the CA MICS data dictionary entry for DB2CONN – Connection Identifier, for complete information regarding interpretation of the connection type values.

Data Extracts

DB2 Daily Thread Count by Conn Type

X-axis (pie slices)

DSPNTHRD – Count of Threads Initiated

Query Defaults

• DB2DSP DAYS timespan file: Cycles 01 and 02
• User code selects yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
• Derivations:

  DATE

  DATEPART(ENDTS)
  

Modifications

The following modifications can be made to the DB2TCT query:

• You can add filter statements to select only a single SYSID or DB2 Region (DB2ID).
• If you do not have the DAYS timespan DB2DSP file active, you can run the query against the DETAIL timespan, Cycles 01 and 02.