SMF 101 fields, IFCID 3

QWACNID

(EGNX)

RecovTok

Network ID value from CCB (IFCID 3 only)

QWACRINV

Reas

Reason accounting is invoked (IFCID 3 only)

QXST

SQLcounts

SQL statement counters

Formatted for DB2 11 and preceding only. Number of SQL actions of various types, including all of the counters of QXST_V10 and more.

QXST_V10

SQL 

SQL statement counters

Formatted for DB2 10 and as follows only. Number of statements of each type invoked, including Select, Insert, Update, Delete, Describe, Prepare, Open, Close, Create Table, Create Index, Create Tables, Create Synonym, Create Database, Create Store Group, Create View, Drop Index, Drop Table, Drop Tablespace, Drop Database, Drop Synonym, Drop Store Group, Drop View, Alter Store Group, Fetch, Alter Tablespace, Alter Table, Alter Index, Comment On, Lock Table, Grant, Revoke, Incremental Bind, Label On, Set SQL ID, Create Alias and Drop Alias.

QXID

QXID

Control block id

QXLEN

(Integer)

QXLEN

Control block length

QXEYE

(EGNX)

QXEYE

Control block eye catcher

QXSELECT

(Integer)

QXSELECT

# of selects

QXINSRT

(Integer)

QXINSRT

# of inserts

QXUPDTE

(Integer)

QXUPDTE

# of updates

QXDELET

(Integer)

QXDELET

# of deletes

QXDESC

(Integer)

QXDESC

# of describes

QXPREP

(Integer)

QXPREP

# of prepares

QXOPEN

(Integer)

QXOPEN

# of opens

QXCLOSE

(Integer)

QXCLOSE

# of closes

QXCRTAB

(Integer)

QXCRTAB

# of create table

QXCRINX

(Integer)

QXCRINX

# of create index

QXCTABS

(Integer)

QXCTABS

# of create tablespace

QXCRSYN

(Integer)

QXCRSYN

# of create synonym

QXCRDAB

(Integer)

QXCRDAB

# of create database

QXCRSTG

(Integer)

QXCRSTG

# of create storage group

QXDEFVU

(Integer)

QXDEFVU

# of create view

QXDRPIX

(Integer)

QXDRPIX

# of drop index

QXDRPTA

(Integer)

QXDRPTA

# of drop table

QXDRPTS

(Integer)

QXDRPTS

# of drop tablespace

QXDRPDB

(Integer)

QXDRPDB

# of drop database

QXDRPSY

(Integer)

QXDRPSY

# of drop synonym

QXDRPST

(Integer)

QXDRPST

# of drop storage group

QXDRPVU

(Integer)

QXDRPVU

# of drop view

QXALTST

(Integer)

QXALTST

# of alter storage group

QXFETCH

(Integer)

QXFETCH

# of fetchs

QXALTTS

(Integer)

QXALTTS

# of alter tablespace

QXALTTA

(Integer)

QXALTTA

# of alter table

QXALTIX

(Integer)

QXALTIX

# of alter index

QXCMTON

(Integer)

QXCMTON

# of comment on

QXLOCK

(Integer)

QXLOCK

# of lock table

QXGRANT

(Integer)

QXGRANT

# of grant

QXREVOK

(Integer)

QXREVOK

# of revoke

QXINCRB

(Integer)

QXINCRB

# of incremental binds excluding prepares

QXLABON

(Integer)

QXLABON

# of label on

QXSETSQL

(Integer)

QXSETSQL

# OF Set Current SQLID

QXCRALS

(Integer)

QXCRALS

# of create alias

QXDRPAL

(Integer)

QXDRPAL

# of drop alias

QXMIAP

(Integer)

QXMIAP

# of times RID list processing used.

QXNSMIAP

(Integer)

QXNSMIAP

# of times a RID list was not used for a given RID list 

QXMRMIAP

(Integer)

QXMRMIAP

# of times one or more RID lists were not used for a given 

QXSETHV

(Integer)

QXSETHV

# OF Set Host-Variable statements

QXALDAB

(Integer)

QXALDAB

# of alter database

QXDRPPKG

(Integer)

QXDRPPKG

# of drop package statements

QXDSCRTB

(Integer)

QXDSCRTB

# of describe table statements

QXMAXDEG

(Integer)

QXMAXDEG

Maximum degree of parallelism among the parallel groups to 

QXTOTGRP

(Integer)

QXTOTGRP

Total number of parallel groups executed

QXDEGCUR

(Integer)

QXDEGCUR

Total number pf parallel groups which fell back to sequential 

QXDEGESA

(Integer)

QXDEGESA

Total number of parallel groups which fell back to sequential 

QXDEGBUF

(Integer)

QXDEGBUF

Total number of parallel groups that have a planned degree 

QXREDGRP

(Integer)

QXREDGRP

Total number of parallel groups that have a planned degree 

QXNORGRP

(Integer)

QXNORGRP

Total number of parallel groups that have a planned degree 

QXCON1

(Integer)

QXCON1

# of CONNECT type 1 statements executed

QXCON2

(Integer)

QXCON2

# of CONNECT type 2 statements executed

QXREL

(Integer)

QXREL

# of RELEASE statements executed

QXSETCON

(Integer)

QXSETCON

# of SET CONNECTION statements executed

QXSETCDG

(Integer)

QXSETCDG

# of SET CURRENT DEGREE statements executed

QXSETCRL

(Integer)

QXSETCRL

# of SET CURRENT RULES statements

QXCALL

(Integer)

QXCALL

# of SQL CALL statements executed

QXCALLAB

(Integer)

QXCALLAB

# of times a stored procedure ABENDed

QXCALLTO

(Integer)

QXCALLTO

# of times an SQL CALL statement timed out waiting to be 

QXCALLRJ

(Integer)

QXCALLRJ

# of times an SQL CALL statement was rejected

QXRLFDPA

QXRLFDPA

If non-zero  then Query Parallelism is disabled by the RLF 

QXCOORNO

(Integer)

QXCOORNO

Total number of parallel groups executed on a single DB2 due 

QXISORR

(Integer)

QXISORR

Total number of parallel groups executed on a single DB2 due 

QXCRGTT

(Integer)

QXCRGTT

# of create global temporary table

QXSTREOP

(Integer)

QXSTREOP

Total number of times reoptimization occurs

QXXCBPNX

(Integer)

QXXCBPNX

Total number of parallel groups that were intended to run 

QXXCSKIP

(Integer)

QXXCSKIP

The number of times that the parallelism coordinator had to 

QXALOCL

(Integer)

QXALOCL

Number of ASSOCIATE LOCATOR statements executed

QXALOCC

(Integer)

QXALOCC

Number of ALLOCATE CURSOR statements statements executed

QXSTFND

(Integer)

QXSTFND

The number of times a PREPARE request was satisfied by making 

QXSTNFND

(Integer)

QXSTNFND

The number of times a PREPARE request was received but a 

QXSTIPRP

(Integer)

QXSTIPRP

The number of times that an implicit prepare was performed 

QXSTNPRP

(Integer)

QXSTNPRP

The number of times that a prepare was avoided because 

QXSTDEXP

(Integer)

QXSTDEXP

The number of times that an application process' 

QXSTDINV

(Integer)

QXSTDINV

The number of times that a prepared statement was purged from 

QXRNTAB

(Integer)

QXRNTAB

# of rename table

QXCTRIG

(Integer)

QXCTRIG

# of create trigger

QXDRPTR

(Integer)

QXDRPTR

# of drop trigger

QXSETPTH

(Integer)

QXSETPTH

# OF SET CURRENT PATH statements

QXDRPFN

(Integer)

QXDRPFN

# of drop user defined function

QXDRPPR

(Integer)

QXDRPPR

# of drop procedure

QXCDIST

(Integer)

QXCDIST

# OF CREATE DISTINCT TYPE statements

QXDDIST

(Integer)

QXDDIST

# OF DROP DISTINCT TYPE statements

QXCRUDF

(Integer)

QXCRUDF

# OF CREATE FUNCTION statements

QXCRPRO

(Integer)

QXCRPRO

# OF CREATE PROCEDURE statements

QXHOLDL

(Integer)

QXHOLDL

# OF HOLD LOCATOR statements

QXFREEL

(Integer)

QXFREEL

# OF FREE LOCATOR statements

QXREPOP1

(Integer)

QXREPOP1

Total number of parallel groups for which DB2 reformulated 

QXREPOP2

(Integer)

QXREPOP2

Total number of parallel groups for which DB2 reformulated 

QXCRATB

(Integer)

QXCRATB

# OF CREATE AUX TABLE statements

QXSTLOBV

(Integer)

QXSTLOBV

Max storage used for LOB values In KB for accounting  in MB 

QXALUDF

(Integer)

QXALUDF

# OF ALTER FUNCTION statements

QXALPRO

(Integer)

QXALPRO

# OF ALTER PROCEDURE statements

QXROIMAT

(Integer)

QXROIMAT

# of times that direct row access was successful

QXROIIDX

(Integer)

QXROIIDX

# of times an attempt to use direct row access reverted to 

QXROITS

(Integer)

QXROITS

# of times an attempt to use direct row access reverted to 

QXSTTRG

(Integer)

QXSTTRG

# of times a statement trigger was activated

QXROWTRG

(Integer)

QXROWTRG

# of times a row trigger was activated

QXTRGERR

(Integer)

QXTRGERR

# of times an SQL error occurred during execution of a 

QXCASCDP

(Integer)

QXCASCDP

The maximum level of nested SQL cascading. This includes 

QXCAUD

(Integer)

QXCAUD

# of user defined functions executed

QXCAUDAB

(Integer)

QXCAUDAB

# of times a UDF ABENDed

QXCAUDTO

(Integer)

QXCAUDTO

# of times a UDF timed out waiting to be scheduled

QXCAUDRJ

(Integer)

QXCAUDRJ

# of times a UDF was rejected

QXSETCPR

(Integer)

QXSETCPR

# SET CURRENT PRECISION statements executed

QXDCLGTT

(Integer)

QXDCLGTT

# of DECLARE GLOBAL TEMPORARY TABLE stmts

QXDEGDTT

(Integer)

QXDEGDTT

Total number of parallel groups that are part of a query 

QXCRESEQ

(Integer)

QXCRESEQ

# of create sequences

QXALTSEQ

(Integer)

QXALTSEQ

# of alter sequences

QXDROSEQ

(Integer)

QXDROSEQ

# of drop sequences

QXPRRESI

(Integer)

QXPRRESI

# of PREPAREs for which use of an index/indexes were 

QXALTVW

(Integer)

QXALTVW

# of ALTER VIEW

QXALTJR

(Integer)

QXALTJR

# of alter jar

QXMERGE

(Integer)

QXMERGE

# OF times MERGE statement was executed

QXTRTBL

(Integer)

QXTRTBL

# of times TRUNCATE TABLE was executed

QXCRROL

(Integer)

QXCRROL

# of create role

QXDRPROL

(Integer)

QXDRPROL

# of drop role

QXCRCTX

(Integer)

QXCRCTX

# of create trusted context

QXALTCTX

(Integer)

QXALTCTX

# of alter trusted context

QXDRPCTX

(Integer)

QXDRPCTX

# of drop trusted context

QXRNIX

(Integer)

QXRNIX

# of rename index

QXSTXMLV

(Integer)

QXSTXMLV

# Max storage used for XML values

QXRWSFETCHD

(Integer)

QXRWSFETCHD

# Number of Rows Fetched

QXRWSINSRTD

(Integer)

QXRWSINSRTD

# Number of Rows Inserted

QXRWSUPDTD

(Integer)

QXRWSUPDTD

# Number of Rows Updated

QXRWSDELETD

(Integer)

QXRWSDELETD

# Number of Rows Deleted

QXSTCWLP

(Integer)

QXSTCWLP

# of times DB2 parsed dynamic statements because CONCENTRATE 

QXSTCWLR

(Integer)

QXSTCWLR

# of times DB2 replaced at least one literal in a dynamic 

QXSTCWLM

(Integer)

QXSTCWLM

# of times DB2 found a matching reusable copy of a dynamic 

QXSTCWLD

(Integer)

QXSTCWLD

# of times DB2 created a duplicate stmt instance in the the 

QXWFRIDS

(Integer)

QXWFRIDS

# of times a RID list was overflown to a work file because no 

QXWFRIDT

(Integer)

QXWFRIDT

# of times a RID list was overflown to a work file because 

QXHJINCS

(Integer)

QXHJINCS

# of times a RID list append for a Hybrid Join was 

QXHJINCT

(Integer)

QXHJINCT

# of times a RID list append for a Hybrid Join was 

QXRSMIAP

(Integer)

QXRSMIAP

# of times a RID list retrieval for multiple index access was 

QXCREMP

(Integer)

QXCREMP

# of create mask or permission

QXDRPMP

(Integer)

QXDRPMP

# of drop mask or permission

QXALTMP

(Integer)

QXALTMP

# of alter mask or permission

QXCRTSV

(Integer)

QXCRTSV

# of create variable

QXDRPSV

(Integer)

QXDRPSV

# of drop variable

QXDEGAT

(Integer)

QXDEGAT

Total # of parallel groups which fell back to sequential mode 

QXSTARRAY_EXPANSIONS

(Integer)

QXSTARRAY_EXPANSIONS

# of times an array var is expanded beyond 32K

QXSTOREDGRP

(Integer)

QXSTOREDGRP

# of parallel group degree be reduced due to system 

QXSTODGNGRP

(Integer)

QXSTODGNGRP

# of parallel group is degenerated to sequential due to 

QXMAXESTIDG

(Integer)

QXMAXESTIDG

Maximum parallel group estimated degree

QXMAXPLANDG

(Integer)

QXMAXPLANDG

Maximum parallel group planned degree

QXPAROPT

(Integer)

QXPAROPT

# of parallel group degenerated due to the optimization such as 

QXSISTOR

(Integer)

QXSISTOR

# of times that sparse index was disabled because of 

QXSIWF

(Integer)

QXSIWF

# of times that sparse index built a physical work file for 

QXREFTBL

(Integer)

QXREFTBL

# of REFRESH TABLE

QXTRNOWN

(Integer)

QXTRNOWN

# of TRANSFER OWNERSHIP

QXRWSINSRTDAlg1

(Integer)

QXRWSINSRTDAlg1

INSERT algorithm type 1

QXRWSINSRTDAlg2

(Integer)

QXRWSINSRTDAlg2

INSERT algorithm type 2

QXRSDMAD

(Integer)

QXRSDMAD

# of times a DM was not called for RID list retrieval for 

QXR1BOAD

(Integer)

QXR1BOAD

# of times we fetched 1 block and then never went on to fetch 

QXSTSRT

(Integer)

QXSTSRT

# of times RDS Sort was performed

QXSTSRTL

(Integer)

QXSTSRTL

# of times RDS Sort used the IBM Integrate Accelerator for Z 

QXSTSFND

(Integer)

QXSTSFND

# of times a PREPARE request was satisfied by making a copy 

QXSTMLSFND

(Integer)

QXSTMLSFND

# times a PREPARE request was satisfied because db2zai 

QXSTTIMEOUTFromAppl

(Integer)

QXSTTIMEOUTFromAppl

# times a SET CURRENT LOCK timeout SQL statement was 

QXSTTIMEOUTFromProf

(Integer)

QXSTTIMEOUTFromProf

# times a SET CURRENT LOCK TIMEOUT sql was executed from the 

QXSTEHLST

(Integer)

QXSTEHLST

# of execution history lost

QXSTHVLST

(Integer)

QXSTHVLST

# of HV recording lost in execution his

QXSTMLSRT

(Integer)

QXSTMLSRT

# times db2zai sort feedback was used

QXRFMIAP

(Integer)

QXRFMIAP

# of times RID list processing was not used.

QXINCRB_INVSTMT

(Integer)

QXINCRB_INVSTMT

# of incremental bind due to invalid at statement level

QXINCRB_APR_REDRIVE

(Integer)

QXINCRB_APR_REDRIVE

# of redrived incremental bind w/apreuse

QTID

QTID

Control block id

QTLEN

(Integer)

QTLEN

Control block length

QTEYE

(EGNX)

QTEYE

Control block eye catcher

QTALLOCA

(Integer)

QTALLOCA

Allocation attempts

QTALLOC

(Integer)

QTALLOC

Successful allocations

QTABINDA

(Integer)

QTABINDA

Automatic bind attempts

QTABIND

(Integer)

QTABIND

Successful automatic binds

QTINVRID

(Integer)

QTINVRID

Invalid resource-ids

QTBINDA

(Integer)

QTBINDA

Bind (add) sub-commands

QTBINDR

(Integer)

QTBINDR

Bind (replace) sub-commands

QTTESTB

(Integer)

QTTESTB

Test binds (no plan-id)

QTPLNBD

(Integer)

QTPLNBD

Plans bound

QTREBIND

(Integer)

QTREBIND

Rebind sub-commands

QTRBINDA

(Integer)

QTRBINDA

Attempts to rebind a plan

QTPLNRBD

(Integer)

QTPLNRBD

Plans rebound

QTFREE

(Integer)

QTFREE

Free sub-commands

QTFREEA

(Integer)

QTFREEA

Attempts to free a plan

QTPLNFRD

(Integer)

QTPLNFRD

Plans freed

QTAUCHK

(Integer)

QTAUCHK

Total number of authorization checks

QTAUSUC

(Integer)

QTAUSUC

Total number of successful auth checks

QTDSOPN

(Integer)

QTDSOPN

Number of datasets currently open

QTMAXDS

(Integer)

QTMAXDS

Maximum number of ds opened concur

QTAUCCH

(Integer)

QTAUCCH

#successful auth checks for plans using a plan cache or 

QTAUPUB

(Integer)

QTAUPUB

#successful auth checks for plan execute authority held by 

QTMAXPB

(Integer)

QTMAXPB

Maximum not in-use data sets

QTPACAUT

(Integer)

QTPACAUT

#successful auth checks for packages using the package auth 

QTPACPUB

(Integer)

QTPACPUB

#successful auth checks for package execute authority held by 

QTPACNOT

(Integer)

QTPACNOT

#package auth checks that could not make use of the package 

QTREOPN

(Integer)

QTREOPN

# of times that not in-use open data sets became in-use

QTPACOW1

(Integer)

QTPACOW1

# of times db2 overwrote an authid in the package auth 

QTPACOW2

(Integer)

QTPACOW2

# of times db2 overwrote a package entry in the package auth 

QTDSDRN

(Integer)

QTDSDRN

# of not in-use data sets closed due to dsmax/dd limit

QTPCCT

(Integer)

QTPCCT

# of infrequently updated data sets that are converted from 

QTSLWDD

(Integer)

QTSLWDD

# of data sets that are not in-use  but are not closed

QTBINDPA

(Integer)

QTBINDPA

Bind (add) package sub-commands

QTBINDPR

(Integer)

QTBINDPR

Bind (rep) package sub-commands

QTPKGBD

(Integer)

QTPKGBD

# packages bound

QTRBINDP

(Integer)

QTRBINDP

Rebind package sub-commands

QTRBNDPA

(Integer)

QTRBNDPA

Attempts to rebind a package

QTPKGRBD

(Integer)

QTPKGRBD

# packages rebound

QTFREEP

(Integer)

QTFREEP

Free package sub-commands

QTFREEAP

(Integer)

QTFREEAP

Attempts to free a package

QTPKGFRD

(Integer)

QTPKGFRD

# packages freed

QTAUTOBA

(Integer)

QTAUTOBA

Attempts to autobind a package

QTPKABND

(Integer)

QTPKABND

# packages autobound

QTPKALLA

(Integer)

QTPKALLA

Attempts to allocate a package

QTPKALL

(Integer)

QTPKALL

# packages allocated

QTAPATTM

(Integer)

QTAPATTM

# Autobind phase-in attempts

QTAPQUED

(Integer)

QTAPQUED

# Autobind phase-in queued

QTAPSUCC

(Integer)

QTAPSUCC

# Autobind phase-in succeeded

QTRACAUT

(Integer)

QTRACAUT

#successful auth checks for routines using the routine auth 

QTRACPUB

(Integer)

QTRACPUB

#successful auth checks for routine execute authority held by 

QTRACNOT

(Integer)

QTRACNOT

#routine auth checks that could not make use of the routine 

QTRACOW1

(Integer)

QTRACOW1

# of times db2 overwrote an authid in the routine auth 

QTRACOW2

(Integer)

QTRACOW2

# of times db2 overwrote a routine entry in the routine auth 

QTRACNAC

(Integer)

QTRACNAC

# of times db2 was not able to add an entry to the routine 

QTPCGBP

(Integer)

QTPCGBP

# of infrequently accessed data sets that are physically 

QTPCUT

(Integer)

QTPCUT

# of utility-access-only data sets that are physically 

QTAUCNOT

(Integer)

QTAUCNOT

#plan auth checks that could not make use of the plan auth 

QTAUCOW1

(Integer)

QTAUCOW1

# of times db2 overwrote an authid in the plan auth cache

QIID

QIID

Control block id

QILEN

(Integer)

QILEN

Control block length

QIEYE

(EGNX)

QIEYE

Control block eye catcher

QISTRLLM

(Integer)

QISTRLLM

The number of times rid list processing interrupted because 

QISTRPLM

(Integer)

QISTRPLM

The number of times rid list processing interrupted because 

QISTRHIG

(Integer)

QISTRHIG

Highest number of rid blocks in use at any one time since db2 

QISTRCUR

(Integer)

QISTRCUR

Number of rid blocks currently in use.

QISTRSTG

(Integer)

QISTRSTG

Number of times rid list processing exhausted virtual 

QISTRMAX

(Integer)

QISTRMAX

Number of times the maximum rid pool storage was exceeded.

QISTCOLS

(Integer)

QISTCOLS

Total number of columns

QISTWFNE

(Integer)

QISTWFNE

Number of times the maximum allowable storage usage limit was 

QISTWFP1

(Integer)

QISTWFP1

How many times a 32KB page TS was used when a 4KB page TS was 

QISTWFP2

(Integer)

QISTWFP2

How many times a 4KB page TS was used when a 32KB page TS was 

QISTRCCI

(Integer)

QISTRCCI

RCCI: Read Currently Committed Insert

QISTRCCD

(Integer)

QISTRCCD

RCCD: Read Currently Committed Delete

QISTRCCU

(Integer)

QISTRCCU

RCCU: Read Currently Committed Update

QISTWMXA

(Integer)

QISTWMXA

Maximum allowable storage usage limit per agent (KB)

QISTWMXU

(Integer)

QISTWMXU

Maximum total storage (KBs) 

QISTWCTO

(Integer)

QISTWCTO

Current total storage (KBs) 

QISTW4K

(Integer)

QISTW4K

Current 4KB table space storage used (KB)

QISTW32K

(Integer)

QISTW32K

Current 32KB table space storage used (KB)

QISTIMAC

(Integer)

QISTIMAC

How many SORT-related DM in-memory workfiles are Active 

QISTIMSC

(Integer)

QISTIMSC

Total Space used for the Currently-Active DM In-Mem 

QISTIMAH

(Integer)

QISTIMAH

High watermark count (maximum number) 

QISTIMSH

(Integer)

QISTIMSH

High watermark count of maximum Space used for the active DM 

QISTSIAC

(Integer)

QISTSIAC

How many Sort-Inmem work- files are Active Currently.

QISTSISC

(Integer)

QISTSISC

Total Space used for the Currently-active Sort-Inmem 

QISTSIAH

(Integer)

QISTSIAH

High watermark count of maximum number Sort-Inmem workfiles 

QISTSISH

(Integer)

QISTSISH

High watermark count of maximum Space used for the active 

QISTWFRHIG

(Integer)

QISTWFRHIG

Highest # of RID blocks overflown(stored) 

QISTWFRCUR

(Integer)

QISTWFRCUR

# of RID blocks currently residing in work file storage. This 

QISTI2AC

(Integer)

QISTI2AC

How many non-SORT related DM in-memory workfiles are Active 

QISTI2AH

(Integer)

QISTI2AH

High watermark count of (maximum number) 

QISTI2OF

(Integer)

QISTI2OF

How many times the type-2 inmem WFs overflowed into a 

QISTIMNC

(Integer)

QISTIMNC

How many times a wf was not created as any type of DM 

QISTASTH

(Integer)

QISTASTH

Agent-level WFDB space usage alert threshold % value (0 to 

QISTSSTH

(Integer)

QISTSSTH

System-level WFDB space usage alert threshold % value (0 to 

QISTAMXU

(Integer)

QISTAMXU

The highest amount of WFDB storage (KB) 

QISTWSTG

(Integer)

QISTWSTG

Current total storage (KB) 

QISTDGTTSTG

(Integer)

QISTDGTTSTG

Total preferred STORAGE (KB) 

QISTDGTTCTO

(Integer)

QISTDGTTCTO

Current total storage (KB) 

QISTDGTTMXU

(Integer)

QISTDGTTMXU

Highest total storage (KB) 

QISTWFSTG

(Integer)

QISTWFSTG

Total preferred STORAGE (KB) 

QISTWFCTO

(Integer)

QISTWFCTO

Current total storage (KB) 

QISTWFMXU

(Integer)

QISTWFMXU

Highest total storage (KB) 

QISTINPA

(Integer)

QISTINPA

Number of DM Fast Insert (Insert Algorithm Level 2) 

QISTINPD

(Integer)

QISTINPD

Number of DM Fast Insert (Insert Algorithm Level 2) 

QISTTRAVMIN

(Integer)

QISTTRAVMIN

FTB threshold: minimum number of index traversals

QISTFTBCANT

(Integer)

QISTFTBCANT

Total number of indexes which meet FTB criteria

QISTFTBCAN

(Integer)

QISTFTBCAN

Total number of indexes which meet FTB criteria and the 

QISTFTBSIZE

(Integer)

QISTFTBSIZE

total memory allocation for all FTBs for this member

QISTFTBNUMP

(Integer)

QISTFTBNUMP

Number of indexes for which FTB existed in the previous run 

QISTFTBNUMC

(Integer)

QISTFTBNUMC

Number of indexes for which FTB exists in the current run of 

QISTINPR

(Integer)

QISTINPR

Number of times IAG2 pipe re-enable was attempted.

QISTINPE

(Integer)

QISTINPE

Number of times IAG2 pipe re-enable was successful.

QISTLRCP

QISTLRCP

CPU time

QISTLRZI

QISTLRZI

zIIP time

QISTLRZE

QISTLRZE

zIIP eligible time

QISTCONDLKF

(Integer)

QISTCONDLKF

Number of failed conditional lock request during insert 

QISTRETRYLK

(Integer)

QISTRETRYLK

Number of times a failed conditional lock request has been 

QTXADEA

(Integer)

QTXADEA

Deadlock count

QTXASLOC

(Integer)

QTXASLOC

lock conflicts

QTXATIM

(Integer)

QTXATIM

Timeout counts

QTXALES

(Integer)

QTXALES

Count of lock escal shared

QTXALEX

(Integer)

QTXALEX

Count of lock escal exclusive

QTXANPL

(Integer)

QTXANPL

Max number of page or row locks held

QTXAFLG1

(Mapped Integer)

QTXAFLG1

First Flag Byte

QTXARLID

(EGNX)

QTXARLID

Resource Limit Table ID

QTXAPREC

(Mapped Integer)

QTXAPREC

How Limit was determined

QTXASLMT

(Integer)

QTXASLMT

Limit in SU's - ASUTIME

QTXACLMT

(Integer)

QTXACLMT

Limit in CPU 16 microseconds

QTXACHUS

(Integer)

QTXACHUS

Highest CPU 16 microsecs used

QTXASLAT

(Integer)

QTXASLAT

Suspend count - latch conflict

QTXASOTH

(Integer)

QTXASOTH

Suspend count - other conflict

QTXALOCK

(Integer)

QTXALOCK

Lock request count

QTXAUNLK

(Integer)

QTXAUNLK

Unlock request count

QTXAQRY

(Integer)

QTXAQRY

Query request count

QTXACHG

(Integer)

QTXACHG

Change request count

QTXAIRLM

(Integer)

QTXAIRLM

Other IRLM request count

QTXACLNO

(Integer)

QTXACLNO

Number of claim requests

QTXACLUN

(Integer)

QTXACLUN

Number of claim requests that were unsuccessful

QTXADRNO

(Integer)

QTXADRNO

Number of drain requests

QTXADRUN

(Integer)

QTXADRUN

Number of drain requests that were unsuccessful

QTXALCMM

(Integer)

QTXALCMM

Main latch contention due to Main latch held

QTXALCMU

(Integer)

QTXALCMU

Main latch contention due to Use Count not being 0

QTXALCSM

(Integer)

QTXALCSM

Secondary latch contention due to Main latch held

QTXACRLK

(Integer)

QTXACRLK

Resource Hash Table latch contention for LOCK

QTXACWLK

(Integer)

QTXACWLK

Workunit Hash Table latch contention for LOCK

QTXACRUK

(Integer)

QTXACRUK

Resource Hash Table latch contention for UNLOCK

QTXACWUK

(Integer)

QTXACWUK

Workunit Hash Table latch contention for UNLOCK

QTXACRCH

(Integer)

QTXACRCH

Resource Hash Table latch contention for CHANGE

QTXACWCH

(Integer)

QTXACWCH

Workunit Hash Table latch contention for CHANGE

QTXACRNT

(Integer)

QTXACRNT

Resource Hash Table latch contention for NOTIFY

QTXACNNT

(Integer)

QTXACNNT

Notify Control Block latch contention for NOTIFY

QTXACRCP

(Integer)

QTXACRCP

Resource Hash Table latch contention for COMPAT

QTXACWCP

(Integer)

QTXACWCP

Workunit Hash Table latch contention for COMPAT

QTXACRAL

(Integer)

QTXACRAL

Resource Hash Table latch contention for ASYNC LOCK

QTXACWAL

(Integer)

QTXACWAL

Workunit Hash Table latch contention for ASYNC LOCK

QTXACWSY

(Integer)

QTXACWSY

Workunit Hash Table latch contention for SYNC

QTXASRCL

(Integer)

QTXASRCL

Resource latch contention counter

QTXAUCNT

(Integer)

QTXAUCNT

Use Count counter for Compat QEs in IRLM

QTXALCCP

(Integer)

QTXALCCP

# of compat qe generated

QTXACGEN

(Integer)

QTXACGEN

Generic latch contentions

QTXACRQF

(Integer)

QTXACRQF

Resource Hash Table latch contention for QUERY FAST

QTXACWQF

(Integer)

QTXACWQF

Workunit Hash Table latch contention for QUERY FAST

QTXADLCL

(Integer)

QTXADLCL

Total number of local deadlocks

QTXATOUT

(Integer)

QTXATOUT

Timeout RLBs purged

QTXARTRY

(Integer)

QTXARTRY

Re-tryable ABENDS

QTXANRTY

(Integer)

QTXANRTY

Non re-tryable ABENDS

QTXASUSP

(Integer)

QTXASUSP

Suspend Exit counter

QTXARSUM

(Integer)

QTXARSUM

Resume Exit counter

QTXASTAT

(Integer)

QTXASTAT

Status Exit counter

QTXADEAD

(Integer)

QTXADEAD

Deadlock Exit counter

QTXATIME

(Integer)

QTXATIME

Timeout Exit counter

QISEFAIL

(Integer)

QISEFAIL

# of fail due to pool full

QISEPAGE

(Integer)

QISEPAGE

Not used  do not reuse page is 1k 370 and 4k on xa

QISECTG

(Integer)

QISECTG

# of req for ct sections

QISECTL

(Integer)

QISECTL

# of load ct sect from dasd

QISECT

(Integer)

QISECT

Not used  do not reuse

QISEFREE

(Integer)

QISEFREE

Not used  do not reuse

QISESTMT

(Integer)

QISESTMT

# of stmts in edm pool

QISEDBDG

(Integer)

QISEDBDG

# of requests for dbd

QISEDBDL

(Integer)

QISEDBDL

# of loading dbd from dasd

QISEKTG

(Integer)

QISEKTG

# of req for pt sections

QISEKTL

(Integer)

QISEKTL

# of load pt sect from dasd

QISEKT

(Integer)

QISEKT

Not used  do not reuse

QISEDSI

(Integer)

QISEDSI

# of inserts for dyn cache

QISEDSG

(Integer)

QISEDSG

# of requests for dyn cache

QISEDBD

(Integer)

QISEDBD

# of pages used for dbd

QISEDFAL

(Integer)

QISEDFAL

# of fail due to dbd pool full

QISEDPGE

(Integer)

QISEDPGE

Number of pages in dbd pool

QISEDFRE

(Integer)

QISEDFRE

Not used  do not reused

QISEDYNP

(Integer)

QISEDYNP

# of pgs used in stmt pool

QISECFAL

(Integer)

QISECFAL

# of fail due to stmt pool full

QISECPGE

(Integer)

QISECPGE

# of pages in stmt pool

QISESKCT

(Integer)

QISESKCT

# of pages used for skct

QISESKPT

(Integer)

QISESKPT

# of pages used for skpt

QISEKFAL

(Integer)

QISEKFAL

# of fail due to stmt skel pool full

QISEKPGE

(Integer)

QISEKPGE

# of pages in skel edm pool

QISEKFRE

(Integer)

QISEKFRE

Not used  do not reused

QISECTA

(Integer)

QISECTA

# of pages used in ct above bar

QISEKTA

(Integer)

QISEKTA

# of pages used in pt above bar

QISESFAL

(Integer)

QISESFAL

# of fail due to stmt abv pool full

QISESPGE

(Integer)

QISESPGE

# of pages in stmt abv edm pool

QISESFRE

(Integer)

QISESFRE

# of free pg in stmt abv edm pol fre

QISEKNFM

(Integer)

QISEKNFM

# of cached not-found record located

QISEKNFA

(Integer)

QISEKNFA

# of not-found record added to cache

QISEKNFR

(Integer)

QISEKNFR

# of nt-found rcrd removed frm cache

QISEKSPG

(Integer)

QISEKSPG

# of shareable static SQL statement requests

QISEKSPA

(Integer)

QISEKSPA

Reserved

QISEKLRU

(Integer)

QISEKLRU

Total stealable SKEL pages

QISEDLRU

(Integer)

QISEDLRU

Total stealable DBD pages

QISEDYLRU

(Integer)

QISEDYLRU

Total stealable DSC pages

QISESQCB

(Integer)

QISESQCB

Storage allocated to PLAN BTB

QISESQKB

(Integer)

QISESQKB

Storage allocated to PACKAGE BTB

QISESQCA

(Integer)

QISESQCA

Storage allocated to PLAN ATB

QISESQKA

(Integer)

QISESQKA

Storage allocated to PACKAGE ATB

QISEKSPA8

(Integer)

QISEKSPA8

Total storage allocated to shareable static SQL statements

QISEDPSL

(Integer)

QISEDPSL

# of requests to look for DPS

QISEDPSC

(Integer)

QISEDPSC

# of times possible row found

QISEDPSM

(Integer)

QISEDPSM

# of times match thrgh text/bind opt

QISEDPSF

(Integer)

QISEDPSF

# of times match found

QBGL

QBGL

QBGL block

QTGSLPLK

(Integer)

QTGSLPLK

# Lock requests for P-locks.

QTGSCPLK

(Integer)

QTGSCPLK

# Change requests for P-locks.

QTGSUPLK

(Integer)

QTGSUPLK

# Unlock requests for P-locks.

QTGSLSLM

(Integer)

QTGSLSLM

# lock requests propagated to XES (L-lock or P-lock) 

QTGSCSLM

(Integer)

QTGSCSLM

# change requests propagated to XES (L-lock or P-lock) 

QTGSUSLM

(Integer)

QTGSUSLM

# unlock requests propagated to XES (L-lock or P-lock) 

QTGSIGLO

(Integer)

QTGSIGLO

# suspends due to IRLM global resource contention

QTGSSGLO

(Integer)

QTGSSGLO

# suspends due to XES global resource contention

QTGSFLSE

(Integer)

QTGSFLSE

# of sync to async heuristic conversions for LOCK request

QTGSDRTA

(Integer)

QTGSDRTA

# global lock or change requests denied or suspended because 

QTGSNTFY

(Integer)

QTGSNTFY

# notify messages sent

QTGSNTFR

(Integer)

QTGSNTFR

# notify messages received

QTGSKIDS

(Integer)

QTGSKIDS

# resources (L-locks or P-locks) 

QTGSPPPE

(Integer)

QTGSPPPE

# times this DB2 was driven to negotiate a pageset/ partition 

QTGSPGPE

(Integer)

QTGSPGPE

# times this DB2 was driven to negotiate a page P-lock due to 

QTGSOTPE

(Integer)

QTGSOTPE

# times this DB2 was driven to negotiate another P-lock type 

QTGSCHNP

(Integer)

QTGSCHNP

# of CHANGEP requests

QTGSPEMX

(Integer)

QTGSPEMX

Max # of engines available for P-lock exit or Notify exit 

QTGSPEQW

(Integer)

QTGSPEQW

# times an engine is not available for a P-lock exit or a 

QTGSFLMG

(Integer)

QTGSFLMG

# false contentions for LOCK and UNLOCK requests.

QTGSCREJ

(Integer)

QTGSCREJ

# failed DB2 lock requests to XES to process without 

QTGSFLGS

(Mapped Integer)

QTGSFLGS

Flags that describe various counters in QTGS section

QTGSLCAIC

(Integer)

QTGSLCAIC

Active IRLM Control Block latch contention counter

QTGSDGBL

(Integer)

QTGSDGBL

Total number of global deadlocks

QTGSLICNT

(Integer)

QTGSLICNT

Local resource contentions

QTGSGICNT

(Integer)

QTGSGICNT

Global resource contentions

QTGSGCONT

(Integer)

QTGSGCONT

Visits to the contention exit but IRLM granted ok

QTGSFCONT

(Integer)

QTGSFCONT

False contentions

QTGSCPLOK

(Integer)

QTGSCPLOK

Plock Exit counter

QTGSCNOTY

(Integer)

QTGSCNOTY

Notify Exit counter

QLID

QLID

Control block id

QLLEN

(Integer)

QLLEN

Control block length

QLEYE

(EGNX)

QLEYE

Control block eye catcher

QLESTATS

(Integer)

QLESTATS

Statistics

QLECREAT

(Integer)

QLECREAT

Internal IBM service fields

QLETRMST

(Integer)

QLETRMST

Internal IBM service fields

QLETRMER

(Integer)

QLETRMER

Internal IBM service fields

QLETRMDL

(Integer)

QLETRMDL

Internal IBM service fields

QLENUMEC

(Integer)

QLENUMEC

Internal IBM service fields

QLENUMEM

(Integer)

QLENUMEM

Internal IBM service fields

QLENUMIC

(Integer)

QLENUMIC

Internal IBM service fields

QLENUMIM

(Integer)

QLENUMIM

Internal IBM service fields

QLESTGEC

(Integer)

QLESTGEC

Internal IBM service fields

QLESTGEM

(Integer)

QLESTGEM

Internal IBM service fields

QLESTGIC

(Integer)

QLESTGIC

Internal IBM service fields

QLESTGIM

(Integer)

QLESTGIM

Internal IBM service fields

QLELOWEC

(Integer)

QLELOWEC

Internal IBM service fields

QLELOWEM

(Integer)

QLELOWEM

Internal IBM service fields

QLELOWIC

(Integer)

QLELOWIC

Internal IBM service fields

QLELOWIM

(Integer)

QLELOWIM

Internal IBM service fields

QLESTG1M

(Integer)

QLESTG1M

Internal IBM service fields

QLELOW1M

(Integer)

QLELOW1M

Internal IBM service fields

QLEUSED

(Integer)

QLEUSED

Internal IBM service fields

QLETIME

QLETIME

Internal IBM service fields

QLENTRDY

(Integer)

QLENTRDY

Internal IBM service fields

QLETIMEW

QLETIMEW

Internal IBM service fields

QLETIMEI

QLETIMEI

Internal IBM service fields

QLETIMET

QLETIMET

Internal IBM service fields

QLETIMEM

QLETIMEM

Internal IBM service fields

Q8STNAME

(EGNX)

IDAAServerID

Accelerator server id

Q8ST_VOld

IDAAInstance

IDAA block for versions earlier than V4

Q8ST_V4

IDAAInstance

IDAA block for versions V4 or later

Q8ST_V6

IDAAInstance

IDAA block for versions V6 or later

QBSP

QBSPBlock

QBSP block