|
|
|
The DB2DSP (DB2 Plan Activity) File
---------------------------------------------------------------------------------------------------------------------------------- DICTIONARY RAW AVAILABLE IN DB2 VERSIONS ELEMENT ELEMENT DESCRIPTION MEMBER ELEMENT 8.1 9.1 10.1 ---------------------------------------------------------------------------------------------------------------------------------- DB2ACE DB2 Agent Control Element DB2ACE QWHSACE | X | X | X | DB2ATNM Active Trace Number Mask DB2ATNM QWHSMTN | X | X | X | DB2AUTH Authorization Identifier DB2AUTH QWHCAID | X | X | X | DB2CONN Connection Identifier DB2CONN QWHCCN | X | X | X | DB2CORR Correlation Identifier DB2CORR QWHCCV | X | X | X | DB2CPU DB2 CPU Time DB2CPU QWHUCPU | X | X | X | DB2DDFCT DDF COMMIT Count DB2DDFCT QWHSLUCC | X | X | X | DB2DSGN Data Sharing Group Name DB2DSGN QWHADSGN | X | X | X | DB2DSTSN Destination Sequence Number DB2DSTSN QWHSWSEQ | X | X | X | DB2ISEQ Instrumentation Sequence Number DB2ISEQ QWHSISEQ | X | X | X | DB2LOCN DDF Local Location ID DB2LOCN QWHSLOCN | X | X | X | DB2LUNAM DB2 Logical Unit Name DB2LUNAM QWHSLUNM | X | X | X | DB2MEMN DB2 Member Name DB2MEMN QWHAMEMN | X | X | X | DB2NETID Network Identifier DB2NETID QWACNID | X | X | X | DB2OPID Original Operator ID DB2OPID QWHCOPID | X | X | X | DB2PLAN Plan Name DB2PLAN QWHCPLAN | X | X | X | DB2RELN DB2 Release Identifier DB2RELN QWHSRELN | X | X | X | DB2REQID DDF Requester Location ID DB2REQID QWHDRQNM | X | X | X | DB2STCK DB2 Store Clock At End Event DB2STCK QWHSSTCK | X | X | X | DB2UNIQ DDF Instance Number Identifier DB2UNIQ QWHSLUUV | X | X | X | DSPABORT Abort Requests DSPABORT QWACABRT | X | X | X | DSPACHG Change Request Count DSPACHG QTXACHG | X | X | X | DSPACHUS Highest CPU 16 Microseconds Used DSPACHUS QTXACHUS | X | X | X | DSPACLMT Limit In CPU 16 Microseconds DSPACLMT QTXACLMT | X | X | X | DSPAFLG Flag Byte DSPAFLG QTXAFLG1 | X | X | X | DSPAIETM Class 5 Accum Elapsed Time IFI Calls DSPAIETM QIFAAIET | X | X | X | DSPAIRLM Other IRLM Request Count DSPAIRLM QTXAIRLM | X | X | X | DSPAITTM Class 5 Accum TCB Time IFI Calls DSPAITTM QIFAAITT | X | X | X | DSPALDAB No. ALTER DATABASE Statements DSPALDAB QXALDAB | X | X | X | DSPALGTM Class 3 Accum Wait Archive Log Time DSPALGTM QWACALOG | | | | DSPALGTM Class 3 Accum Wait Archive Log Time DSPALGTM QWAXALOG | X | X | X | DSPALLTM DB2 Lock & Latch Time DSPALLTM QWACAWTL | X | X | X | DSPALOCK Lock Request Count DSPALOCK QTXALOCK | X | X | X | DSPALTIX ALTER INDEX Statements DSPALTIX QXALTIX | X | X | X | DSPALTJR Alter JAR Statements DB2ALTJR QXAALTJR | | X | X | DSPALTST ALTER STORAGE GROUP Statements DSPALTST QXALTST | X | X | X | DSPALTTA ALTER TABLE Statements DSPALTTA QXALTTA | X | X | X | DSPALTTS ALTER TABLESPACE Statements DSPALTTS QXALTTS | X | X | X | DSPALTTX Alter Trusted Context Statements DB2ALTTX QXALTCTX | | X | X | DSPALTVW Alter View Statements DB2ALTVW QXALTVW | | X | X | DSPAMBTM Class 5 Accum Elapsed Time Data Capture DSPAMBTM QIFAAIET | X | X | X | DSPAMLTM Class 5 Accum Elapsed Time Log Records DSPAMLTM QIFAAIET | X | X | X | DSPANDD No. Data Descriptions Returned DSPANDD QIFAANDD | X | X | X | DSPANIF No. Entry/Exit Events Class 5 DSPANIF QIFAANIF | X | X | X | DSPANLR No. Data Capture Log Reads DSPANLR QIFAANLR | X | X | X | DSPANMB No. Data Capture Describes Performed DSPANMB QIFAANMB | X | X | X | DSPANRC No. Log Records Captured DSPANRC QIFAANRC | X | X | X | DSPANRR No. Log Records Returned to Caller DSPANRR QIFAANRR | X | X | X | DSPANTB No. Data Capture Tables DSPANTB QIFAANTB | X | X | X | DSPAPREC How Limit Was Determined DSPAPREC QTXAPREC | X | X | X | DSPAQRY Query Request Count DSPAQRY QTXAQRY | X | X | X | DSPARLH Wait Trace Events Latch Contention DB2ARLH QWACARLH | | | X | DSPARLCT No. Archive Log Suspensions DSPARLCT QWAXALCT | X | X | X | DSPARLID Resource Limit Table ID DSPARLID QTXARLID | X | X | X | DSPASLAT Suspend Count - Latch Conflict DSPASLAT QTXASLAT | X | X | X | DSPASLMT Limit In SU's - ASUTIME DSPASLMT QTXASLMT | X | X | X | DSPASOTH Suspend Count - Other Conflict DSPASOTH QTXASOTH | X | X | X | DSPAUNLK Unlock Request Count DSPAUNLK QTXAUNLK | X | X | X | DSPAWATM Class 3 Accum Wait Log Reads Time DSPAWATM QWACAWAR | | | | DSPAWATM Class 3 Accum Wait Log Reads Time DSPAWATM QWAXAWAR | X | X | X | DSPAWBTM Wait Time - TCP/IP LOB Material DB2AWBTM QWACALBW | | X | X | DSPAWCTM Class 3 Accum Wait Drain Wait Time DSPAWCTM QWACAWCL | | | | DSPAWCTM Class 3 Accum Wait Drain Wait Time DSPAWCTM QWAXAWCL | X | X | X | DSPAWDTM Class 3 Accum Wait Drain Lock Time DSPAWDTM QWACAWDR | | | | DSPAWDTM Class 3 Accum Wait Drain Lock Time DSPAWDTM QWAXAWDR | X | X | X | DSPAWETM Class 3 Accum Wait Service Task Time DSPAWETM QWACAWTE | X | X | X | DSPAWGTM Accum Wait Time Data Sharing Messages DSPAWGTM QWACAWTG | X | X | X | DSPAWJTM Accum Wait Time Global Locks DSPAWJTM QWACAWTJ | X | X | X | DSPAWLTM Accum Wait Time - Latch Contention DB2AWLTM QWACAWTE | | | X | DSPAWLTM Accum Wait Time - Latch Contention DB2AWLTM QWACAWLH | | | X | DSPAWPTM Class 3 Accum Wait Latch Contention DSPAWPTM QWACAWTP | X | X | X | DSPAWRTM Class 3 Accum Wait Read Other Time DSPAWRTM QWACAWTR | X | X | X | DSPAWWTM Class 3 Accum Wait Write Other Time DSPAWWTM QWACAWTW | X | X | X | DSPBEGSC Beginning Store Clock DSPBEGSC QWACBSC | X | X | X | DSPBGTCB Beginning TCB Timer DSPBGTCB QWACBJST | X | X | X | DSPBPNX Parallel Groups Run Cross Data Share DB2BPNX QXXCBPNX | X | X | X | DSPCANM No. Times SQL Call Wait for TCB DSPCANM QWACCANM | X | X | X | DSPCATYP Connecting System Type Code DSPCATYP QMDACTYP | X | X | X | DSPCIMW0 No. of Immed. Sync Write I/O Buffer BP0 DB2CIMWX QBACIMW | X | X | X | DSPCIMW1 No. of Immed. Sync Write I/O Buffer BP1 DB2CIMWX QBACIMW | X | X | X | DSPCIMW2 No. of Immed. Sync Write I/O Buffer BP2 DB2CIMWX QBACIMW | X | X | X | DSPCIMW3 No. of Immed. Sync Write I/O Buffer BP3 DB2CIMWX QBACIMW | X | X | X | DSPCLOSE CLOSE Statements DSPCLOSE QXCLOSE | X | X | X | DSPCLRAB No. Log Record Bytes Written DSPCLRAB QWACLRAB | X | X | X | DSPCLRN No. Log Records Written DSPCLRN QWACLRN | X | X | X | DSPCLS2 No. Accounting Class 2 Data DSPCLS2 QWACFLGS | X | X | X | DSPCLS2C No. Accounting Class 2 Data Collected DSPCLS2C QWACFLGS | X | X | X | DSPCLS3 No. Accounting Class 3 Data DSPCLS3 QWACFLGS | X | X | X | DSPCLS3C No. Accounting Class 3 Data Collected DSPCLS3C QWACFLGS | X | X | X | DSPCLS7C No. Accounting Class 7 Data Collected DSPCLS7C QWACFLGS | X | X | X | DSPCLS8C No. Accounting Class 8 Data Collected DSPCLS8C QWACFLGS | X | X | X | DSPCMTON COMMENT ON Statements DSPCMTON QXCMTON | X | X | X | DSPCOMM2 Commit Phase Two Invocations DSPCOMM2 QWACCOMM | X | X | X | DSPCPLK Change Requests for Physical Locks DSPCPLK QTGACPLK | X | X | X | DSPCPUZ1 Accum CPU Tm Used on z/OS Spec Eng DSPCPUZ1 QWACCLS1_zIIP | X | X | X | DSPCPUZ2 CPU Tm Used in DB2 on z/OS Spec Eng DSPCPUZ2 QWACCLS2_zIIP | X | X | X | DSPCRAL Create Alias DSPCRAL QXCRALS | X | X | X | DSPCRCTX Create Trusted Context Statements DB2CRCTX QXCRCTX | | X | X | DSPCRDAB CREATE DATABASE Statements DSPCRDAB QXCRDAB | X | X | X | DSPCRINX CREATE INDEX Statements DSPCRINX QXCRINX | X | X | X | DSPCRROL Create Role Statements DB2CRROL QXCRROL | | X | X | DSPCRSTG CREATE STORAGE GROUP Statements DSPCRSTG QXCRSTG | X | X | X | DSPCRSYN CREATE SYNONYM Statements DSPCRSYN QXCRSYN | X | X | X | DSPCRTAB CREATE TABLE Statements DSPCRTAB QXCRTAB | X | X | X | DSPCSLM Change Requests Propagated to XES DSPCSLM QTGACSLM | X | X | X | DSPCTABS CREATE TABLESPACE Statements DSPCTABS QXCTABS | X | X | X | DSPCUDNE No. SQL Entry/exit UDF Events DB2CUDNE QWACUDNE | X | X | X | DSPCWLD Times Duplicate Concentrate Dyna Stmnts DB2CWLD QXSTCWLD | | | X | DSPCWLM Times Matched Concentrate Dyna Stmnts DB2CWLM QXSTCWLM | | | X | DSPCWLP Times Parsed Concentrate Dyna Stmnts DB2CWLP QXSTCWLP | | | X | DSPCWLR Times Replaced Concentrate Dyna Stmnts DB2CWLR QXSTCWLR | | | X | DSPDEAD Deadlock Count DSPDEAD QTXADEA | X | X | X | DSPDEFVU CREATE VIEW Statements DSPDEFVU QXDEFVU | X | X | X | DSPDELET DELETE Statements DSPDELET QXDELET | X | X | X | DSPDESC DESCRIBE Statements DSPDESC QXDESC | X | X | X | DSPDGBUF Total Number of Parallel Groups That DB2DGBUF QXDEGBUF | X | X | X | DSPDGCUR Parallel Groups to Seq Cursor Update DB2DGCUR QXDEGCUR | X | X | X | DSPDGESA Parallel Groups to Seq No ESA Sort DB2DGESA QXDEGESA | X | X | X | DSPDPF0 No. Times Dynamic Prefetch Req BP0 DB2DPFX QBACDPF | X | X | X | DSPDPF1 No. Times Dynamic Prefetch Req BP1 DB2DPFX QBACDPF | X | X | X | DSPDPF2 No. Times Dynamic Prefetch Req BP2 DB2DPFX QBACDPF | X | X | X | DSPDPF3 No. Times Dynamic Prefetch Req BP3 DB2DPFX QBACDPF | X | X | X | DSPDRAL Drop Alias DSPDRAL QXDRPAL | X | X | X | DSPDRPDB DROP DATABASE Statements DSPDRPDB QXDRPDB | X | X | X | DSPDRPIX DROP INDEX Statements DSPDRPIX QXDRPIX | X | X | X | DSPDRPKG No. DROP PACKAGE Statements DSPDRPKG QXDRPPKG | X | X | X | DSPDRPRO Drop Role Statements DB2DRPRO QXDRPROL | | X | X | DSPDRPST DROP STORAGE GROUP Statements DSPDRPST QXDRPST | X | X | X | DSPDRPSY DROP SYNONYM Statements DSPDRPSY QXDRPSY | X | X | X | DSPDRPTA DROP TABLE Statements DSPDRPTA QXDRPTA | X | X | X | DSPDRPTS DROP TABLESPACE Statements DSPDRPTS QXDRPTS | X | X | X | DSPDRPTX Drop Trusted Context Statements DB2DRPTX QXDRPCTX | | X | X | DSPDRPVU DROP VIEW Statements DSPDRPVU QXDRPVU | X | X | X | DSPDRTA Global Requests Denied DSPDRTA QTGADRTA | X | X | X | DSPDSCRT No. DESCRIBE TABLE Statements DSPDSCRT QXDSCRTB | X | X | X | DSPDSNS No. Wait Trace Events - Dataspace Mgr DB2DSNS QWAXDSNS | X | X | X | DSPDSSTM Accum Wait Time Dataspace Manager DB2DSSTM QWAXDSSE | X | X | X | DSPDSTSN Destination Sequence Number DB2DSTSN QWHSWSEQ | X | X | X | DSPEGENC Parallel Groups Executed Sequential DB2EGENC QXDEGENC | X | X | | DSPELGZP Accumulated CPU Time zIIP-Eligible Work DSPELGZP QWACZIIP_ELIGIBLE | X | X | | DSPENDSC Ending Store Clock DSPENDSC QWACESC | X | X | X | DSPENTCB Ending TCB Timer DSPENTCB QWACEJST | X | X | X | DSPENTEX Number of Entry/Exit Events Processed DSPENTEX QWACARNA | X | X | X | DSPET2TM Elapsed Time in DB2 DSPET2TM QWACASC | X | X | X | DSPFCCT No. Wait Trace Events - Force-At-Commit DB2FCCT QWAXFCCT | X | X | X | DSPFETCH Number of FETCH Statements DSPFETCH QXFETCH | X | X | X | DSPFLGS Accounting Class Flags DSPFLGS QWACFLGS | X | X | X | DSPFLSE No. of False Contentions DSPFLSE QTGAFLSE | X | X | X | DSPFRIDS Times RID List Overflowed RID Storage DB2FRIDS QXWFRIDS | | | X | DSPFRIDT Times RID List Overflowed RID Exceeded DB2FRIDT QXWFRIDT | | | X | DSPGPGR0 GETPAGE Requests BP0 DB2GPGRX QBACGET | X | X | X | DSPGPGR1 GETPAGE Requests BP1 DB2GPGRX QBACGET | X | X | X | DSPGPGR2 GETPAGE Requests BP2 DB2GPGRX QBACGET | X | X | X | DSPGPGR3 GETPAGE Requests BP3 DB2GPGRX QBACGET | X | X | X | DSPGRANT GRANT Statements DSPGRANT QXGRANT | X | X | X | DSPIGLO Suspends Due to IRLM Global Contention DSPIGLO QTGAIGLO | X | X | X | DSPINCRB Incremental Binds DSPINCRB QXINCRB | X | X | X | DSPNFLMT No. Infinite Resource Limit DSPNFLMT QTXAFLG1 | | | | DSPINSRT INSERT Statements DSPINSRT QXINSRT | X | X | X | DSPIOETM Accumulated I/O Elapsed Wait Time in DB2 DSPIOETM QWACAWTI | X | X | X | DSPISEQ Instrumentation Sequence Number DB2ISEQ QWHSISEQ | X | X | X | DSPJINCS Times RID List Append RID Storage DB2JINCS QXHJINCS | | | X | DSPIXLE No. Wait Trace Events - Async IXLCACHE DB2IXLE QWAXIXLE | X | X | X | DSPIXLTM Total Wait Time IXLCACHE/FCOMP Asynch DB2IXLTM QWAXIXLT | X | X | X | DSPJINCT Times RID List Append RID Exceeded DB2JINCT QXHJINCT | | | X | DSPLABEL Number of LABEL ON Statements DSPLABEL QXLABON | X | X | X | DSPLEEM Number of Lock Escalations to Exclusive DSPLEEM QTXALEX | X | X | X | DSPLESM Number of Lock Escalations to Shared DSPLESM QTXALES | X | X | X | DSPLOCK LOCK TABLE Statements DSPLOCK QXLOCK | X | X | X | DSPLPF0 No. List Prefetch Requested BP0 DB2LPFX QBACLPF | X | X | X | DSPLPF1 No. List Prefetch Requested BP1 DB2LPFX QBACLPF | X | X | X | DSPLPF2 No. List Prefetch Requested BP2 DB2LPFX QBACLPF | X | X | X | DSPLPF3 No. List Prefetch Requested BP3 DB2LPFX QBACLPF | X | X | X | DSPLPLK Lock Requests for Physical Locks DSPLPLK QTGALPLK | X | X | X | DSPLSLM Lock Requests Propagated to XES DSPLSLM QTGALSLM | X | X | X | DSPMALCT Max Archive Log Suspensions DSPMALCT QWAXALCT | X | X | X | DSPMCHG Max Change Lock Requests DSPMCHG QTXACHG | X | X | X | DSPMDEAD Max Deadlocks DSPMDEAD QTXADEA | X | X | X | DSPMENTX Max Entry/Exits DSPMENTX QWACARNA | X | X | X | DSPMERGE Merge Statements DB2MERGE QXMERGE | | X | X | DSPMGPG0 Max BP0 GETPAGE Requests DB2MGPGX QBACGET | X | X | X | DSPMGPG1 Max BP1 GETPAGE Requests DB2MGPGX QBACGET | X | X | X | DSPMGPG2 Max BP2 GETPAGE Requests DB2MGPGX QBACGET | X | X | X | DSPMGPG3 Max BP3 GETPAGE Requests DB2MGPGX QBACGET | X | X | X | DSPMIOTM Max I/O Elapsed Wait Time in DB2 DSPMIOTM QWACAWTI | X | X | X | DSPMIRLM Max IRLM Lock Requests DSPMIRLM QTXAIRLM | X | X | X | DSPMIXNL Mult Indx Not Used - RID Limit DSPMIXNL QXMRMIAP | X | X | X | DSPMIXNU Mult Indx Not Used - No Storage DSPMIXNU QXNSMIAP | X | X | X | DSPMIXU Multiple Index Path Used DSPMIXU QXMIAP | X | X | X | DSPMLEEM Max Escalate to Exclusive Lock DSPMLEEM QTXALEX | X | X | X | DSPMLESM Max Escalate to Shared Lock DSPMLESM QTXALES | X | X | X | DSPMLGTM Max Class 3 Accum Wait Archive Log Time DSPMLGTM QWACALOG | | | X | DSPMLOCK Max Lock Requests DSPMLOCK QTXALOCK | X | X | X | DSPMLPF0 Total List Prefetch Requested DSPMLPFX QBACLPF | X | X | X | DSPMLPF1 Total List Prefetch Requested DSPMLPFX QBACLPF | X | X | X | DSPMLPF2 Total List Prefetch Requested DSPMLPFX QBACLPF | X | X | X | DSPMLPF3 Total List Prefetch Requested DSPMLPFX QBACLPF | X | X | X | DSPMMXPL Max Max. No. Page Locks Held DSPMMXPL QTXANPL | X | X | X | DSPMPFR0 Max Buffer Pool Prefetch Reads DB2MPFRX QBACSEQ | X | X | X | DSPMPFR1 Max Buffer Pool Prefetch Reads DB2MPFRX QBACSEQ | X | X | X | DSPMPFR2 Max Buffer Pool Prefetch Reads DB2MPFRX QBACSEQ | X | X | X | DSPMPFR3 Max Buffer Pool Prefetch Reads DB2MPFRX QBACSEQ | X | X | X | DSPMQRY Max Query Requests DSPMQRY QTXAQRY | X | X | X | DSPMSLAT Max Latch Suspensions DSPMSLAT QTXASLAT | X | X | X | DSPMSOTH Max Other Suspends DSPMSOTH QTXASOTH | X | X | X | DSPMSPU0 Max BP0 System Pages Updated DB2MSPUX QBACSWS | X | X | X | DSPMSPU1 Max BP1 System Pages Updated DB2MSPUX QBACSWS | X | X | X | DSPMSPU2 Max BP2 System Pages Updated DB2MSPUX QBACSWS | X | X | X | DSPMSRD0 Max Buffer Pool Synchronous Reads DB2MSRDX QBACRIO | X | X | X | DSPMSRD1 Max Buffer Pool Synchronous Reads DB2MSRDX QBACRIO | X | X | X | DSPMSRD2 Max Buffer Pool Synchronous Reads DB2MSRDX QBACRIO | X | X | X | DSPMSRD3 Max Buffer Pool Synchronous Reads DB2MSRDX QBACRIO | X | X | X | DSPMSWR0 Max Buffer Pool Synchronous Reads DB2MSWRX QBACIMW | X | X | X | DSPMSWR1 Max Buffer Pool Synchronous Reads DB2MSWRX QBACIMW | X | X | X | DSPMSWR2 Max Buffer Pool Synchronous Reads DB2MSWRX QBACIMW | X | X | X | DSPMSWR3 Max Buffer Pool Synchronous Reads DB2MSWRX QBACIMW | X | X | X | DSPMTIMO Max Timeouts DSPMTIMO QTXATIM | X | X | X | DSPMWATR Max Wait Trace Events / Plan DSPMWATR QWACARNE | X | X | X | DSPMWETM Max Class 3 Accum Wait Serv. Task Time DSPMWETM QWACAWTE | X | X | X | DSPMWRTM Max Class 3 Accum Wait Read Other Time DSPMWRTM QWACAWTR | X | X | X | DSPMWTRL Max Wait Trace Events for Lock/Latch DSPMWTRL QWACARNL | X | X | X | DSPMWTRR Max Wait Trace Events for Read Other DSPMWTRR QWACARNR | X | X | X | DSPMWTRW Max Wait Trace Events for Write Other DSPMWTRW QWACARNW | X | X | X | DSPMWTSE Max Wait Trace Events for Sync. Exec. DSPMWTSE QWACARNS | X | X | X | DSPMWWTM Max Class 3 Accum Wait Write Other Time DSPMWWTM QWACAWTW | X | X | X | DSPMXDEG Max Degree of Parallelism DB2MXDEG QXMAXDEG | X | X | X | DSPMXPL Maximum Number of Page Locks Held DSPMXPL QTXANPL | X | X | X | DSPMXSE1 Max CPU Tm Exec SP on z/OS SE DSPMXSE1 QWACSP_CLS1se | | X | X | DSPMXSE2 Max CPU Tm in DB2 Exec SP on z/OS SE DSPMXSE2 QWACSP_CLS2se | | X | X | DSPMXSET Max CPU Tm Exec Trgrs on z/OS Spec Eng DSPMXSET QWACTRTE_se | | X | X | DSPMXZP1 Max CPU Tm Used on z/OS Spec Eng DSPMXZP1 QWACCLS1_zIIP | X | X | X | DSPMXZP2 Max CPU Tm Used in DB2 on z/OS Spec Eng DSPMXZP2 QWACCLS2_zIIP | X | X | X | DSPMXZTT Max CPU Tm Exec Trgrs on z/OS Spec Eng DSPMXZTT QWACTRTT_zIIP | X | X | X | DSPNATHD Count of ACCUMACC Roll-up Threads DSPNATHD QWACPCNT | X | X | X | DSPNETID Network Identifier DSPNETID QWACNID | X | X | X | DSPNGT0 No. Time GETPAGE Req Not Satisfied BP0 DB2NGTX QBACNGT | X | X | X | DSPNGT1 No. Time GETPAGE Req Not Satisfied BP1 DB2NGTX QBACNGT | X | X | X | DSPNGT2 No. Time GETPAGE Req Not Satisfied BP2 DB2NGTX QBACNGT | X | X | X | DSPNGT3 No. Time GETPAGE Req Not Satisfied BP3 DB2NGTX QBACNGT | X | X | X | DSPNOGRP Total Number of Parallel Groups That DB2NOGRP QXNORGRP | X | X | X | DSPNTFY Notify Messages Sent DSPNTFY QTGANTFY | X | X | X | DSPOCNS No. Wait Trace Events - Open/Close/HSM DB2OCNS QWAXOCNS | X | X | X | DSPOCSTM Accum Wait Time Open/Close/HSM DB2OCSTM QWAXOCSE | X | X | X | DSPOPEN OPEN Statements DSPOPEN QXOPEN | X | X | X | DSPOPID Original Operator ID DB2OPID QWHCOPID | X | X | X | DSPORNO Parallel Groups Executed Coordination DB2ORNO QXCOORNO | X | X | X | DSPORR Parallel Groups Executed Repeat-read DB2ORR QXISORR | X | X | X | DSPOTNS No. Wait Trace Events - Other Services DB2OTNS QWAXOTNS | X | X | X | DSPOTSTM Accum Wait Time Other DB2 Services DB2OTSTM QWAXOTSE | X | X | X | DSPPACE Parallel Task Token DSPPACE QWACPACE | X | X | X | DSPPARR No. Rollup Data DSPPARR QWACFLGS | | | | DSPPCNT No. Parallel Tasks Created DSPPCNT QWACPCNT | X | X | X | DSPPCWDP Duplicate Per Parsed Dyna Stmnts DB2PCWDP | | | X | DSPPCWMP Matched Per Parsed Dyna Stmnts DB2PCWMP | | | X | DSPPCWRP Replaced Per Parsed Dyna Stmnts DB2PCWRP | | | X | DSPPEDTM Accum CPU Proc SQL Prior Enclave DB2PEDTM QWACPECD | X | | | DSPPETTM Accum TCB Prior Enclave Create DB2PETTM QWACPECT | X | | | DSPPGDTT Parallel GPS Using UDF - Ex. Single DB2 DB2PGDTT QXDEGDTT | X | X | X | DSPPKGN No. Packages or DBRMs DSPPKGN QWACPKGN | X | X | X | DSPPLAN Plan Name DB2PLAN QWHCPLAN | X | X | X | DSPPRFH0 PREFETCH Read Requests Buffer BP0 DB2PRFHX QBACSEQ | X | X | X | DSPPRFH1 PREFETCH Read Requests Buffer BP1 DB2PRFHX QBACSEQ | X | X | X | DSPPRFH2 PREFETCH Read Requests Buffer BP2 DB2PRFHX QBACSEQ | X | X | X | DSPPRFH3 PREFETCH Read Requests Buffer BP3 DB2PRFHX QBACSEQ | X | X | X | DSPREASN Reason for Accounting Record DSPREASN QWACRINV | X | X | X | DSPRBSV No. SQL Rollback to Savepoint Stmts DB2RBSV QWACRBSV | X | X | X | DSPRDGRP Total Number of Parallel Groups That DB2RDGRP QXREDGRP | X | X | X | DSPRDLTD Deleted Rows DB2RDLTD QXRWSDELETD | X | X | DSPREVOK REVOKE Statements DSPREVOK QXREVOK | X | X | DSPRFCHD Fetched Rows DB2RFCHD QXRWSFETCHD | X | X | DSPRLSV No. SQL Release Savepoint Statements DB2RLSV QWACRLSV | X | X | DSPRMID DB2 Resource Manager Identifier DB2RMID QWHSRMID | X | X | DSPRNIX Rename Index Statements DB2RNIX QXRNIX | | X | X | DSPRNKCL No. Wait Trace Glbl Cont. Child LLock DB2RNKCL QWACARNK | X | X | X | DSPRNMOL No. Wait Trace Glbl Cont. Other LLock DB2RNMOL QWACARNM | X | X | X | DSPRNNPL No. Wait Trace Glbl Cont. PP PLock DB2RNNPL QWACARNN | X | X | X | DSPRNOPL No. Wait Trace Glbl Cont. PG PLock DB2RNOPL QWACARNO | X | X | X | DSPRNQOL No. Wait Trace Glbl Cont. Other PLock DB2RNQOL QWACARNQ | X | X | X | DSPRNSTD Inserted Rows DB2RNSTD QXRWSINSRTD | X | X | DSPRPOP1 Parallel GPS Reformatted - Sysplex Conf DB2RPOP1 QXREPOP1 | X | X | DSPRPOP2 Parallel GPS Reformatted - Buffer Resrc DB2RPOP2 QXREPOP2 | X | X | DSPRUDTD Updated Rows DB2RUDTD QXRWSUPDTD | X | X | DSPSDG Total Unregister Pages Requests DB2SDG QBGADG | X | X | X | DSPSELCT Number of SELECT Statements DSPSELCT QXSELECT | X | X | X | DSPSETHV No. SET HOST-VAR Statements DSPSETHV QXSETHV | X | X | X | DSPSEX Total Explicit XIs DB2SEX QBGAEX | X | X | X | DSPSGG Total GETPAGEs for GBP-Dep Pagesets DB2SGG QBGAGG | X | X | X | DSPSGLO Suspends Due to XES Global Contention DSPSGLO QTGASGLO | X | X | X | DSPSHS Total Asynch IXLCACHE for Prim GBP DB2SHS QBGAHS | X | X | X | DSPSIO0 Number of Sync Read I/Os Issued DB2SIOX QBSTSIO | X | X | X | DSPSIO1 Number of Sync Read I/Os Issued DB2SIOX QBSTSIO | X | X | X | DSPSIO2 Number of Sync Read I/Os Issued DB2SIOX QBSTSIO | X | X | X | DSPSIO3 Number of Sync Read I/Os Issued DB2SIOX QBSTSIO | X | X | X | DSPSKIP Parallel Coordination Bypass DB2 DB2SKIP QXXCSKIP | X | X | X | DSPSLNS No. Wait Trace Events - SYSLGRNG DB2SLNS QWAXSLNS | X | X | X | DSPSLSTM Accum Wait Time SYSLGRNG DB2SLSTM QWAXSLSE | X | X | X | DSPSMD Total CF Reads Data Returned DSPSMD QBGAMD | X | X | X | DSPSMIAP Times RID List Retrieval Skipped DB2SMIAP QXRSMIAP | | | X | DSPSMN Total CF Reads Data Not Ret. No Entry DSPSMN QBGAMN | X | X | X | DSPSMR Total CF Reads Data Not Returned Entry DSPSMR QBGAMR | X | X | X | DSPSPATM Total Elapsed Time Stored Procedures DB2SPATM QWACSPEA | X | X | X | DSPSPBTM Total Elapsed Time in DB2 Stored Proc. DB2SPBTM QWACSPEB | X | X | X | DSPSPCTM Accum CPU Time SQL Procedures Main Unit DB2SPCTM QWACSPNF_CP | | X | X | DSPSPETM Total Elapsed Time Wait for TCB DSPSPETM QWACCAST | X | X | X | DSPSPNE SQL Events by Stored Procs DSPSPNE QWACSPNE | X | X | X | DSPSPPTM CPU Time Stored Proc Address Space DSPSPPTM QWACSPCP | X | X | X | DSPSPRU0 System Page Record Update BP0 DB2SPRUX QBACSWS | X | X | X | DSPSPRU1 System Page Record Update BP1 DB2SPRUX QBACSWS | X | X | X | DSPSPRU2 System Page Record Update BP2 DB2SPRUX QBACSWS | X | X | X | DSPSPRU3 System Page Record Update BP3 DB2SPRUX QBACSWS | X | X | X | DSPSPSE1 Accum CPU Tm Exec SP on z/OS Spec Eng DSPSPSE1 QWACSP_CLS1se | | X | X | DSPSPSE2 CPU Tm in DB2 Exec SP on z/OS Spec Eng DSPSPSE2 QWACSP_CLS2se | | X | X | DSPSPZET Total Elapsed Time on zIIP Stored Proc. DB2SPZET QWACSPNF_ELAP | | X | X | DSPSPZTM CPU Tm Exec Strd Proc on z/OS Spec Eng DB2SPZTM QWACSPNF_CP | | X | X | DSPSP1 P-Lock Lock Requests-Space Map Pages1 DB2SP1 QBGAP1 | X | X | X | DSPSP2 P-Lock Lock Requests-Data Pages2 DB2SP2 QBGAP2 | X | X | X | DSPSP2TM Accum CPU Time in DB2 Stored Proc. DSPSP2TM QWACSPTT | X | X | X | DSPSP3 P-Lock Lock Requests-Index Leaf Pages3 DB2SP3 QBGAP3 | X | X | X | DSPSQLID No. Of Set Current SQLID DSPSQLID QXSETSQL | X | X | X | DSPSRIO0 Synchronous Read IOs BP0 DB2SRIOX QBACRIO | X | X | X | DSPSRIO1 Synchronous Read IOs BP1 DB2SRIOX QBACRIO | X | X | X | DSPSRIO2 Synchronous Read IOs BP2 DB2SRIOX QBACRIO | X | X | X | DSPSRIO3 Synchronous Read IOs BP3 DB2SRIOX QBACRIO | X | X | X | DSPSSW Total CF Writes For Changed Pages DSPSSW QBGASW | X | X | X | DSPSS1 P-Lock Lock Susp. - Space Map Pages 1 DB2SS1 QBGAS1 | X | X | X | DSPSS2 P-Lock Lock Suspensions - Data Pages 2 DB2SS2 QBGAS2 | X | X | X | DSPSS3 P-Lock Lock Susp. - Index Leaf Pages 3 DB2SS3 QBGAS3 | X | X | X | DSPSUCV SU:CPU-second Conversion Factor DB2SUCV QWACSUCV | X | X | X | DSPSU1 P-Lock Unlock Requests1 DB2SU1 QBGAU1 | X | X | X | DSPSVPT No. SQL Savepoint Statements DB2SVPT QWACSVPT | X | X | X | DSPSWC Total CF Writes For Clean Pages DSPSWC QBGAWC | X | X | X | DSPSWM Total Write and Register Multiple Reqs DB2SWM QBGAWM | X | X | X | DSPSWS Total Write and Register Requests DB2SWS QBGAWS | X | X | X | DSPSXD Total CF Reads Buffer XI DSPSXD QBGAXD | X | X | X | DSPSXN Total CF Reads Entry Not Created DSPSXN QBGAXN | | | X | DSPSXR Total CF Reads Entry Created DSPSXR QBGAXR | X | X | X | DSPS2H Total Asynch IXLCACHE for 2nd GBP DB2S2H QBGA2H | X | X | X | DSPS2S Total Comp Chks 4 Wrts 2nd GBP Suspend DB2S2S QBGA2S | X | X | X | DSPTC2TM Class 2 Accumulated TCB Time in DB2 DSPTC2TM QWACAJST | X | X | X | DSPTEETM Total Elps Tm Exec Trigger Undr Enclave DB2TEETM QWACTREE | X | X | X | DSPTIMO Timeout Count DSPTIMO QTXATIM | X | X | X | DSPTOGRP Total Number of Parallel Groups DB2TOGRP QXTOTGRP | X | X | X | DSPTRETM Elapsed Time Executing Control Triggers DB2TRETM QWACTRET | X | X | X | DSPTRTBL Truncate Table Statements DB2TRTBL QXTRTBL | | X | X | DSPTRTSE Accum CPU Tm Exe Trgrs on z/OS Spec Eng DSPTRTSE QWACTRTE_se | | X | X | DSPTRTTM Accum TCB Time Under Cntl Trigger DB2TRTTM QWACTRTT | X | X | X | DSPTRTZP CPU Tm Exec Triggers on z/OS Spec Eng DSPTRTZP QWACTRTT_zIIP | X | X | X | DSPTTETM Total TCB Tm Exec Trigger Undr Enclave DB2TTETM QWACTRTE | X | X | X | DSPUDATM Total Elapsed Time UDF DB2UDATM QWACUDEA | X | X | X | DSPUDBTM Total Elapsed Time in DB2 UDF DB2UDBTM QWACUDEB | X | X | X | DSPUDCTM Accum CPU Time UDF DB2UDCTM QWACUDCP | X | X | X | DSPUDSTM Total Elapsed Time UDF Wait for TCB DB2UDSTM QWACUDST | X | X | X | DSPUDSE1 Accum CPU Tm Exec UDF on z/OS Spec Eng DB2UDSE1 QWACUDF_CLS1se | | X | X | DSPUDSE2 CPU Tm in DB2 Exec UDF on z/OS Spec Eng DB2UDSE2 QWACUDF_CLS2se | | X | X | DSPUDTTM Accum CPU Time in DB2 UDF DB2UDTTM QWACUDTT | X | X | X | DSPUPDTE UPDATE Statements DSPUPDTE QXUPDTE | X | X | X | DSPUPLK Unlock Requests for Physical Locks DSPUPLK QTGAUPLK | X | X | X | DSPUSLM Unlock Requests Propagated to XES DSPUSLM QTGAUSLM | X | X | X | DSPWATRA No. Wait Trace Events for Log Reads DSPWATRA QWACANAR | | | X | DSPWATRA No. Wait Trace Events for Log Reads DSPWATRA QWAXANAR | X | X | X | DSPWATRB Wt Trace for TCP/IP LOB Material DB2WATRB QWACALBC | | X | X | DSPWATRC Wait Trace for Claims DSPWATRC QWACARNC | | | X | DSPWATRC Wait Trace for Claims DSPWATRC QWAXARNC | X | X | X | DSPWATRD Wait Trace for Drain Lock DSPWATRD QWACARND | | | | DSPWATRD Wait Trace for Drain Lock DSPWATRD QWAXARND | X | X | X | DSPWATRG No. Wait Trace for Global Lock DSPWATRG QWACARNJ | X | X | X | DSPWATRL No. Wait Trace Events for Lock/Latch DSPWATRL QWACARNL | X | X | X | DSPWATRM No. Wait Trace Events for Data Shr Msgs DSPWATRM QWACARNG | X | X | X | DSPWATRP Wait Trace for Latch Contention DSPWATRP QWACARNH | X | X | X | DSPWATRR No. Wait Trace Events for Read Other DSPWATRR QWACARNR | X | X | X | DSPWATRW No. Wait Trace Events for Write Other DSPWATRW QWACARNW | X | X | X | DSPWATSE No. Wait Trace Events for Sync. Exec. DSPWATSE QWACARNS | X | X | X | DSPWATTR Number of Wait Trace Events Processed DSPWATTR QWACARNE | X | X | X | DSPWFCTM Total Wait Time for Force-At-Commit DB2WFCTM QWAXAWFC | X | X | X | DSPWLCTM Glbl Contention Child L-Lock Wait Time DB2WLCTM QWACAWTK | X | X | X | DSPWGLTM Glbl Contention PG P-Lock Wait Time DB2WGLTM QWACAWTO | X | X | X | DSPWLLTM Glbl Contention Other L-Locks Wait Time DB2WLLTM QWACAWTM | X | X | X | DSPWLPTM Glbl Contention PP P-Lock Wait Time DB2WLPTM QWACAWTN | X | X | X | DSPWTOTM Glbl Contention Other P-Locks Wait Time DB2WTOTM QWACAWTQ | X | X | X | DSPWLGTM Accum Wait Time for Log Write IO DB2WLGTM QWACAWLG | X | X | X | DSPWLMCL WLM Service Class Name DB2WLMCL QWACWLME | X | X | X | DSPXCQO Mem Name of Parallelism Coordinator DB2XCQO QWDAXCQO | X | X | X | DSPZRLMT No. Zero Resource Limit DSPZRLMT QTXAFLG1 | | | X | ----------------------------------------------------------------------------------------------------------------------------------
The DB2DSU (DB2 User Activity) File
---------------------------------------------------------------------------------------------------------------------------------- DICTIONARY RAW AVAILABLE IN DB2 VERSIONS ELEMENT ELEMENT DESCRIPTION MEMBER ELEMENT 8.1 9.1 10.1 ---------------------------------------------------------------------------------------------------------------------------------- DB2ACE DB2 Agent Control Element DB2ACE QWHSACE | X | X | X | DB2ATNM Active Trace Number Mask DB2ATNM QWHSMTN | X | X | X | DB2AUTH Authorization Identifier DB2AUTH QWHCAID | X | X | X | DB2CONN Connection Identifier DB2CONN QWHCCN | X | X | X | DB2CORR Correlation Identifier DB2CORR QWHCCV | X | X | X | DB2CPU DB2 CPU Time DB2CPU QWHUCPU | X | X | X | DB2CRDNT CICS/RRSAF/DB Access Network Name DB2CRDNT QWHCTOKN | | | | DB2CRDLU CICS/RRSAF/DB Access LU Name DB2CRDLU QWHCTOKN | | | | DB2CRDUV CICS/RRSAF/DB Access Uniqueness Value DB2CRDUV QWHCTOKN | | | | DB2DDFCT DDF COMMIT Count DB2DDFCT QWHSLUCC | X | X | X | DB2DSGN Data Sharing Group Name DB2DSGN QWHADSGN | X | X | X | DB2DSTSN Destination Sequence Number DB2DSTSN QWHSWSEQ | X | X | X | DB2ISEQ Instrumentation Sequence Number DB2ISEQ QWHSISEQ | X | X | X | DB2LOCN DDF Local Location ID DB2LOCN QWHSLOCN | X | X | X | DB2LUNAM DB2 Logical Unit Name DB2LUNAM QWHSLUNM | X | X | X | DB2MEMN DB2 Member Name DB2MEMN QWHAMEMN | X | X | X | DB2NETID Network Identifier DB2NETID QWACNID | X | X | X | DB2OPID Original Operator ID DB2OPID QWHCOPID | X | X | X | DB2PLAN Plan Name DB2PLAN QWHCPLAN | X | X | X | DB2RELN DB2 Release Identifier DB2RELN QWHSRELN | X | X | X | DB2STCK DB2 Store Clock At End Event DB2STCK QWHSSTCK | X | X | X | DSUABORT ABORT Requests DSUABORT QWACABRT | X | X | X | DSUACHG Change Request Count DSUACHG QTXACHG | X | X | X | DSUACHUS Highest CPU 16 Microseconds Used DSUACHUS QTXACHUS | X | X | X | DSUACLMT Limit In CPU 16 Microseconds DSUACLMT QTXACLMT | X | X | X | DSUAFLG Flag Byte DSUAFLG QTXAFLG1 | X | X | X | DSUAIETM Class 5 Accum Elapsed Time IFI Calls DSUAIETM QIFAAIET | X | X | X | DSUAIRLM Other IRLM Request Count DSUAIRLM QTXAIRLM | X | X | X | DSUAITTM Class 5 Accum TCB Time IFI Calls DSUAITTM QIFAAITT | X | X | X | DSUALDAB No. ALTER DATABASE Statements DSUALDAB QXALDAB | X | X | X | DSUALGTM Class 3 Accum Wait Archive Log Time DSUALGTM QWACALOG | | | | DSUALGTM Class 3 Accum Wait Archive Log Time DSUALGTM QWAXALOG | X | X | X | DSUALLTM DB2 Lock & Latch Time DSUALLTM QWACAWTL | X | X | X | DSUALOCK Lock Request Count DSUALOCK QTXALOCK | X | X | X | DSUALTIX ALTER INDEX Statements DSUALTIX QXALTIX | X | X | X | DSUALTJR Alter JAR Statements DB2ALTJR QXAALTJR | | X | X | DSUALTST ALTER STORAGE GROUP Statements DSUALTST QXALTST | X | X | X | DSUALTTA ALTER TABLE Statements DSUALTTA QXALTTA | X | X | X | DSUALTTS ALTER TABLESPACE Statements DSUALTTS QXALTTS | X | X | X | DSUALTTX Alter Trusted Context Statements DB2ALTTX QXALTCTX | | X | X | DSUALTVW Alter View Statements DB2ALTVW QXALTVW | | X | X | DSUAMBTM Class 5 Accum Elapsed Time Data Capture DSUAMBTM QIFAAIET | X | X | X | DSUAMLTM Class 5 Accum Elapsed Time Log Records DSUAMLTM QIFAAIET | X | X | X | DSUANDD No. Data Descriptions Returned DSUANDD QIFAANDD | X | X | X | DSUANDR No. Data Rows Returned DSUANDR QIFAANDR | X | X | X | DSUANIF No. Entry/Exit Events Class 5 DSUANIF QIFAANIF | X | X | X | DSUANMB No. Data Capture Describes Performed DSUANMB QIFAANMB | X | X | X | DSUANRC No. Log Records Captured DSUANRC QIFAANRC | X | X | X | DSUANRR No. Log Records Returned to Caller DSUANRR QIFAANRR | X | X | X | DSUANTB No. Data Capture Tables DSUANTB QIFAANTB | X | X | X | DSUAPPL Client Application Name DSUAPPL QMDAAPPL | X | X | X | DSUAPREC How Limit Was Determined DSUAPREC QTXAPREC | X | X | X | DSUAQRY Query Request Count DSUAQRY QTXAQRY | X | X | X | DSUARLH Wait Trace Events Latch Contention DB2ARLH QWACARLH | | | X | DSUARLCT No. Archive Log Suspensions DSUARLCT QWAXALCT | X | X | X | DSUARLID Resource Limit Table ID DSUARLID QTXARLID | X | X | X | DSUASLAT Suspend Count - Latch Conflict DSUASLAT QTXASLAT | X | X | X | DSUASLMT Limit In SU's - ASUTIME DSUASLMT QTXASLMT | X | X | X | DSUASOTH Suspend Count - Other Conflict DSUASOTH QTXASOTH | X | X | X | DSUATID Client Authid DSUATID QMDAATID | X | X | X | DSUAUNLK Unlock Request Count DSUAUNLK QTXAUNLK | X | X | X | DSUAWATM Class 3 Accum Wait Log Reads Time DSUAWATM QWACAWAR | | | | DSUAWATM Class 3 Accum Wait Log Reads Time DSUAWATM QWAXAWAR | X | X | X | DSUAWBTM Wait Time - TCP/IP LOB Material DB2AWBTM QWACALBW | | X | X | DSUAWCTM Class 3 Accum Wait Drain Wait Time DSUAWCTM QWACAWCL | | | | DSUAWCTM Class 3 Accum Wait Drain Wait Time DSUAWCTM QWAXAWCL | X | X | X | DSUAWDTM Class 3 Accum Wait Drain Lock Time DSUAWDTM QWACAWDR | | | | DSUAWDTM Class 3 Accum Wait Drain Lock Time DSUAWDTM QWAXAWDR | X | X | X | DSUAWETM Class 3 Accum Wait Service Task Time DSUAWETM QWACAWTE | X | X | X | DSUAWGTM Accum Wait Time Data Sharing Messages DSUAWGTM QWACAWTG | X | X | X | DSUAWJTM Accum Wait Time Global Locks DSUAWJTM QWACAWTJ | X | X | X | DSUAWLTM Accum Wait Time - Latch Contention DB2AWLTM QWACAWTE | | | X | DSUAWPTM Class 3 Accum Wait Latch Contention DSUAWPTM QWACAWTP | X | X | X | DSUAWRTM Class 3 Accum Wait Read Other Time DSUAWRTM QWACAWTR | X | X | X | DSUAWWTM Class 3 Accum Wait Write Other Time DSUAWWTM QWACAWTW | X | X | X | DSUBEGSC Beginning Store Clock DSUBEGSC QWACBSC | X | X | X | DSUBGTCB Beginning TCB Timer DSUBGTCB QWACBJST | X | X | X | DSUBPNX Parallel Groups Run Cross Data Share DB2BPNX QXXCBPNX | X | X | X | DSUCANM No. Times SQL Call Wait for TCB DSUCANM QWACCANM | X | X | X | DSUCATYP Connecting System Type Code DSUCATYP QWHCATYP | X | X | X | DSUCIMW0 No. of Immed. Sync Write I/O Buffer BP0 DB2CIMWX QBACIMW | X | X | X | DSUCIMW1 No. of Immed. Sync Write I/O Buffer BP1 DB2CIMWX QBACIMW | X | X | X | DSUCIMW2 No. of Immed. Sync Write I/O Buffer BP2 DB2CIMWX QBACIMW | X | X | X | DSUCIMW3 No. of Immed. Sync Write I/O Buffer BP3 DB2CIMWX QBACIMW | X | X | X | DSUCLOSE CLOSE Statements DSUCLOSE QXCLOSE | X | X | X | DSUCLRAB No. Log Record Bytes Written DSUCLRAB QWACLRAB | X | X | X | DSUCLRN No. Log Records Written DSUCLRN QWACLRN | X | X | X | DSUCLS2 No. Accounting Class 2 Data DSUCLS2 QWACFLGS | | | | DSUCLS2C No. Accounting Class 2 Data Collected DSUCLS2C QWACFLGS | | | | DSUCLS3 No. Accounting Class 3 Data DSUCLS3 QWACFLGS | | | | DSUCLS3C No. Accounting Class 3 Data Collected DSUCLS3C QWACFLGS | | | | DSUCLS7C No. Accounting Class 7 Data Collected DSUCLS7C QWACFLGS | | | | DSUCLS8C No. Accounting Class 8 Data Collected DSUCLS8C QWACFLGS | | | | DSUCOMM2 Commit Phase Two Invocations DSUCOMM2 QWACCOMM | X | X | X | DSUCPLK Change Requests for Physical Locks DSUCPLK QTGACPLK | X | X | X | DSUCPUZ1 Accum CPU Tm Used on z/OS Spec Eng DSUCPUZ1 QWACCLS1_ZIIP | X | X | X | DSUCPUZ2 CPU Tm Used in DB2 on z/OS Spec Eng DSUCPUZ2 QWACCLS2_ZIIP | X | X | X | DSUCRAL Create Alias DSUCRAL QXCRALS | X | X | X | DSUCRCTX Create Trusted Context Statements DB2CRCTX QXCRCTX | | X | X | DSUCRDAB CREATE DATABASE Statements DSUCRDAB QXCRDAB | X | X | X | DSUCRINX CREATE INDEX Statements DSUCRINX QXCRINX | X | X | X | DSUCRROL Create Role Statements DB2CRROL QXCRROL | | X | X | DSUCRSTG CREATE STORAGE GROUP Statements DSUCRSTG QXCRSTG | X | X | X | DSUCRSYN CREATE SYNONYM Statements DSUCRSYN QXCRSYN | X | X | X | DSUCRTAB CREATE TABLE Statements DSUCRTAB QXCRTAB | X | X | X | DSUCSLM Change Requests Propagated to XES DSUCSLM QTGACSLM | X | X | X | DSUCTABS CREATE TABLESPACE Statements DSUCTABS QXCTABS | X | X | X | DSUCUDNE No. SQL Entry/exit UDF Events DB2CUDNE QWACUDNE | X | X | X | DSUCWLD Times Duplicate Concentrate Dyna Stmnts DB2CWLD QXSTCWLD | | | X | DSUCWLM Times Matched Concentrate Dyna Stmnts DB2CWLM QXSTCWLM | | | X | DSUCWLP Times Parsed Concentrate Dyna Stmnts DB2CWLP QXSTCWLP | | | X | DSUCWLR Times Replaced Concentrate Dyna Stmnts DB2CWLR QXSTCWLR | | | X | DSUDEAD Deadlock Count DSUDEAD QTXADEA | X | X | X | DSUDEFVU CREATE VIEW Statements DSUDEFVU QXDEFVU | X | X | X | DSUDELET DELETE Statements DSUDELET QXDELET | X | X | X | DSUDESC DESCRIBE Statements DSUDESC QXDESC | X | X | X | DSUDGBUF Total Number of Parallel Groups That DB2DGBUF QXDEGBUF | X | X | X | DSUDGCUR Parallel Groups to Seq Cursor Update DB2DGCUR QXDEGCUR | X | X | X | DSUDGESA Parallel Groups to Seq No ESA Sort DB2DGESA QXDEGESA | X | X | X | DSUDPF0 No. Times Dynamic Prefetch Req BP0 DB2DPFX QBACDPF | X | X | X | DSUDPF1 No. Times Dynamic Prefetch Req BP1 DB2DPFX QBACDPF | X | X | X | DSUDPF2 No. Times Dynamic Prefetch Req BP2 DB2DPFX QBACDPF | X | X | X | DSUDPF3 No. Times Dynamic Prefetch Req BP3 DB2DPFX QBACDPF | X | X | X | DSUDRAL Drop Alias DSUDRAL QXDRPAL | X | X | X | DSUDRPDB DROP DATABASE Statements DSUDRPDB QXDRPDB | X | X | X | DSUDRPIX DROP INDEX Statements DSUDRPIX QXDRPIX | X | X | X | DSUDRPKG No. DROP PACKAGE Statements DSUDRPKG QXDRPPKG | X | X | X | DSUDRPRO Drop Role Statements DB2DRPRO QXDRPROL | | X | X | DSUDRPST DROP STORAGE GROUP Statements DSUDRPST QXDRPST | X | X | X | DSUDRPSY DROP SYNONYM Statements DSUDRPSY QXDRPSY | X | X | X | DSUDRPTA DROP TABLE Statements DSUDRPTA QXDRPTA | X | X | X | DSUDRPTS DROP TABLESPACE Statements DSUDRPTS QXDRPTS | X | X | X | DSUDRPTX Drop Trusted Context Statements DB2DRPTX QXDRPCTX | | X | X | DSUDRPVU DROP VIEW Statements DSUDRPVU QXDRPVU | X | X | X | DSUDRTA Global Requests Denied DSUDRTA QTGADRTA | X | X | X | DSUDSCRT No. DESCRIBE TABLE Statements DSUDSCRT QXDSCRTB | X | X | X | DSUDSNS No. Wait Trace Events - Dataspace Mgr DB2DSNS QWAXDSNS | X | X | X | DSUDSSTM Accum Wait Time Dataspace Manager DB2DSSTM QWAXDSSE | X | X | X | DSUDSTSN Destination Sequence Number DB2DSTSN QWHSWSEQ | X | X | X | DSUEGENC Parallel Groups Executed Sequential DB2EGENC QXDEGENC | X | X | | DSUELGZP Accumulated CPU Time zIIP-Eligible Work DSUELGZP QWACZIIP_ELIGIBLE | X | X | | DSUENDSC Ending Store Clock DSUENDSC QWACESC | X | X | X | DSUENTCB Ending TCB Timer DSUENTCB QWACEJST | X | X | X | DSUENTEX Number of Entry/Exit Events Processed DSUENTEX QWACARNA | X | X | X | DSUET2TM Elapsed Time in DB2 DSUET2TM QWACASC | X | X | X | DSUEUTX End User Transaction Name DSUEUTX QWHCEUTX | X | X | X | DSUEUWN End User Workstation Name DSUEUWN QWHCEUWN | X | X | X | DSUFCCT No. Wait Trace Events - Force-At-Commit DB2FCCT QWAXFCCT | X | X | X | DSUFETCH Number of FETCH Statements DSUFETCH QXFETCH | X | X | X | DSUFLGS Accounting Class Flags DSUFLGS QWACFLGS | X | X | X | DSUFLSE No. of False Contentions DSUFLSE QTGAFLSE | X | X | X | DSUFRIDS Times RID List Overflowed RID Storage DB2FRIDS QXWFRIDS | | | X | DSUFRIDT Times RID List Overflowed RID Exceeded DB2FRIDT QXWFRIDT | | | X | DSUGPGR0 GETPAGE Requests BP0 DB2GPGRX QBACGET | X | X | X | DSUGPGR1 GETPAGE Requests BP1 DB2GPGRX QBACGET | X | X | X | DSUGPGR2 GETPAGE Requests BP2 DB2GPGRX QBACGET | X | X | X | DSUGPGR3 GETPAGE Requests BP3 DB2GPGRX QBACGET | X | X | X | DSUGRANT GRANT Statements DSUGRANT QXGRANT | X | X | X | DSUIGLO Suspends Due to IRLM Global Contention DSUIGLO QTGAIGLO | X | X | X | DSUINCRB Incremental Binds DSUINCRB QXINCRB | X | X | X | DSUNFLMT No. Infinite Resource Limit DSUNFLMT QTXAFLG1 | | | | DSUINSRT INSERT Statements DSUINSRT QXINSRT | X | X | X | DSUIOETM Accumulated I/O Elapsed Wait Time in DB2 DSUIOETM QWACAWTI | X | X | X | DSUISEQ Instrumentation Sequence Number DB2ISEQ QWHSISEQ | X | X | X | DSUJINCS Times RID List Append RID Storage DB2JINCS QXHJINCS | | | X | DSUIXLE No. Wait Trace Events - Async IXLCACHE DB2IXLE QWAXIXLE | X | X | X | DSUIXLTM Total Wait Time IXLCACHE/FCOMP Asynch DB2IXLTM QWAXIXLT | X | X | X | DSUJINCT Times RID List Append RID Exceeded DB2JINCT QXHJINCT | | | X | DSULABEL Number of LABEL ON Statements DSULABEL QXLABON | X | X | X | DSULEEM Number of Lock Escalations to Exclusive DSULEEM QTXALEX | X | X | X | DSULESM Number of Lock Escalations to Shared DSULESM QTXALES | X | X | X | DSULOCK LOCK TABLE Statements DSULOCK QXLOCK | X | X | X | DSULPF0 No. List Prefetch Requested BP0 DB2LPFX QBACLPF | X | X | X | DSULPF1 No. List Prefetch Requested BP1 DB2LPFX QBACLPF | X | X | X | DSULPF2 No. List Prefetch Requested BP2 DB2LPFX QBACLPF | X | X | X | DSULPF3 No. List Prefetch Requested BP3 DB2LPFX QBACLPF | X | X | X | DSULPLK Lock Requests for Physical Locks DSULPLK QTGALPLK | X | X | X | DSULSLM Lock Requests Propagated to XES DSULSLM QTGALSLM | X | X | X | DSUMERGE Merge Statements DB2MERGE QXMERGE | | X | X | DSUMIOTM Max I/O Elapsed Wait Time in DB2 DSUMIOTM QWACAWTI | X | X | X | DSUMIXNL Mult Indx Not Used - RID Limit DSUMIXNL QXMRMIAP | X | X | X | DSUMIXNU Mult Indx Not Used - No Storage DSUMIXNU QXNSMIAP | X | X | X | DSUMIXU Multiple Index Path Used DSUMIXU QXMIAP | X | X | X | DSUMMXPL Max Max. No. Page Locks Held DSUMMXPL QTXANPL | X | X | X | DSUMXDEG Max Degree of Parallelism DB2MXDEG QXMAXDEG | X | X | X | DSUMXPL Maximum Number of Page Locks Held DSUMXPL QTXANPL | X | X | X | DSUNATHD Count of ACCUMACC Roll-up Threads DSUNATHD QWACPCNT | X | X | X | DSUNETID Network Identifier DSUNETID QWACNID | X | X | X | DSUNGT0 No. Time GETPAGE Req Not Satisfied BP0 DB2NGTX QBACNGT | X | X | X | DSUNGT1 No. Time GETPAGE Req Not Satisfied BP1 DB2NGTX QBACNGT | X | X | X | DSUNGT2 No. Time GETPAGE Req Not Satisfied BP2 DB2NGTX QBACNGT | X | X | X | DSUNGT3 No. Time GETPAGE Req Not Satisfied BP3 DB2NGTX QBACNGT | X | X | X | DSUNOGRP Total Number of Parallel Groups That DB2NOGRP QXNORGRP | X | X | X | DSUNTFY Notify Messages Sent DSUNTFY QTGANTFY | X | X | X | DSUOCNS No. Wait Trace Events - Open/Close/HSM DB2OCNS QWAXOCNS | X | X | X | DSUOCSTM Accum Wait Time Open/Close/HSM DB2OCSTM QWAXOCSE | X | X | X | DSUOPEN OPEN Statements DSUOPEN QXOPEN | X | X | X | DSUOPID Original Operator ID DB2OPID QWHCOPID | X | X | X | DSUORNO Parallel Groups Executed Coordination DB2ORNO QXCOORNO | X | X | X | DSUORR Parallel Groups Executed Repeat-read DB2ORR QXISORR | X | X | X | DSUOTNS No. Wait Trace Events - Other Services DB2OTNS QWAXOTNS | X | X | X | DSUOTSTM Accum Wait Time Other DB2 Services DB2OTSTM QWAXOTSE | X | X | X | DSUPACE Parallel Task Token DSUPACE QWACPACE | X | X | X | DSUPARR No. Rollup Data DSUPARR QWACFLGS | | | | DSUPCNT No. Parallel Tasks Created DSUPCNT QWACPCNT | X | X | X | DSUPCWDP Duplicate Per Parsed Dyna Stmnts DB2PCWDP | | | X | DSUPCWMP Matched Per Parsed Dyna Stmnts DB2PCWMP | | | X | DSUPCWRP Replaced Per Parsed Dyna Stmnts DB2PCWRP | | | X | DSUPEDTM Accum CPU Proc SQL Prior Enclave DB2PEDTM QWACPECD | X | | | DSUPETTM Accum TCB Prior Enclave Create DB2PETTM QWACPECT | X | | | DSUPGDTT Parallel GPS Using UDF - Ex. Single DB2 DB2PGDTT QXDEGDTT | X | X | X | DSUPKGN No. Packages or DBRMs DSUPKGN QWACPKGN | X | X | X | DSUPLAN Plan Name DB2PLAN QWHCPLAN | X | X | X | DSUPLAT Client Platform DSUPLAT QMDAPLAT | X | X | X | DSUPREP PREPARE Statements DSUPREP QXPREP | X | X | X | DSUPRFH0 PREFETCH Read Requests Buffer BP0 DB2PRFHX QBACSEQ | X | X | X | DSUPRFH1 PREFETCH Read Requests Buffer BP1 DB2PRFHX QBACSEQ | X | X | X | DSUPRFH2 PREFETCH Read Requests Buffer BP2 DB2PRFHX QBACSEQ | X | X | X | DSUPRFH3 PREFETCH Read Requests Buffer BP3 DB2PRFHX QBACSEQ | X | X | X | DSURBSV No. SQL Rollback to Savepoint Stmts DB2RBSV QWACRBSV | X | X | X | DSURDGRP Total Number of Parallel Groups That DB2RDGRP QXREDGRP | X | X | X | DSURDLTD Deleted Rows DB2RDLTD QXRWSDELETD | X | X | DSUREVOK REVOKE Statements DSUREVOK QXREVOK | X | X | DSURFCHD Fetched Rows DB2RFCHD QXRWSFETCHD | X | X | DSURLSV No. SQL Release Savepoint Statements DB2RLSV QWACRLSV | X | X | DSURMID DB2 Resource Manager Identifier DB2RMID QWHSRMID | X | X | DSURNIX Rename Index Statements DB2RNIX QXRNIX | | X | X | DSURNKCL No. Wait Trace Glbl Cont. Child LLock DB2RNKCL QWACARNK | X | X | X | DSURNMOL No. Wait Trace Glbl Cont. Other LLock DB2RNMOL QWACARNM | X | X | X | DSURNNPL No. Wait Trace Glbl Cont. PP PLock DB2RNNPL QWACARNN | X | X | X | DSURNOPL No. Wait Trace Glbl Cont. PG PLock DB2RNOPL QWACARNO | X | X | X | DSURNQOL No. Wait Trace Glbl Cont. Other PLock DB2RNQOL QWACARNQ | X | X | X | DSURNSTD Inserted Rows DB2RNSTD QXRWSINSRTD | X | X | DSURPOP1 Parallel GPS Reformatted - Sysplex Conf DB2RPOP1 QXREPOP1 | X | X | DSURPOP2 Parallel GPS Reformatted - Buffer Resrc DB2RPOP2 QXREPOP2 | X | X | DSURUDTD Updated Rows DB2RUDTD QXRWSUPDTD | X | X | DSUSDG Total Unregister Pages Requests DB2SDG QBGADG | X | X | X | DSUSELCT Number of SELECT Statements DSUSELCT QXSELECT | X | X | X | DSUSETHV No. SET HOST-VAR Statements DSUSETHV QXSETHV | X | X | X | DSUSEX Total Explicit XIs DB2SEX QBGAEX | X | X | X | DSUSGG Total GETPAGEs for GBP-Dep Pagesets DB2SGG QBGAGG | X | X | X | DSUSGLO Suspends Due to XES Global Contention DSUSGLO QTGASGLO | X | X | X | DSUSHS Total Asynch IXLCACHE for Prim GBP DB2SHS QBGAHS | X | X | X | DSUSIO0 Number of Sync Read I/Os Issued DB2SIOX QBSTSIO | X | X | X | DSUSIO1 Number of Sync Read I/Os Issued DB2SIOX QBSTSIO | X | X | X | DSUSIO2 Number of Sync Read I/Os Issued DB2SIOX QBSTSIO | X | X | X | DSUSIO3 Number of Sync Read I/Os Issued DB2SIOX QBSTSIO | X | X | X | DSUSKIP Parallel Coordination Bypass DB2 DB2SKIP QXXCSKIP | X | X | X | DSUSLNS No. Wait Trace Events - SYSLGRNG DB2SLNS QWAXSLNS | X | X | X | DSUSLSTM Accum Wait Time SYSLGRNG DB2SLSTM QWAXSLSE | X | X | X | DSUSMD Total CF Reads Data Returned DSUSMD QBGAMD | X | X | X | DSUSMIAP Times RID List Retrieval Skipped DB2SMIAP QXRSMIAP | | | X | DSUSMN Total CF Reads Data Not Ret. No Entry DSUSMN QBGAMN | X | X | X | DSUSMR Total CF Reads Data Not Returned Entry DSUSMR QBGAMR | X | X | X | DSUSPATM Total Elapsed Time Stored Procedures DB2SPATM QWACSPEA | X | X | X | DSUSPBTM Total Elapsed Time in DB2 Stored Proc. DB2SPBTM QWACSPEB | X | X | X | DSUSPCTM Accum CPU Time SQL Procedures Main Unit DB2SPCTM QWACSPNF_CP | | X | X | DSUSPETM Total Elapsed Time Wait for TCB DSUSPETM QWACCAST | X | X | X | DSUSPNE SQL Events by Stored Procs DSUSPNE QWACSPNE | X | X | X | DSUSPPTM CPU Time Stored Proc Address Space DSUSPPTM QWACSPCP | X | X | X | DSUSPRU0 System Page Record Update BP0 DB2SPRUX QBACSWS | X | X | X | DSUSPRU1 System Page Record Update BP1 DB2SPRUX QBACSWS | X | X | X | DSUSPRU2 System Page Record Update BP2 DB2SPRUX QBACSWS | X | X | X | DSUSPRU3 System Page Record Update BP3 DB2SPRUX QBACSWS | X | X | X | DSUSPZET Total Elapsed Time on zIIP Stored Proc. DB2SPZET QWACSPNF_ELAP | | X | X | DSUSPZTM CPU Tm Exec Strd Proc on z/OS Spec Eng DB2SPZTM QWACSPNF_CP | | X | X | DSUSP1 P-Lock Lock Requests-Space Map Pages1 DB2SP1 QBGAP1 | X | X | X | DSUSP2 P-Lock Lock Requests-Data Pages2 DB2SP2 QBGAP2 | X | X | X | DSUSP2TM Accum CPU Time in DB2 Stored Proc. DSUSP2TM QWACSPTT | X | X | X | DSUSP3 P-Lock Lock Requests-Index Leaf Pages3 DB2SP3 QBGAP3 | X | X | X | DSUSPSE1 Accum CPU Tm Exec SP on z/OS Spec Eng DSUSPSE1 QWACSP_CLS1se | | X | X | DSUSPSE2 CPU Tm in DB2 Exec SP on z/OS Spec Eng DSUSPSE2 QWACSP_CLS2se | | X | X | DSUSQLID No. Of Set Current SQLID DSUSQLID QXSETSQL | X | X | X | DSUSRIO0 Synchronous Read IOs BP0 DB2SRIOX QBACRIO | X | X | X | DSUSRIO1 Synchronous Read IOs BP1 DB2SRIOX QBACRIO | X | X | X | DSUSRIO2 Synchronous Read IOs BP2 DB2SRIOX QBACRIO | X | X | X | DSUSRIO3 Synchronous Read IOs BP3 DB2SRIOX QBACRIO | X | X | X | DSUSSW Total CF Writes For Changed Pages DSUSSW QBGASW | X | X | X | DSUSS1 P-Lock Lock Susp. - Space Map Pages 1 DB2SS1 QBGAS1 | X | X | X | DSUSS2 P-Lock Lock Suspensions - Data Pages 2 DB2SS2 QBGAS2 | X | X | X | DSUSS3 P-Lock Lock Susp. - Index Leaf Pages 3 DB2SS3 QBGAS3 | X | X | X | DSUSUCV Raw SU:CPU-second Conversion Factor DB2SUCV QWACSUCV | X | X | X | DSUSUFX DDCS Client Suffix DSUSUFX QMDASUFX | X | X | X | DSUSUSP Suspend Count DSUSUSP QTXASLOC | X | X | X | DSUSU1 P-Lock Unlock Requests1 DB2SU1 QBGAU1 | X | X | X | DSUSVPT No. SQL Savepoint Statements DB2SVPT QWACSVPT | X | X | X | DSUSWC Total CF Writes For Clean Pages DSUSWC QBGAWC | X | X | X | DSUSWM Total Write and Register Multiple Reqs DB2SWM QBGAWM | X | X | X | DSUSWS Total Write and Register Requests DB2SWS QBGAWS | X | X | X | DSUSXD Total CF Reads Buffer XI DSUSXD QBGAXD | X | X | X | DSUS2H Total Asynch IXLCACHE for 2nd GBP DB2S2H QBGA2H | X | X | X | DSUS2S Total Comp Chks 4 Wrts 2nd GBP Suspend DB2S2S QBGA2S | X | X | X | DSUTC2TM Class 2 Accumulated TCB Time in DB2 DSUTC2TM QWACAJST | X | X | X | DSUTEETM Total Elps Tm Exec Trigger Undr Enclave DB2TEETM QWACTREE | X | X | X | DSUTIMO Timeout Count DSUTIMO QTXATIM | X | X | X | DSUTOGRP Total Number of Parallel Groups DB2TOGRP QXTOTGRP | X | X | X | DSUTRTSE Accum CPU Tm Exe Trgrs on z/OS Spec Eng DSUTRTSE QWACTRTE_se | | X | X | DSUTRETM Elapsed Time Executing Control Triggers DB2TRETM QWACTRET | X | X | X | DSUTRTBL Truncate Table Statements DB2TRTBL QXTRTBL | | X | X | DSUTRTTM Accum TCB Time Under Cntl Trigger DB2TRTTM QWACTRTT | X | X | X | DSUTRTZP CPU Tm Exec Triggers on z/OS Spec Eng DSUTRTZP QWACTRTT_ZIIP | X | X | X | DSUTTETM Total TCB Tm Exec Trigger Undr Enclave DB2TTETM QWACTRTE | X | X | X | DSUUDATM Total Elapsed Time UDF DB2UDATM QWACUDEA | X | X | X | DSUUDBTM Total Elapsed Time in DB2 UDF DB2UDBTM QWACUDEB | X | X | X | DSUUDCTM Accum CPU Time UDF DB2UDCTM QWACUDCP | X | X | X | DSUUDSE1 Accum CPU Tm Exec UDF on z/OS Spec Eng DB2UDSE1 QWACUDF_CLS1se | | X | X | DSUUDSE2 CPU Tm in DB2 Exec UDF on z/OS Spec Eng DB2UDSE2 QWACUDF_CLS2se | | X | X | DSUUDSTM Total Elapsed Time UDF Wait for TCB DB2UDSTM QWACUDST | X | X | X | DSUUDTTM Accum CPU Time in DB2 UDF DB2UDTTM QWACUDTT | X | X | X | DSUUPDTE UPDATE Statements DSUUPDTE QXUPDTE | X | X | X | DSUUPLK Unlock Requests for Physical Locks DSUUPLK QTGAUPLK | X | X | X | DSUUSLM Unlock Requests Propagated to XES DSUUSLM QTGAUSLM | X | X | X | DSUWATRA No. Wait Trace Events for Log Reads DSUWATRA QWACANAR | | | | DSUWATRA No. Wait Trace Events for Log Reads DSUWATRA QWAXANAR | X | X | X | DSUWATRB Wt Trace for TCP/IP LOB Material DB2WATRB QWACALBC | | X | X | DSUWATRC Wait Trace for Claims DSUWATRC QWACARNC | | | | DSUWATRC Wait Trace for Claims DSUWATRC QWAXARNC | X | X | X | DSUWATRD Wait Trace for Drain Lock DSUWATRD QWACARND | | | | DSUWATRD Wait Trace for Drain Lock DSUWATRD QWAXARND | X | X | X | DSUWATRG No. Wait Trace for Global Lock DSUWATRG QWACARNJ | X | X | X | DSUWATRL No. Wait Trace Events for Lock/Latch DSUWATRL QWACARNL | X | X | X | DSUWATRM No. Wait Trace Events for Data Shr Msgs DSUWATRM QWACARNG | X | X | X | DSUWATRP Wait Trace for Latch Contention DSUWATRP QWACARNH | X | X | X | DSUWATRR No. Wait Trace Events for Read Other DSUWATRR QWACARNR | X | X | X | DSUWATRW No. Wait Trace Events for Write Other DSUWATRW QWACARNW | X | X | X | DSUWATSE No. Wait Trace Events for Sync. Exec. DSUWATSE QWACARNS | X | X | X | DSUWATTR Number of Wait Trace Events Processed DSUWATTR QWACARNE | X | X | X | DSUWFCTM Total Wait Time for Force-At-Commit DB2WFCTM QWAXAWFC | X | X | X | DSUWLCTM Glbl Contention Child L-Lock Wait Time DB2WLCTM QWACAWTK | X | X | X | DSUWGLTM Glbl Contention PG P-Lock Wait Time DB2WGLTM QWACAWTO | X | X | X | DSUWLLTM Glbl Contention Other L-Locks Wait Time DB2WLLTM QWACAWTM | X | X | X | DSUWLPTM Glbl Contention PP P-Lock Wait Time DB2WLPTM QWACAWTN | X | X | X | DSUWTOTM Glbl Contention Other P-Locks Wait Time DB2WTOTM QWACAWTQ | X | X | X | DSUWLGCT No. Wait Trace Events - Log Write IO DB2WLGCT QWACARLG | X | X | X | DSUWLGTM Accum Wait Time for Log Write IO DB2WLGTM QWACAWLG | X | X | X | DSUWLMCL WLM Service Class Name DB2WLMCL QWACWLME | X | X | X | DSUZRLMT No. Zero Resource Limit DSUZRLMT QTXAFLG1 | | | | ----------------------------------------------------------------------------------------------------------------------------------
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |