The DB2DSD (DB2 Database Activity) File
---------------------------------------------------------------------------------------------------------------------------------- DICTIONARY RAW AVAILABLE IN DB2 VERSIONS ELEMENT ELEMENT DESCRIPTION MEMBER ELEMENT 8.1 9.1 10.1 ---------------------------------------------------------------------------------------------------------------------------------- DB2DSGN Data Sharing Group Name DB2DSGN QWHADSGN | X | X | X | DB2ISEQ Instrumentation Sequence Number DB2ISEQ QWHSISEQ | X | X | X | DB2MEMN DB2 Member Name DB2MEMN QWHAMEMN | X | X | X | DB2RELN DB2 Release Identifier DB2RELN QWHSRELN | X | X | X | DSDABBP0 Active Buffers in Buffer Pool 0 DSDABBPX QBSTCBA | X | X | X | DSDABBP1 Active Buffers in Buffer Pool 1 DSDABBPX QBSTCBA | X | X | X | DSDABBP2 Active Buffers in Buffer Pool 2 DSDABBPX QBSTCBA | X | X | X | DSDABBP3 Active Buffers in Buffer Pool 3 DSDABBPX QBSTCBA | X | X | X | DSDACHG Change Request Count DSDACHG QTXACHG | X | X | X | DSDACHUS Highest CPU 16 Microseconds Used DSDACHUS QTXACHUS | X | X | X | DSDACLMT Limit In CPU 16 Microseconds DSDACLMT QTXACLMT | X | X | X | DSDAFLG Flag Byte DSDAFLG QTXAFLG1 | X | X | X | DSDAIRLM Other IRLM Request Count DSDAIRLM QTXAIRLM | X | X | X | DSDALDAB No. of ALTER DATABASE Stmts DSDALDAB QXALDAB | X | X | X | DSDALLOC Successful Bound Plan Allocations DSDALLOC QTALLOC | X | X | X | DSDALOCA Requests to Allocate Bound Plan DSDALOCA QTALLOCA | X | X | X | DSDALOCC ALLOCATE CURSOR Statements Executed DSDALOCC QXALOCC | X | X | X | DSDALOCK Lock Request Count DSDALOCK QTXALOCK | X | X | X | DSDALOCL Associate Locator Statement Executed DSDALOCL QXALOCL | X | X | X | DSDALPRO Number of Alter Procedure Statements DSDALPRO QXALPRO | X | X | X | DSDALSEQ Alter Sequence Statements DSDALSEQ QXALTSEQ | X | X | X | DSDALTIX ALTER INDEX Statements DSDALTIX QXALTIX | X | X | X | DSDALTJR Alter JAR Statements DB2ALTJR QXAALTJR | | X | X | DSDALTST ALTER STORAGE GROUP Statements DSDALTST QXALTST | X | X | X | DSDALTTA ALTER TABLE Statements DSDALTTA QXALTTA | X | X | X | DSDALTTS ALTER TABLESPACE Statements DSDALTTS QXALTTS | X | X | X | DSDALTTX Alter Trusted Context Statements DB2ALTTX QXALTCTX | | X | X | DSDALTVW Alter View Statements DB2ALTVW QXALTVW | X | X | X | DSDALUDF Number of Alter Function Statements DSDALUDF QXALUDF | X | X | X | DSDAPREC How Limit Was Determined DSDAPREC QTXAPREC | X | X | X | DSDAQRY Query Request Count DSDAQRY QTXAQRY | X | X | X | DSDARLID Resource Limit Table ID DSDARLID QTXARLID | X | X | X | DSDASLAT Suspend Count - Latch Conflict DSDASLAT QTXASLAT | X | X | X | DSDASLMT Limit In SUs - ASUTIME DSDASLMT QTXASLMT | X | X | X | DSDASOTH Suspend Count - Other Conflict DSDASOTH QTXASOTH | X | X | X | DSDATNM Active Trace Number Mask DSDATNM QWHSMTN | X | X | X | DSDAUCHK Authorization Checks DSDAUCHK QTAUCHK | X | X | X | DSDAUD Number of User Defined Functions Exec DSDAUD QXCAUD | X | X | X | DSDAUDAB Times UDF Abended DSDAUDAB QXCAUDAB | X | X | X | DSDAUDRJ Times UDF was Rejected DSDAUDRJ QXCAUDRJ | X | X | X | DSDAUDTO Times UDF Timed out Waiting Schedule DSDAUDTO QXCAUDTO | X | X | X | DSDAUNLK Unlock Request Count DSDAUNLK QTXAUNLK | X | X | X | DSDAUPUB AUTH Checks Based PUBLIC Auth DSDAUPUB QTAUPUB | X | X | X | DSDAUTOB Attempts To AUTOBIND a Pkg DSDAUTOB QTAUTOBA | X | X | X | DSDBIND Successful Automatic Binds DSDBIND QTABIND | X | X | X | DSDBINDA Automatic Bind Attempts DSDBINDA QTABINDA | X | X | X | DSDBNDAA Bind Action ADD Subcommands DSDBNDAA QTBINDA | X | X | X | DSDBNDAR Bind Action REPLACE Subcommands DSDBNDAR QTBINDR | X | X | X | DSDBNDPA BIND (ADD) PACKAGE Sub-Cmnds DSDBNDPA QTBINDPA | X | X | X | DSDBNDPR BIND (REP) PACKAGE Sub-Cmnds DSDBNDPR QTBINDPR | X | X | X | DSDBPNX Parallel Groups Run Cross Data Share DSDBPNX QXXCBPNX | X | X | X | DSDBPSO0 Buffer Pool Data Sets Opened DSDBPSOX QBSTDSO | X | X | X | DSDBPSO1 Buffer Pool Data Sets Opened DSDBPSOX QBSTDSO | X | X | X | DSDBPSO2 Buffer Pool Data Sets Opened DSDBPSOX QBSTDSO | X | X | X | DSDBPSO3 Buffer Pool Data Sets Opened DSDBPSOX QBSTDSO | X | X | X | DSDCALL SQL CALL Statements Executed DSDCALL QXCALL | X | X | X | DSDCALLA Times Stored Procedure Abended DSDCALLA QXCALLAB | X | X | X | DSDCALLR Times SQL CALL Stmt Was Rejected DSDCALLR QXCALLRJ | X | X | X | DSDCALLT Times SQL CALL Stmt Timed Out DSDCALLT QXCALLTO | X | X | X | DSDCDIST Create Distinct Type Statements DSDCDIST QXCDIST | X | X | X | DSDCHNP Changep Requests DSDCHNP QTGSCHNP | X | X | X | DSDCLNO Number of Claim Requests DSDCLNO QTXACLNO | X | X | X | DSDCLOSE CLOSE Statements DSDCLOSE QXCLOSE | X | X | X | DSDCLUN Number of Unsuccessful Claim Requests DSDCLUN QTXACLUN | X | X | X | DSDCMTON COMMENT ON Statements DSDCMTON QXCMTON | X | X | X | DSDCOLS Invalid Select Procedure Encountered DSDCOLS QISTCOLS | X | X | X | DSDCON1 Number of Connect Type 1 Statements DSDCON1 QXCON1 | X | X | X | DSDCON2 Number of Connect Type 2 Statements DSDCON2 QXCON2 | X | X | X | DSDCRAL Create Alias DSDCRAL QXCRALS | X | X | X | DSDCRATB Create AUX Table Statements DSDCRATB QXCRATB | X | X | X | DSDCRCTX Create Trusted Context Statements DB2CRCTX QXCRCTX | | X | X | DSDCRDAB CREATE DATABASE Statements DSDCRDAB QXCRDAB | X | X | X | DSDCRGTT Create Global Temporary Table DSDCRGTT QXCRGTT | X | X | X | DSDCRINX CREATE INDEX Statements DSDCRINX QXCRINX | X | X | X | DSDCRPRO Create Procedure Statements DSDCRPRO QXCRPRO | X | X | X | DSDCRROL Create Role Statements DB2CRROL QXCRROL | | X | X | DSDCRSEQ Create Sequence Statements DSDCRSEQ QXCRESEQ | X | X | X | DSDCRSTG CREATE STORAGE GROUP Statements DSDCRSTG QXCRSTG | X | X | X | DSDCRSYN CREATE SYNONYM Statements DSDCRSYN QXCRSYN | X | X | X | DSDCRTAB CREATE TABLE Statements DSDCRTAB QXCRTAB | X | X | X | DSDCRUDF Create Function Statements DSDCRUDF QXCRUDF | X | X | X | DSDCSLM Change Requests Propagated to XES DSDCSLM QTGSCSLM | X | X | X | DSDCTABS CREATE TABLESPACE Statements DSDCTABS QXCTABS | X | X | X | DSDCTRIG Number of Create Triggers DSDCTRIG QXCTRIG | X | X | X | DSDCWLD Times Duplicate Concentrate Dyna Stmnts DB2CWLD QXSTCWLD | X | X | X | DSDCWLM Times Matched Concentrate Dyna Stmnts DB2CWLM QXSTCWLM | X | X | X | DSDCWLP Times Parsed Concentrate Dyna Stmnts DB2CWLP QXSTCWLP | X | X | X | DSDCWLR Times Replaced Concentrate Dyna Stmnts DB2CWLR QXSTCWLR | X | X | X | DSDDBDG Requests for Database Descriptors DSDDBDG QISEDBDG | X | X | X | DSDDBDL Number of Loads: Database Descriptors DSDDBDL QISEDBDL | X | X | X | DSDDBPR0 Physical Database Page Requests 0 DSDDBPRX QBSTGET | X | X | X | DSDDBPR1 Physical Database Page Requests 1 DSDDBPRX QBSTGET | X | X | X | DSDDBPR2 Physical Database Page Requests 2 DSDDBPRX QBSTGET | X | X | X | DSDDBPR3 Physical Database Page Requests 3 DSDDBPRX QBSTGET | X | X | X | DSDDBPU0 Database Page Updates 0 DSDDBPUX QBSTSWS | X | X | X | DSDDBPU1 Database Page Updates 1 DSDDBPUX QBSTSWS | X | X | X | DSDDBPU2 Database Page Updates 2 DSDDBPUX QBSTSWS | X | X | X | DSDDBPU3 Database Page Updates 3 DSDDBPUX QBSTSWS | X | X | X | DSDDCGTT Declare Global Temporary Table Stmts DSDDCGTT QXDCLGTT | X | X | X | DSDDDIST Drop Distinct Type Statements DSDDDIST QXDDIST | X | X | X | DSDDEAD Deadlock Count DSDDEAD QTXADEA | X | X | X | DSDDEFVU CREATE VIEW Statements DSDDEFVU QXDEFVU | X | X | X | DSDDELET DELETE Statements DSDDELET QXDELET | X | X | X | DSDDESC DESCRIBE Statements DSDDESC QXDESC | X | X | X | DSDDEXP PREPARE Discarded DSDDEXP QXSTDEXP | X | X | X | DSDDGBUF Total Number of Parallel Groups That DSDDGBUF QXDEGBUF | X | X | X | DSDDGCUR Parallel Groups to Seq Cursor Update DSDDGCUR QXDEGCUR | X | X | X | DSDDGESA Parallel Groups to Seq No ESA Sort DSDDGESA QXDEGESA | X | X | X | DSDDINV PREPARE Purged DSDDINV QXSTDINV | X | X | X | DSDDIO0 Async Read I/Os via Dynamic Pref. BP0 DSDDIOX QBSTDIO | X | X | X | DSDDIO1 Async Read I/Os via Dynamic Pref. BP1 DSDDIOX QBSTDIO | X | X | X | DSDDIO2 Async Read I/Os via Dynamic Pref. BP2 DSDDIOX QBSTDIO | X | X | X | DSDDIO3 Async Read I/Os via Dynamic Pref. BP3 DSDDIOX QBSTDIO | X | X | X | DSDDLRU Number of Stealable DB Descriptors DSDDLRU QISEDLRU | | | X | DSDDMCT0 No. Times DM Critical WPHFWT reached 0 DSDDMCTX QBSTDMC | X | X | X | DSDDMCT1 No. Times DM Critical WPHFWT reached 1 DSDDMCTX QBSTDMC | X | X | X | DSDDMCT2 No. Times DM Critical WPHFWT reached 2 DSDDMCTX QBSTDMC | X | X | X | DSDDMCT3 No. Times DM Critical WPHFWT reached 3 DSDDMCTX QBSTDMC | X | X | X | DSDDPF0 No. Times Dynamic Prefetch Req. BP0 DB2DPFX QBACDPF | X | X | X | DSDDPF1 No. Times Dynamic Prefetch Req BP1 DB2DPFX QBACDPF | X | X | X | DSDDPF2 No. Times Dynamic Prefetch Req BP2 DB2DPFX QBACDPF | X | X | X | DSDDPF3 No. Times Dynamic Prefetch Req BP3 DB2DPFX QBACDPF | X | X | X | DSDDPP0 Async Page Reads via Dynamic Pref. BP0 DSDDPPX QBSTDPP | X | X | X | DSDDPP1 Async Page Reads via Dynamic Pref. BP1 DSDDPPX QBSTDPP | X | X | X | DSDDPP2 Async Page Reads via Dynamic Pref. BP2 DSDDPPX QBSTDPP | X | X | X | DSDDPP3 Async Page Reads via Dynamic Pref. BP3 DSDDPPX QBSTDPP | X | X | X | DSDDRAL Drop Alias DSDDRAL QXDRPAL | X | X | X | DSDDRNO Number of Drain Requests DSDDRNO QTXADRNO | X | X | X | DSDDRPDB DROP DATABASE Statements DSDDRPDB QXDRPDB | X | X | X | DSDDRPFN Number of Drop User Defined Function DSDDRPFN QXDRPFN | X | X | X | DSDDRPIX DROP INDEX Statements DSDDRPIX QXDRPIX | X | X | X | DSDDRPKG No. of DROP PACKAGE Stmts DSDDRPKG QXDRPPKG | X | X | X | DSDDRPPR Number of Drop Procedures DSDDRPPR QXDRPPR | X | X | X | DSDDRPRO Drop Role Statements DB2DRPRO QXDRPROL | | X | X | DSDDRPST DROP STORAGE GROUP Statements DSDDRPST QXDRPST | X | X | X | DSDDRPSY DROP SYNONYM Statements DSDDRPSY QXDRPSY | X | X | X | DSDDRPTA DROP TABLE Statements DSDDRPTA QXDRPTA | X | X | X | DSDDRPTR Number of Drop Triggers DSDDRPTR QXDRPTR | X | X | X | DSDDRPTS DROP TABLESPACE Statements DSDDRPTS QXDRPTS | X | X | X | DSDDRPTX Drop Trusted Context Statements DB2DRPTX QXDRPCTX | | X | X | DSDDRPVU DROP VIEW Statements DSDDRPVU QXDRPVU | X | X | X | DSDDRSEQ Drop Sequence Statements DSDDRSEQ QXDROSEQ | X | X | X | DSDDRTA Global Requests Denied DSDDRTA QTGSDRTA | X | X | X | DSDDRUN Number of Unsuccessful Drain Requests DSDDRUN QTXADRUN | X | X | X | DSDDSCRT No. of DESCRIBE TABLE Stmts DSDDSCRT QXDSCRTB | X | X | X | DSDDSDRN DDs That Drain Has Produced DSDDSDRN QTDSDRN | X | X | X | DSDDSOPN Data Sets Currently Open DSDDSOPN QTDSOPN | X | X | X | DSDDSPBD Plans Bound and Kept DSDDSPBD QTPLNBD | X | X | X | DSDDSTSN Destination Sequence Number DB2DSTSN QWHSWSEQ | X | X | X | DSDDWRT0 Times Deferred Write Threshold Reached 0 DSDDWRTX QBSTDWT | X | X | X | DSDDWRT1 Times Deferred Write Threshold Reached 1 DSDDWRTX QBSTDWT | X | X | X | DSDDWRT2 Times Deferred Write Threshold Reached 2 DSDDWRTX QBSTDWT | X | X | X | DSDDWRT3 Times Deferred Write Threshold Reached 3 DSDDWRTX QBSTDWT | X | X | X | DSDDWV0 Times Vert. Defer. Write Thresh BP0 DSDDWVX QBSTDWV | X | X | X | DSDDWV1 Times Vert. Defer. Write Thresh BP1 DSDDWVX QBSTDWV | X | X | X | DSDDWV2 Times Vert. Defer. Write Thresh BP2 DSDDWVX QBSTDWV | X | X | X | DSDDWV3 Times Vert. Defer. Write Thresh BP3 DSDDWVX QBSTDWV | X | X | X | DSDECFAL No. of Failures: Full Statement Pool DSDECFAL QISECFAL | X | X | X | DSDECFRE No. of Free Pages in Statement Pool DSDECFRE QISECFRE | X | X | X | DSDECPGE No. of Pages in Statement Pool DSDECPGE QISECPGE | X | X | X | DSDECTA Pages Used for Cursor Tables Above 2GB DSDECTA QISECTA | | X | X | DSDECTG Requests for Cursor Table Sections DSDECTG QISECTG | X | X | X | DSDECTL Number of Loaded Cursor Table Sections DSDECTL QISECTL | X | X | X | DSDECTU Pages Used for Cursor Tables Below 2GB DSDECTU QISECT | X | X | | DSDEDFAL Number of Fails Due to Dataspace Full DSDEDFAL QISEDFAL | X | X | X | DSDEDFRE Number of Free pages in Dataspace DSDEDFRE QISEDFRE | X | X | X | DSDEDPGE Number of Pages in EDM Dataspace DSDEDPGE QISEDPGE | X | X | X | DSDEDSG Number of Requests for Dynamic Cache DSDEDSG QISEDSG | X | X | X | DSDEDSI Number of Inserts for Dynamic Cache DSDEDSI QISEDSI | X | X | X | DSDEDYNP No. of Pages Used in Statement Pool DSDEDYNP QISEDYNP | X | X | X | DSDEFAL Number of Failures Due to Full EDM Pool DSDEFAL QISEFAIL | X | X | X | DSDEGENC Parallel Groups Executed Sequential DSDEGENC QXDEGENC | X | X | | DSDEKFAL No. of Failures: Full Skeleton Pool DSDEKFAL QISEKFAL | | X | X | DSDEKFRE No. of Free Pages in Skeleton Pool DSDEKFRE QISEKFRE | | X | X | DSDEKNFA NOT FOUND Records Added to EDM Cache DSDEKNFA QISEKNFA | | X | X | DSDEKNFM NOT FOUND Records in EDM Cache DSDEKNFM QISEKNFM | | X | X | DSDEKNFR NOT FOUND Recs. Removed from EDM Cache DSDEKNFR QISEKNFR | | X | X | DSDEKPGE No. of Pages in Skeleton Pool DSDEKPGE QISEKPGE | | X | X | DSDEPTA Pages Used for Package Tables Above 2GB DSDEPTA QISEKTA | | X | X | DSDEPTG No. Req for Package Table Sections DSDEPTG QISEKTG | X | X | X | DSDEPTL No. Loaded Package Table Sections DSDEPTL QISEKTL | X | X | X | DSDEPTU Pages Used for Package Tables Below 2GB DSDEPTU QISEKT | X | X | | DSDESFAL No. of Failures: Full Stmt (>2GB) Pool DSDESFAL QISESFAL | | X | X | DSDESFRE No. of Free Pages in Stmt (>2GB) Pool DSDESFRE QISESFRE | | X | X | DSDESKC No. Free Pages Used for SKCT Table DSDESKC QISESKCT | X | X | X | DSDESKP No. Free Pages Used for SKPT Table DSDESKP QISESKPT | X | X | X | DSDESPGE No. of Pages in Statement (>2GB) Pool DSDESPGE QISESPGE | | X | X | DSDESTMT No. of Statements in EDM Pool DSDESTMT QISESTMT | X | X | X | DSDFETCH Number of FETCH Statements DSDFETCH QXFETCH | X | X | X | DSDFLSE No. of False Contentions DSDFLSE QTGSFLSE | X | X | X | DSDFND PREPARE Request Satisfied DSDFND QXSTFND | X | X | X | DSDFREAP Attempts To FREE a Package DSDFREAP QTFREEAP | X | X | X | DSDFREE FREE Subcommands DSDFREE QTFREE | X | X | X | DSDFREEA Attempts to FREE Plan DSDFREEA QTFREEA | X | X | X | DSDFREEL Free Locator Statements DSDFREEL QXFREEL | X | X | X | DSDFREEP Plan Successfully Freed DSDFREEP QTPLNFRD | X | X | X | DSDFREPK FREE PACKAGE Sub-Cmnds DSDFREPK QTFREEP | X | X | X | DSDFRIDS Times RID List Overflowed RID Storage DB2FRIDS QXWFRIDS | | | X | DSDFRIDT Times RID List Overflowed RID Exceeded DB2FRIDT QXWFRIDT | | | X | DSDFRPG Number of Free Pages in Free Chain DSDFRPG QISEFREE | X | X | | DSDGRANT GRANT Statements DSDGRANT QXGRANT | X | X | X | DSDHOLDL Hold Locator Statements DSDHOLDL QXHOLDL | X | X | X | DSDIGLO Suspends Due to IRLM Global Contention DSDIGLO QTGSIGLO | X | X | X | DSDIMAC Curr Active DM In-Memory Workfiles DSDIMAC QISTIMAC | | | X | DSDIMAH Hi-Watermark Cnt Max DM In-Mem WFs DSDIMAH QISTIMAH | | | X | DSDIMSC Total Used Space DM In-Mem Workfiles KB DSDIMSC QISTIMSC | | | X | DSDIMSH Hi-Watermark Cnt Max Space DM In-Mem WFs DSDIMSH QISTIMSH | | | X | DSDIMWS0 Count of Immediate Writes Sys Pages 0 DSDIMWSX QBSTIMW | X | X | X | DSDIMWS1 Count of Immediate Writes Sys Pages 1 DSDIMWSX QBSTIMW | X | X | X | DSDIMWS2 Count of Immediate Writes Sys Pages 2 DSDIMWSX QBSTIMW | X | X | X | DSDIMWS3 Count of Immediate Writes Sys Pages 3 DSDIMWSX QBSTIMW | X | X | X | DSDINCRB Incremental Binds DSDINCRB QXINCRB | X | X | X | DSDINSRT INSERT Statements DSDINSRT QXINSRT | X | X | X | DSDIPRP Implicit PREPARE Performed DSDIPRP QXSTIPRP | X | X | X | DSDISEQ Instrumentation Sequence Number DB2ISEQ QWHSISEQ | X | X | X | DSDJINCS Times RID List Append RID Storage DB2JINCS QXHJINCS | | | X | DSDJINCT Times RID List Append RID Exceeded DB2JINCT QXHJINCT | | | X | DSDJIS0 Total No. Pref. I/O Streams Denied BP0 DSDJISX QBSTJIS | X | X | X | DSDJIS1 Total No. Pref. I/O Streams Denied BP1 DSDJISX QBSTJIS | X | X | X | DSDJIS2 Total No. Pref. I/O Streams Denied BP2 DSDJISX QBSTJIS | X | X | X | DSDJIS3 Total No. Pref. I/O Streams Denied BP3 DSDJISX QBSTJIS | X | X | X | DSDKIDS Locks Propagated By IRLM to XES SYNC DSDKIDS QTGSKIDS | X | X | X | DSDKLRU Number of Stealable Skeleton Pkg Table DSDKLRU QISEKLRU | | | X | DSDKSPA Number of Pages Alloc for Exec Procs DSDKSPA QISEKSPA | | | X | DSDLABEL Number of LABEL ON Statements DSDLABEL QXLABON | X | X | X | DSDLEEM Count of Escalations to Exclusive Mode DSDLEEM QTXALEX | X | X | X | DSDLESM Number of Lock Escalations to Shared DSDLESM QTXALES | X | X | X | DSDLIO0 Async Read I/Os via List Prefetch BP0 DSDLIOX QBSTLIO | X | X | X | DSDLIO1 Async Read I/Os via List Prefetch BP1 DSDLIOX QBSTLIO | X | X | X | DSDLIO2 Async Read I/Os via List Prefetch BP2 DSDLIOX QBSTLIO | X | X | X | DSDLIO3 Async Read I/Os via List Prefetch BP3 DSDLIOX QBSTLIO | X | X | X | DSDLOCK LOCK TABLE Statements DSDLOCK QXLOCK | X | X | X | DSDLPF0 No. List Prefetch Requested BP0 DB2LPFX QBSTLPF | X | X | X | DSDLPF1 No. List Prefetch Requested BP1 DB2LPFX QBSTLPF | X | X | X | DSDLPF2 No. List Prefetch Requested BP2 DB2LPFX QBSTLPF | X | X | X | DSDLPF3 No. List Prefetch Requested BP3 DB2LPFX QBSTLPF | X | X | X | DSDLPLK Lock Requests for Physical Locks DSDLPLK QTGSLPLK | X | X | X | DSDLPP0 Async Page Reads via List Prefetch BP0 DSDLPPX QBSTLPP | X | X | X | DSDLPP1 Async Page Reads via List Prefetch BP1 DSDLPPX QBSTLPP | X | X | X | DSDLPP2 Async Page Reads via List Prefetch BP2 DSDLPPX QBSTLPP | X | X | X | DSDLPP3 Async Page Reads via List Prefetch BP3 DSDLPPX QBSTLPP | X | X | X | DSDLSLM Lock Requests Propagated to XES DSDLSLM QTGSLSLM | X | X | X | DSDMAX0 BP Not Supp Concur WK File 0 DSDMAXX QBSTMAX | X | X | X | DSDMAX1 BP Not Supp Concur WK File 1 DSDMAXX QBSTMAX | X | X | X | DSDMAX2 BP Not Supp Concur WK File 2 DSDMAXX QBSTMAX | X | X | X | DSDMAX3 BP Not Supp Concur WK File 3 DSDMAXX QBSTMAX | X | X | X | DSDMERGE Merge Statements DB2MERGE QXMERGE | | X | X | DSDMIXNL Mult Indx Not Used - RID Limit DSDMIXNL QXMRMIAP | X | X | X | DSDMIXNU Mult Indx Not Used - No Storage DSDMIXNU QXNSMIAP | X | X | X | DSDMIXU Multiple Index Path Used DSDMIXU QXMIAP | X | X | X | DSDMMRR0 Media Manager Read Requests 0 DSDMMRRX QBSTRIO | X | X | X | DSDMMRR1 Media Manager Read Requests 1 DSDMMRRX QBSTRIO | X | X | X | DSDMMRR2 Media Manager Read Requests 2 DSDMMRRX QBSTRIO | X | X | X | DSDMMRR3 Media Manager Read Requests 3 DSDMMRRX QBSTRIO | X | X | X | DSDMNCFR Min Free Pages in Statement Pool DSDMNCFR QISECFRE | X | X | X | DSDMNDRU Min Stealable DB Descriptors DSDMNDRU QISEDLRU | | | X | DSDMNKFR Min Free Pages in Skeleton Pool DSDMNKFR QISEKFRE | | X | X | DSDMNKRU Min Stealable Skeleton Pkg Table DSDMNKRU QISEKLRU | | | X | DSDMNQCA Min Storage Alloc for Plans (>2GB) Bar DSDMNQCA QISESQCA | | | X | DSDMNQCB Min Storage Alloc for Plans (<2GB) Bar DSDMNQCB QISESQCB | | | X | DSDMNQKA Min Storage Alloc for Pkgs (>2GB) Bar DSDMNQKA QISESQKA | | | X | DSDMNQKB Min Storage Alloc for Pkgs (<2GB) Bar DSDMNQKB QISESQKB | | | X | DSDMNRPG Min Free Pages in Free Chain DSDMNRPG QISEFREE | X | X | X | DSDMNSFR Min Free Pages in Statement (>2GB) Pool DSDMNSFR QISESFRE | | X | X | DSDMNSPA Min Pgs Alloc for Exec Procs DSDMNSPA QISEKSPA | | | X | DSDMXBDG Max Requests for DBD DSDMXBDG QISEDBDG | X | X | X | DSDMXBDL Max Loads of DBD DSDMXBDL QISEDBDL | X | X | X | DSDMXCFA Max Failures: Full Statement Pool DSDMXCFA QISECFAL | X | X | X | DSDMXCFR Max Free Pages in Statement Pool DSDMXCFR QISECFRE | X | X | X | DSDMXCPG Max Pages in Statement Pool DSDMXCPG QISECPGE | X | X | X | DSDMXCTA Max Pages Used for Cursor Tables (>2GB) DSDMXCTA QISECTA | | X | X | DSDMXCTG Max Requests for Cursor Table Section DSDMXCTG QISECTG | X | X | X | DSDMXCTL Max Loaded Cursor Table Sections DSDMXCTL QISECTL | X | X | X | DSDMXCTU Max Pages Used for Cursor Table (<2GB) DSDMXCTU QISECT | X | X | X | DSDMXCUR Max PB Count On Free PB DSDMXCUR QTMAXPB | X | X | X | DSDMXDBD Max Pages Used for DBD DSDMXDBD QISEDBD | X | X | X | DSDMXDEG Max Degree of Parallelism DSDMXDEG QXMAXDEG | X | X | X | DSDMXDRS Max DDs That Drain Has Produced DSDMXDRS QTDSDRN | X | X | X | DSDMXDRU Max Stealable Database Descriptors DSDMXDRU QISEDLRU | | | X | DSDMXDSO Max Data Sets Open Concurrently DSDMXDSO QTMAXDS | X | X | X | DSDMXDYN Max Pages Used in Statement Pool DSDMXDYN QISEDYNP | X | X | X | DSDMXFAL Max of Failures Due EDM Pool Full DSDMXFAL QISEFAIL | X | X | X | DSDMXKFA Max Failures: Full Skeleton Pool DSDMXKFA QISEKFAL | | X | X | DSDMXKFR Max Free Pages in Skeleton Pool DSDMXKFR QISEKFRE | | X | X | DSDMXKPG Max Pages in Skeleton Pool DSDMXKPG QISEKPGE | | X | X | DSDMXKRU Max Stealable Skeleton Pkg Table DSDMXKRU QISEKLRU | | | X | DSDMXNSQ Max Level of Nested SQL Cascading DSDMXNSQ QXCASCDP | X | X | X | DSDMXPGE Max Pages in EDM Pool DSDMXPGE QISEPAGE | X | X | X | DSDMXPL Maximum Number of Page Locks Held DSDMXPL QTXANPL | X | X | X | DSDMXPTA Max Pages Used for Pkg Tables (>2GB) DSDMXPTA QISEKTA | | X | X | DSDMXPTG Max Requests for Package Table Section DSDMXPTG QISEKTG | X | X | X | DSDMXPTL Max Loaded Package Table Sections DSDMXPTL QISEKTL | X | X | X | DSDMXPTU Max Pages Used for Pkg Tables (<2GB) DSDMXPTU QISEKT | X | X | X | DSDMXQCA Max Storage Alloc for Plans (>2GB) Bar DSDMXQCA QISESQCA | | | X | DSDMXQCB Max Storage Alloc for Plans (<2GB) Bar DSDMXQCB QISESQCB | | | X | DSDMXQKA Max Storage Alloc for Pkgs (>2GB) Bar DSDMXQKA QISESQKA | | | X | DSDMXQKB Max Storage Alloc for Pkgs (<2GB) Bar DSDMXQKB QISESQKB | | | X | DSDMXROP Max PB Found on Free Q During Open DSDMXROP QTREOPN | X | X | X | DSDMXRPG Max Free Pages in Free Chain DSDMXRPG QISEFREE | X | X | X | DSDMXSFA Max Failures: Full Stmt (>2GB) Pool DSDMXSFA QISESFAL | | X | X | DSDMXSFR Max Free Pages in Statement (>2GB) Pool DSDMXSFR QISESFRE | | X | X | DSDMXSKC Max Pages Used for SKCT Table DSDMXSKC QISESKCT | X | X | X | DSDMXSKP Max Pages Used for SKPT Table DSDMXSKP QISESKPT | X | X | X | DSDMXSLW Max DDs Used for Slow Close TS DSDMXSLW QTSLWDD | X | X | X | DSDMXSPA Max Pgs Alloc for Exec Procs DSDMXSPA QISEKSPA | | | X | DSDMXSPG Max Pages in Statement (>2GB) Pool DSDMXSPG QISESPGE | | X | X | DSDMXSTM Max Number of Statements in EDM Pool DSDMXSTM QISESTMT | X | X | X | DSDMXWF Max Allow Per Agent Storage Use Limit KB DSDMXWF QISTWFMX | | X | X | DSDNFLMT No. Infinite Resource Limit DSDNFLMT QTXAFLG1 | | | X | DSDNFND PREPARE Request - No Match DSDNFND QXSTNFND | X | X | X | DSDNOGRP Total Number of Parallel Groups That DSDNOGRP QXNORGRP | X | X | X | DSDNPRP PREPARE Avoided DSDNPRP QXSTNPRP | X | X | X | DSDNTFR Notify Messages Received DSDNTFR QTGSNTFR | X | X | X | DSDNTFY Notify Messages Sent DSDNTFY QTGSNTFY | X | X | X | DSDNVRID Allocate Requests Nonexistent Plan DSDNVRID QTINVRID | X | X | X | DSDOPEN OPEN Statements DSDOPEN QXOPEN | X | X | X | DSDORNO Parallel Groups Executed Coordination DSDORNO QXCOORNO | X | X | X | DSDORR Parallel Groups Executed Repeat-read DSDORR QXISORR | X | X | X | DSDOTPE Negotiate Other Physical Lock DSDOTPE QTGSOTPE | X | X | X | DSDPAGE No. Pages in EDM Pool DSDPAGE QISEPAGE | X | X | | DSDPCAUT Auth Checks Using Package Auth Cache DSDPCAUT QTPACAUT | X | X | X | DSDPCNOT Auth Checks Not Using Package Auth Cach DSDPCNOT QTPACNOT | X | X | X | DSDPCOW1 Overwrote Authid In Cache DSDPCOW1 QTPACOW1 | X | X | X | DSDPCOW2 Overwrote Package Entry in Cache DSDPCOW2 QTPACOW2 | X | X | X | DSDPCPUB Auth Checks for Package Held by Public DSDPCPUB QTPACPUB | X | X | X | DSDPCWDP Duplicate Per Parsed Dyna Stmnts DB2PCWDP | | | X | DSDPCWMP Matched Per Parsed Dyna Stmnts DB2PCWMP | | | X | DSDPCWRP Replaced Per Parsed Dyna Stmnts DB2PCWRP | | | X | DSDPEMX Engines Available For Exit Requests DSDPEMX QTGSPEMX | X | X | X | DSDPEQW Times Engine Not Available For Exit DSDPEQW QTGSPEQW | X | X | X | DSDPGDTT Parallel GPS Using UDF - Ex. Single DB2 DSDPGDTT QXDEGDTT | X | X | X | DSDPGPE Negotiate Page Physical Lock DSDPGPE QTGSPGPE | X | X | X | DSDPKABN Packages Autobound DSDPKABN QTPKABND | X | X | X | DSDPKALC Attempts To Allocate a Pkg DSDPKALC QTPKALLA | X | X | X | DSDPKALL Packages Allocated DSDPKALL QTPKALL | X | X | X | DSDPKGBD Packages Bound DSDPKGBD QTPKGBD | X | X | X | DSDPKGFR Packages Freed DSDPKGFR QTPKGFRD | X | X | X | DSDPL10 Total Times Pref. Qty 1/2 Normal BP0 DSDPL1X QBSTPL1 | X | X | X | DSDPL11 Total Times Pref. Qty 1/2 Normal BP1 DSDPL1X QBSTPL1 | X | X | X | DSDPL12 Total Times Pref. Qty 1/2 Normal BP2 DSDPL1X QBSTPL1 | X | X | X | DSDPL13 Total Times Pref. Qty 1/2 Normal BP3 DSDPL1X QBSTPL1 | X | X | X | DSDPL20 Total Times Pref. Qty 1/4 Normal BP0 DSDPL2X QBSTPL2 | X | X | X | DSDPL21 Total Times Pref. Qty 1/4 Normal BP1 DSDPL2X QBSTPL2 | X | X | X | DSDPL22 Total Times Pref. Qty 1/4 Normal BP2 DSDPL2X QBSTPL2 | X | X | X | DSDPL23 Total Times Pref. Qty 1/4 Normal BP3 DSDPL2X QBSTPL2 | X | X | X | DSDPPPE Negotiate Pageset/Partition Phys Lock DSDPPPE QTGSPPPE | X | X | X | DSDPQF0 Total Times Parallel Buf. Not Alloc BP0 DSDPQFX QBSTPQF | X | X | X | DSDPQF1 Total Times Parallel Buf. Not Alloc BP1 DSDPQFX QBSTPQF | X | X | X | DSDPQF2 Total Times Parallel Buf. Not Alloc BP2 DSDPQFX QBSTPQF | X | X | X | DSDPQF3 Total Times Parallel Buf. Not Alloc BP3 DSDPQFX QBSTPQF | X | X | X | DSDPQO0 Total No. Parallel Queries BP0 DSDPQOX QBSTPQO | X | X | X | DSDPQO1 Total No. Parallel Queries BP1 DSDPQOX QBSTPQO | X | X | X | DSDPQO2 Total No. Parallel Queries BP2 DSDPQOX QBSTPQO | X | X | X | DSDPQO3 Total No. Parallel Queries BP3 DSDPQOX QBSTPQO | X | X | X | DSDPREP PREPARE Statements DSDPREP QXPREP | X | X | X | DSDPREPI Prepare Statements Restricted DSDPREPI QXPRRESI | X | X | X | DSDRBND Successful Rebind Plan DSDRBND QTPLNRBD | X | X | X | DSDRBNDA Rebind Plan Attempts DSDRBNDA QTRBINDA | X | X | X | DSDRBNDP REBIND PACKAGE Sub-Cmnds DSDRBNDP QTRBINDP | X | X | X | DSDRBNPA Attempts To REBIND a Package DSDRBNPA QTRBNDPA | X | X | X | DSDRCAUT Auth Chks for Routine Using Cache DSDRCAUT QTRACAUT | X | X | X | DSDRCCD Committed Delete Read - Rows Accessed DSDRCCD QISTRCCD | | | X | DSDRCCI Committed Insert Read - Rows Skipped DSDRCCI QISTRCCI | | | X | DSDRCCU Committed Update Read - Rows Accessed DSDRCCU QISTRCCU | | | X | DSDRCNAC Unable to Add Entry in Routine Cache DSDRCNAC QTRACNAC | X | X | X | DSDRCNOT Rtn Auth Chks Not Using Rtn Cache DSDRCNOT QTRACNOT | X | X | X | DSDRCOW1 DB2 Overwrote Authid in Rtn Cache DSDRCOW1 QTRACOW1 | X | X | X | DSDRCOW2 DB2 Overwrote Rtn Entry in Rtn Cache DSDRCOW2 QTRACOW2 | X | X | X | DSDRCPUB Auth Chks for Routine Held by Public DSDRCPUB QTRACPUB | X | X | X | DSDRCUR INT BLKS Currently Allocated DSDRCUR QISTRCUR | X | X | X | DSDRDGRP Total Number of Parallel Groups That DSDRDGRP QXREDGRP | X | X | X | DSDRDLTD Deleted Rows DB2RDLTD QXRWSDELETD | X | X | DSDREBND REBIND Subcommands DSDREBND QTREBIND | X | X | X | DSDREEP0 Sequential Prefetch Disabled No Read 0 DSDREEPX QBSTREE | X | X | X | DSDREEP1 Sequential Prefetch Disabled No Read 1 DSDREEPX QBSTREE | X | X | X | DSDREEP2 Sequential Prefetch Disabled No Read 2 DSDREEPX QBSTREE | X | X | X | DSDREEP3 Sequential Prefetch Disabled No Read 3 DSDREEPX QBSTREE | X | X | X | DSDREL Number of Release Statements Executed DSDREL QXREL | X | X | X | DSDREOP Times Reoptimization Occurs DSDREOP QXSTREOP | X | X | X | DSDREOPN PB Found On Free Q During Open DSDREOPN QTREOPN | X | X | X | DSDREVOK REVOKE Statements DSDREVOK QXREVOK | X | X | X | DSDRFCHD Fetched Rows DB2RFCHD QXRWSFETCHD | X | X | DSDRFXS0 Read Page-Fixed without Real Storage 0 DSDRFXSX QBSTRPI | X | X | X | DSDRFXS1 Read Page-Fixed without Real Storage 1 DSDRFXSX QBSTRPI | X | X | X | DSDRFXS2 Read Page-Fixed without Real Storage 2 DSDRFXSX QBSTRPI | X | X | X | DSDRFXS3 Read Page-Fixed without Real Storage 3 DSDRFXSX QBSTRPI | X | X | X | DSDRHIG Highest # Int BLKS Concur Alloc DSDRHIG QISTRHIG | X | X | X | DSDRLLM RLP Stop: RID Limit Exceeded DSDRLLM QISTRLLM | X | X | X | DSDRMAX RLP STOP: Concur. Proc Lim Exceeded DSDRMAX QISTRMAX | X | X | X | DSDRMID DB2 Resource Manager Identifier DB2RMID QWHSRMID | X | X | X | DSDRNIX Rename Index Statements DB2RNIX QXRNIX | | X | X | DSDRNSTD Inserted Rows DB2RNSTD QXRWSINSRTD | X | X | DSDRNTAB Number of RENAME TABLE Statements DSDRNTAB QXRNTAB | X | X | X | DSDROIDX Direct Row Access Revert to Index DSDROIDX QXROIIDX | X | X | X | DSDROITS Direct Row Access Revert to Table DSDROITS QXROITS | X | X | X | DSDRPLM RLP Stop: DM Limit Exceeded DSDRPLM QISTRPLM | X | X | X | DSDRPOP1 Parallel GPS Reformatted - Sysplex Conf DSDRPOP1 QXREPOP1 | X | X | X | DSDRPOP2 Parallel GPS Reformatted - Buffer Resrc DSDRPOP2 QXREPOP2 | X | X | X | DSDRSTG RLP STOP: Insufficient Storage DSDRSTG QISTRSTG | X | X | X | DSDRUDTD Updated Rows DB2RUDTD QXRWSUPDTD | X | X | DSDRWTRG Times Row Trigger Activated DSDRWTRG QXROWTRG | X | X | X | DSDSABBP Total Active Buffers in Buffer Pool DSDSABBP QBSTCBA | X | X | X | DSDSAC Total CF Writes Clean Pages DSDSAC QBGLAC | X | X | X | DSDSAW Total CF Writes Changed Pages DSDSAW QBGLAW | X | X | X | DSDSAX Total RPL Request Done by Prefetch DSDSAX QBGLAX | X | X | X | DSDSAY Total GBP Reads Prefetch Changed Page DSDSAY QBGLAY | X | X | X | DSDSCC Total IXLCACHE Read-Castout-Class Req DSDSCC QBGLCC | X | X | X | DSDSCIO Total Castout I/O Operations DSDSCIO QBSTCIO | | X | X | DSDSCK Total GBP Checkpoints Triggered DSDSCK QBGLCK | X | X | X | DSDSCM Total Read for Castout Multiple Reqs DSDSCM QBGLCM | X | X | X | DSDSCN Total Castout Engine Not Available DSDSCN QBGLCN | | | | DSDSCR Total Read for Castout Requests DSDSCR QBGLCR | X | X | X | DSDSCS Total IXLCACHE Read-Castout-Stats Req DSDSCS QBGLCS | X | X | X | DSDSCT Total Castout Class Threshold Detected DSDSCT QBGLCT | X | X | X | DSDSDG Total Unregistered Page Requests DSDSDG QBGLDG | X | X | X | DSDSDN Total IXLCACHE Delete-Name Requests DSDSDN QBGLDN | X | X | X | DSDSELCT Number of SELECT Statements DSDSELCT QXSELECT | X | X | X | DSDSETHV No. of SET HOST-VAR Stmts DSDSETHV QXSETHV | X | X | X | DSDSEX Total Explicit XIs DSDSEX QBGLEX | X | X | X | DSDSGG Total GETPAGEs for GBP-Dep Pagesets DSDSGG QBGLGG | X | X | X | DSDSGLO Suspends Due to XES Global Contention DSDSGLO QTGSSGLO | X | X | X | DSDSGT Total Group BP Castout Threshold Det. DSDSGT QBGLGT | X | X | X | DSDSHS Total Asynch IXLCACHE for Prim GBP DSDSHS QBGLHS | X | X | X | DSDSIAC Count of Curr Active Sort In-Mem WFs DSDSIAC QISTSIAC | | | X | DSDSIAH Hi-Watermark Cnt Max Sort In-Mem WFs DSDSIAH QISTSIAH | | | X | DSDSIO0 Sync Read I/Os Seq Access Req BP0 DSDSIOX QBSTSIO | X | X | X | DSDSIO1 Sync Read I/Os Seq Access Req BP1 DSDSIOX QBSTSIO | X | X | X | DSDSIO2 Sync Read I/Os Seq Access Req BP2 DSDSIOX QBSTSIO | X | X | X | DSDSIO3 Sync Read I/Os Seq Access Req BP3 DSDSIOX QBSTSIO | X | X | X | DSDSISC Tot Space Used Curr Active Sort In-Mem DSDSISC QISTSISC | | | X | DSDSISH Hi-Watermark Cnt Max Space Sort In-Mem DSDSISH QISTSISH | | | X | DSDSKIP Parallel Coordination Bypass DB2 DSDSKIP QXXCSKIP | X | X | X | DSDSLWDD DDs Used for Slow Close TS DSDSLWDD QTSLWDD | X | X | X | DSDSMD Total CF Reads Data Returned DSDSMD QBGLMD | X | X | X | DSDSMIAP Times RID List Retrieval Skipped DB2SMIAP QXRSMIAP | | | X | DSDSMN Total CF Reads Data Not Ret. No Entry DSDSMN QBGLMN | | | | DSDSMR Total CF Reads Data Not Returned Entry DSDSMR QBGLMR | X | X | X | DSDSOS Total Other CF Requests DSDSOS QBGLOS | X | X | X | DSDSPCO Total Pages Written for Castout I/Os DSDSPCO QBSTPCO | | X | X | DSDSPDF0 Sequential Prefetch Disabled No Buffer 0 DSDSPDFX QBSTSPD | X | X | X | DSDSPDF1 Sequential Prefetch Disabled No Buffer 1 DSDSPDFX QBSTSPD | X | X | X | DSDSPDF2 Sequential Prefetch Disabled No Buffer 2 DSDSPDFX QBSTSPD | X | X | X | DSDSPDF3 Sequential Prefetch Disabled No Buffer 3 DSDSPDFX QBSTSPD | X | X | X | DSDSPPF0 Number of Pages Read Due to Prefetch 0 DSDSPPFX QBSTSPP | X | X | X | DSDSPPF1 Number of Pages Read Due to Prefetch 1 DSDSPPFX QBSTSPP | X | X | X | DSDSPPF2 Number of Pages Read Due to Prefetch 2 DSDSPPFX QBSTSPP | X | X | X | DSDSPPF3 Number of Pages Read Due to Prefetch 3 DSDSPPFX QBSTSPP | X | X | X | DSDSPWR0 System Pages Written to DASD 0 DSDSPWRX QBSTPWS | X | X | X | DSDSPWR1 System Pages Written to DASD 1 DSDSPWRX QBSTPWS | X | X | X | DSDSPWR2 System Pages Written to DASD 2 DSDSPWRX QBSTPWS | X | X | X | DSDSPWR3 System Pages Written to DASD 3 DSDSPWRX QBSTPWS | X | X | X | DSDSQCA Storage Allocated for Plans (>2GB) Bar DSDSQCA QISESQCA | | | X | DSDSQCB Storage Allocated for Plans (<2GB) Bar DSDSQCB QISESQCB | | | X | DSDSQKA Storage Allocated for Pkgs (>2GB) Bar DSDSQKA QISESQKA | | | X | DSDSQKB Storage Allocated for Pkgs (<2GB) Bar DSDSQKB QISESQKB | | | X | DSDSQLID No. Of Set Current SQLID DSDSQLID QXSETSQL | X | X | X | DSDSQPF0 Number of Sequential Prefetch Requests DSDSQPFX QBSTSEQ | X | X | X | DSDSRB Total GBP Rebuilds DSDSRB QBGLRB | X | X | X | DSDSRC Total Pages Castout to DASD DSDSRC QBGLRC | X | X | X | DSDSRD Total IXLCACHE Read-DIRINFO Requests DSDSRD QBGLRD | X | X | X | DSDSRF Total CF Read Requests No Storage DSDSRF QBGLRF | | | | DSDSRG Total Registered Page Requests DSDSRG QBGLRG | X | X | X | DSDSSEF0 Storage Shortage Expansion Fails 0 DSDSSEFX QBSTXFV | X | X | X | DSDSSEF1 Storage Shortage Expansion Fails 1 DSDSSEFX QBSTXFV | X | X | X | DSDSSEF2 Storage Shortage Expansion Fails 2 DSDSSEFX QBSTXFV | X | X | X | DSDSSEF3 Storage Shortage Expansion Fails 3 DSDSSEFX QBSTXFV | X | X | X | DSDSSU Total CF Write Engine Not Available DSDSSU QBGLSU | | | | DSDSSW Total CF Writes For Changed Pages DSDSSW QBGLSW | X | X | X | DSDSTAC Sync to Async Heuristic Convs LOCK Reqs DSDSTAC QTGSFLSE | X | X | X | DSDSTCDG Number of Set Current Degree DSDSTCDG QXSETCDG | X | X | X | DSDSTCON Number of Set Connection Statements DSDSTCON QXSETCON | X | X | X | DSDSTCPR Set Current Precision Stmts Executed DSDSTCPR QXSETCPR | X | X | X | DSDSTCRL Set Current Rules Stmts Executed DSDSTCRL QXSETCRL | X | X | X | DSDSTPT Set Current Path Statements DSDSTPT QXSETPTH | X | X | X | DSDSTTRG Times Statement Trigger Activated DSDSTTRG QXSTTRG | X | X | X | DSDSUN Total IXLCACHE Unlock-Castout Req DSDSUN QBGLUN | X | X | X | DSDSWC Total CF Writes For Clean Pages DSDSWC QBGLWC | X | X | X | DSDSWF Total CF Write Requests No Storage DSDSWF QBGLWF | X | X | X | DSDSWM Total Write and Register Multiple Reqs DSDSWM QBGLWM | X | X | X | DSDSWP Total Pages Written via WARM DSDSWP QBGLWP | X | X | X | DSDSWREE Total Times Write Engine Unavailable DSDSWREE QBSTWEE | X | | X | DSDSWS Total Write and Register Requests DSDSWS QBGLWS | X | X | X | DSDSXD Total CF Reads Buffer XI DSDSXD QBGLXD | X | X | X | DSDSXR Total CF Reads Entry Created DSDSXR QBGLXR | X | X | X | DSDS2D Total IXLCACHE Delete-Name-List 2nd GBP DSDS2D QBGL2D | X | X | X | DSDS2F Total Write Chg Pgs to 2nd GBP Fail Stg DSDS2F QBGL2F | X | X | X | DSDS2H Total Asynch IXLCACHE for 2nd GBP DSDS2H QBGL2H | X | X | X | DSDS2N Total IXLCACHE Delete-Name 2nd GBP DSDS2N QBGL2N | X | X | X | DSDS2R Total IXLCACHE Read-Castout-St 2nd GBP DSDS2R QBGL2R | X | X | X | DSDS2S Total Comp Write 2nd GBP Suspended DSDS2S QBGL2S | X | X | X | DSDTESTB Binds Without Plan ID DSDTESTB QTTESTB | X | X | X | DSDTGERR Number of Create Aux Table Statements DSDTGERR QXTRGERR | X | X | X | DSDTIMO Time-out Count DSDTIMO QTXATIM | X | X | X | DSDTMIG0 No. Migrated Dataset Encountered BP 0 DSDTMIGX QBSTMIG | X | X | X | DSDTMIG1 No. Migrated Dataset Encountered BP 1 DSDTMIGX QBSTMIG | X | X | X | DSDTMIG2 No. Migrated Dataset Encountered BP 2 DSDTMIGX QBSTMIG | X | X | X | DSDTMIG3 No. Migrated Dataset Encountered BP 3 DSDTMIGX QBSTMIG | X | X | X | DSDTOGRP Total Number of Parallel Groups DSDTOGRP QXTOTGRP | X | X | X | DSDTPF00 WK PF Abort - 0 PF QTY 0 DSDTPF0X QBSTWKPD | X | X | X | DSDTPF01 WK PF Abort - 0 PF QTY 1 DSDTPF0X QBSTWKPD | X | X | X | DSDTPF02 WK PF Abort - 0 PF QTY 2 DSDTPF0X QBSTWKPD | X | X | X | DSDTPF03 WK PF Abort - 0 PF QTY 3 DSDTPF0X QBSTWKPD | X | X | X | DSDTPIO0 No. Prefetch Async Read I/Os 0 DSDTPIOX QBSTPIO | X | X | X | DSDTPIO1 No. Prefetch Async Read I/Os 1 DSDTPIOX QBSTPIO | X | X | X | DSDTPIO2 No. Prefetch Async Read I/Os 2 DSDTPIOX QBSTPIO | X | X | X | DSDTPIO3 No. Prefetch Async Read I/Os 2 DSDTPIOX QBSTPIO | X | X | X | DSDTRTBL Truncate Table Statements DB2TRTBL QXTRTBL | | X | X | DSDTRTO0 No. Recall Time Outs 0 DB2TRTOX QBSTRTO | X | X | X | DSDTRTO1 No. Recall Time Outs 1 DB2TRTOX QBSTRTO | X | X | X | DSDTRTO2 No. Recall Time Outs 2 DB2TRTOX QBSTRTO | X | X | X | DSDTRTO3 No. Recall Time Outs 3 DB2TRTOX QBSTRTO | X | X | X | DSDUPDTE UPDATE Statements DSDUPDTE QXUPDTE | X | X | X | DSDUPLK Unlock Requests for Physical Locks DSDUPLK QTGSUPLK | X | X | X | DSDUSLM Unlock Requests Propagated to XES DSDUSLM QTGSUSLM | X | X | X | DSDUSUC Checks Actually Authorized DSDUSUC QTAUSUC | X | X | X | DSDVPA0 Successful VPOOL Expand/Contract BP0 DSDVPAX QBSTVPA | X | X | X | DSDVPA1 Successful VPOOL Expand/Contract BP1 DSDVPAX QBSTVPA | X | X | X | DSDVPA2 Successful VPOOL Expand/Contract BP2 DSDVPAX QBSTVPA | X | X | X | DSDVPA3 Successful VPOOL Expand/Contract BP3 DSDVPAX QBSTVPA | X | X | X | DSDVPL0 No. Buffers Allocated for a VPOOL BP0 DSDVPLX QBSTVPL | X | X | X | DSDVPL1 No. Buffers Allocated for a VPOOL BP1 DSDVPLX QBSTVPL | X | X | X | DSDVPL2 No. Buffers Allocated for a VPOOL BP2 DSDVPLX QBSTVPL | X | X | X | DSDVPL3 No. Buffers Allocated for a VPOOL BP3 DSDVPLX QBSTVPL | X | X | X | DSDW4K Cur 4KB Tablespace Storage Used KB DSDW4K QISTW4K | | X | X | DSDW32K Curr 32KB Tablespace Storage Used KB DSDW32K QISTW32K | | X | X | DSDWBVQ0 Pages Deq VDWQ Destr Read Rq 0 DSDWBVQX QBSTWBVQ | X | X | X | DSDWBVQ1 Pages Deq VDWQ Destr Read Rq 1 DSDWBVQX QBSTWBVQ | X | X | X | DSDWBVQ2 Pages Deq VDWQ Destr Read Rq 2 DSDWBVQX QBSTWBVQ | X | X | X | DSDWBVQ3 Pages Deq VDWQ Destr Read Rq 3 DSDWBVQX QBSTWBVQ | X | X | X | DSDWCTO Curr Total Workfile Storage Used KB DSDWCTO QISTWCTO | | X | X | DSDWDRP0 Pages Destruct Read Req 0 DSDWDRPX QBSTWDRP | X | X | X | DSDWDRP1 Pages Destruct Read Req 1 DSDWDRPX QBSTWDRP | X | X | X | DSDWDRP2 Pages Destruct Read Req 2 DSDWDRPX QBSTWDRP | X | X | X | DSDWDRP3 Pages Destruct Read Req 3 DSDWDRPX QBSTWDRP | X | X | X | DSDWFD0 Work Files Denied Sort Merge 0 DSDWFDX QBSTWFD | X | X | X | DSDWFD1 Work Files Denied Sort Merge 1 DSDWFDX QBSTWFD | X | X | X | DSDWFD2 Work Files Denied Sort Merge 2 DSDWFDX QBSTWFD | X | X | X | DSDWFD3 Work Files Denied Sort Merge 3 DSDWFDX QBSTWFD | X | X | X | DSDWFF0 Poor Sort Merge - Buf Short 0 DSDWFFX QBSTWFF | X | X | X | DSDWFF1 Poor Sort Merge - Buf Short 1 DSDWFFX QBSTWFF | X | X | X | DSDWFF2 Poor Sort Merge - Buf Short 2 DSDWFFX QBSTWFF | X | X | X | DSDWFF3 Poor Sort Merge - Buf Short 3 DSDWFFX QBSTWFF | X | X | X | DSDWFM0 Max WK File Alloc Sort Merge 0 DSDWFMX QBSTWFM | X | X | X | DSDWFM1 Max WK File Alloc Sort Merge 1 DSDWFMX QBSTWFM | X | X | X | DSDWFM2 Max WK File Alloc Sort Merge 2 DSDWFMX QBSTWFM | X | X | X | DSDWFM3 Max WK File Alloc Sort Merge 3 DSDWFMX QBSTWFM | X | X | X | DSDWFMU Max Total Workfile Storage Ever Used KB DSDWFMU QISTWFMU | | X | X | DSDWFNE Times Max Allow Storage Limit Exceeded DSDWFNE QISTWFNE | | X | X | DSDWFP1 Times 32KB Page TS Used Instead of 4KB DSDWFP1 QISTWFP1 | | X | X | DSDWFP2 Times 4KB Page TS Used Instead of 32KB DSDWFP2 QISTWFP2 | | X | X | DSDWFR0 Req Query WK File Sort Merge 0 DSDWFRX QBSTWFR | X | X | X | DSDWFR1 Req Query WK File Sort Merge 1 DSDWFRX QBSTWFR | X | X | X | DSDWFR2 Req Query WK File Sort Merge 2 DSDWFRX QBSTWFR | X | X | X | DSDWFR3 Req Query WK File Sort Merge 3 DSDWFRX QBSTWFR | X | X | X | DSDWFRCU Curr RID Blocks Residing in Workfile DSDWFRCU QISTWFRCUR | | | X | DSDWFRHG Max RID Blocks Stored to Workfile DSDWFRHG QISTWFRHIG | | | X | DSDWFT0 Work Files Req Sort Merge 0 DSDWFTX QBSTWFT | X | X | X | DSDWFT1 Work Files Req Sort Merge 1 DSDWFTX QBSTWFT | X | X | X | DSDWFT2 Work Files Req Sort Merge 2 DSDWFTX QBSTWFT | X | X | X | DSDWFT3 Work Files Req Sort Merge 3 DSDWFTX QBSTWFT | X | X | X | DSDWFXS0 Write Page Fixed W/O Real Storage 0 DSDWFXSX QBSTWPI | X | X | X | DSDWFXS1 Write Page Fixed W/O Real Storage 1 DSDWFXSX QBSTWPI | X | X | X | DSDWFXS2 Write Page Fixed W/O Real Storage 2 DSDWFXSX QBSTWPI | X | X | X | DSDWFXS3 Write Page Fixed W/O Real Storage 3 DSDWFXSX QBSTWPI | X | X | X | DSDWREE0 No. Times Write Engine Unavailable 0 DSDWREEX QBSTWEE | X | | | DSDWREE1 No. Times Write Engine Unavailable 1 DSDWREEX QBSTWEE | X | | | DSDWREE2 No. Times Write Engine Unavailable 2 DSDWREEX QBSTWEE | X | | | DSDWREE3 No. Times Write Engine Unavailable 3 DSDWREEX QBSTWEE | X | | | DSDWRMM0 Write I/Os By Media Manager 0 DSDWRMMX QBSTWIO | X | X | X | DSDWRMM1 Write I/Os By Media Manager 1 DSDWRMMX QBSTWIO | X | X | X | DSDWRMM2 Write I/Os By Media Manager 2 DSDWRMMX QBSTWIO | X | X | X | DSDWRMM3 Write I/Os By Media Manager 3 DSDWRMMX QBSTWIO | X | X | X | DSDXFL0 Buffer Not Located -- VPOOL Full BP0 DSDXFLX QBSTXFL | X | X | X | DSDXFL1 Buffer Not Located -- VPOOL Full BP1 DSDXFLX QBSTXFL | X | X | X | DSDXFL2 Buffer Not Located -- VPOOL Full BP2 DSDXFLX QBSTXFL | X | X | X | DSDXFL3 Buffer Not Located -- VPOOL Full BP3 DSDXFLX QBSTXFL | X | X | X | DSDXIS0 Max No. Concurrent Pref. Streams BP0 DSDXISX QBSTXIS | X | X | X | DSDXIS1 Max No. Concurrent Pref. Streams BP1 DSDXISX QBSTXIS | X | X | X | DSDXIS2 Max No. Concurrent Pref. Streams BP2 DSDXISX QBSTXIS | X | X | X | DSDXIS3 Max No. Concurrent Pref. Streams BP3 DSDXISX QBSTXIS | X | X | X | DSDZRLMT No. Zero Resource Limit DSDZRLMT QTXAFLG1 | | | X | ----------------------------------------------------------------------------------------------------------------------------------
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |