5. FILES › 5.3 DB2 Data Base Activity (DB2DSD) File › 5.3.2 Data Element List
5.3.2 Data Element List
The table below identifies data elements contained in this
file. The entries for each data element are as follows:
TIMESPAN: Defines the timespans in which the data element
is supported. A "." indicates that the data
element is not supported. The timespans in
which the data element is supported are indicated
by the letters "XDWMYT," which represent the
timespans as follows:
X - DETAIL
D - DAYS
W - WEEKS
M - MONTHS
Y - YEARS
T - TABLES AREA
DATA ELEMENT: The data element name.
DATA ELEMENT DESCRIPTION: The long name of the data element.
Note: The timespans in which a data element is supported are
defined by each site when CA MICS is installed. Therefore,
this table has been generated as part of the installation
process to reflect the CA MICS system at your site.
Note: Essential data elements are identified by an "E"
under the Timespan asterisk (*) column.
Time- Data Data Element
Span * Element Description (LABEL)
------- -------- ----------------------------------------
Sequence/Summary Data Elements
XD....E DAY - Day of Month
XDWMY.E DB2ID - DB2 ID
XDW...E HOUR - Hour of Day
XDWM..E MONTH - Month of Year
XDWMY.E SYSID - System Identifier
XDW...E WEEK - Week of Year
XDWMY.E YEAR - Year of Century
XDWMY.E ZONE - Time Zone
Common Data Elements
XD....E DAYNAME - Name of Day of Week
XDWMY.E DB2ISEQ - Instrumentation Sequence Number
X.....E DB2MLVL - MICS DB2 Maintenance Level
XDWMY.E DB2REL - DB2 Release
XDWMY.E DB2RELN - DB2 Release Number
XDWMY.E DURATION - Recording Interval Time
XDWMY.E ENDTS - End Time Stamp
XDWMY.E STARTTS - Start Time Stamp
Retained Data Elements
XDWMY.E DSDAFLG - Flag Byte
XDWMY.E DSDARLID - Resource Limit Table ID
X..... DSDATNM - Active Trace Number Mask
X.....E DSDDSTSN - Destination Sequence Number
X.....E DSDISEQ - Instrumentation Sequence Number
XDWMY. DSDRMID - DB2 Resource Manager Identifier
Accumulated Data Elements
XDWMY.E DSDABBP0 - Active Buffers In Buffer Pool 0
XDWMY.E DSDABBP1 - Active Buffers In Buffer Pool 1
XDWMY.E DSDABBP2 - Active Buffers In Buffer Pool 2
XDWMY.E DSDABBP3 - Active Buffers In Buffer Pool 3
XDWMY.E DSDACHG - Change Request Count
XDWMY.E DSDACHUS - Highest CPU 16 Microseconds Used
XDWMY.E DSDACLMT - Limit In CPU 16 Microseconds
XDWMY.E DSDAIRLM - Other IRLM Request Count
XDWMY.E DSDALDAB - NO. of ALTER DATABASE Stmts
XDWMY.E DSDALLOC - Successful Bound Plan Allocation
XDWMY.E DSDALOCA - Requests To Allocate Bound Plan
XDWMY.E DSDALOCK - Lock Request Count
XDWMY.E DSDALSEQ - Alter Sequence Statements
XDWMY.E DSDALTIX - Alter Index Statements
XDWMY.E DSDALTJR - Alter JAR Statements
XDWMY.E DSDALTST - Alter Stogroup Statements
XDWMY.E DSDALTTA - Alter Table Statements
XDWMY.E DSDALTTS - Alter Tablespace Statements
XDWMY.E DSDALTTX - Alter Trusted Context Statements
XDWMY.E DSDALTVW - Alter View Statements
XDWMY.E DSDAQRY - Query Request Count
XDWMY.E DSDASLAT - Suspend Count - Latch Conflict
XDWMY.E DSDASLMT - Limit In SUs - ASUTIME
XDWMY.E DSDASOTH - Suspend Count - Other Conflict
XDWMY. DSDAUCC - AUTH Checks Using Cache
XDWMY.E DSDAUCHK - Authorization Checks
XDWMY.E DSDAUNLK - Unlock Request Count
XDWMY. DSDAUPUB - AUTH Checks Based PUBLIC Auth
XDWMY.E DSDAUTOB - Attempts To AUTOBIND a Pkg
XDWMY.E DSDBIND - Successful Automatic Binds
XDWMY.E DSDBINDA - Automatic Bind Attempts
XDWMY.E DSDBNDAA - Bind Action Add Subcommands
XDWMY.E DSDBNDAR - Bind Action Replace Subcommands
XDWMY.E DSDBNDPA - BIND (ADD) PACKAGE Sub-Cmnds
XDWMY.E DSDBNDPR - BIND (REP) PACKAGE Sub-Cmnds
XDWMY.E DSDBPSO0 - Buffer Pool Data Set Opened 0
XDWMY.E DSDBPSO1 - Buffer Pool Data Set Opened 1
XDWMY.E DSDBPSO2 - Buffer Pool Data Set Opened 2
XDWMY.E DSDBPSO3 - Buffer Pool Data Set Opened 3
XDWMY.E DSDCLOSE - Close Statements
XDWMY.E DSDCMTON - Comment On Statements
XD....E DSDCOLS - Invalid Select Procedure Encountered
XDWMY.E DSDCOST - Processing Cost
XDWMY.E DSDCRAL - CREATE ALIAS
XDWMY.E DSDCRCTX - Create Trusted Context Statements
XDWMY.E DSDCRDAB - Create Database Statements
XDWMY.E DSDCRINX - Create Index Statements
XDWMY.E DSDCRROL - Create Role Statements
XDWMY.E DSDCRSEQ - Create Sequence Statements
XDWMY.E DSDCRSTG - Create Stogroup Statements
XDWMY.E DSDCRSYN - Create Synonym Statements
XDWMY.E DSDCRTAB - Create Table Statements
XDWMY.E DSDCTABS - Create Tablespace Statements
XDWMY.E DSDCWLD - Times Duplicate Concentrate Dyna Stmnts
XDWMY.E DSDCWLM - Times Matched Concentrate Dyna Stmnts
XDWMY.E DSDCWLP - Times Parsed Concentrate Dyna Stmnts
XDWMY.E DSDCWLR - Times Replaced Concentrate Dyna Stmnts
XDWMY.E DSDDBDG - Requests for Database Descriptors
XDWMY.E DSDDBDL - Number of Loads of Database Descriptors
XDWMY.E DSDDBPR0 - Physical Data Base Page Requests 0
XDWMY.E DSDDBPR1 - Physical Data Base Page Requests 1
XDWMY.E DSDDBPR2 - Physical Data Base Page Requests 2
XDWMY.E DSDDBPR3 - Physical Data Base Page Requests 3
XDWMY.E DSDDBPU0 - Data Base Page Updates 0
XDWMY.E DSDDBPU1 - Data Base Page Updates 1
XDWMY.E DSDDBPU2 - Data Base Page Updates 2
XDWMY.E DSDDBPU3 - Data Base Page Updates 3
XDWMY.E DSDDEAD - Deadlock Count
XDWMY.E DSDDEFVU - Create View Statements
XDWMY.E DSDDELET - Delete Statements
XDWMY.E DSDDESC - Describe Statements
XDWMY.E DSDDEXP - PREPARE Discarded
XDWMY.E DSDDINV - PREPARE Purged
XDWMY. DSDDLRU - Number of Stealable DB Descriptors
XDWMY.E DSDDMCT0 - No. Times DM Critical WPHFWT reached 0
XDWMY.E DSDDMCT1 - No. Times DM Critical WPHFWT Reached 1
XDWMY.E DSDDMCT2 - No. Times DM Critical WPHFWT Reached 2
XDWMY.E DSDDMCT3 - No. Times DM Critical WPHFWT Reached 3
XDWMY.E DSDDRAL - DROP ALIAS
XDWMY.E DSDDRPDB - Drop Database Statements
XDWMY.E DSDDRPIX - Drop Index Statements
XDWMY.E DSDDRPKG - NO. of DROP PACKAGE Stmts
XDWMY.E DSDDRPRO - Drop Role Statements
XDWMY.E DSDDRPST - Drop Stogroup Statements
XDWMY.E DSDDRPSY - Drop Synonym Statements
XDWMY.E DSDDRPTA - Drop Table Statements
XDWMY.E DSDDRPTS - Drop Tablespace Statements
XDWMY.E DSDDRPTX - Drop Trusted Context Statements
XDWMY.E DSDDRPVU - Drop View Statements
XDWMY.E DSDDRSEQ - Drop Sequence Statements
XDWMY.E DSDDSCRT - NO. of DESCRIBE TABLE Stmts
XDWMY.E DSDDSDRN - DDs That Drain Has Produced
XDWMY.E DSDDSOPN - Data Sets Currently Open
XDWMY.E DSDDSPBD - Plans Bound And Kept
XDWMY.E DSDDWRT0 - No. Times Deferred Write Threshold 0
XDWMY.E DSDDWRT1 - No. Times Deferred Write Threshold 1
XDWMY.E DSDDWRT2 - No. Times Deferred Write Threshold 2
XDWMY.E DSDDWRT3 - No. Times Deferred Write Threshold 3
XDWMY. DSDECFAL - No. of Failures: Full Statement Pool
XDWMY. DSDECFRE - No. of Free Pages in Statement Pool
XDWMY. DSDECPGE - No. of Pages in Statement Pool
XDWMY. DSDECTA - Pages Used for Cursor Tables Above 2GB
XDWMY.E DSDECTG - NO. Requests for Cursor Table Section
XDWMY.E DSDECTL - NO. Loaded Cursor Table Sections
XDWMY.E DSDECTU - Pages Used for Cursor Tables Below 2GB
XDWMY.E DSDEDBD - Number of Pages used for DBD
XDWMY.E DSDEDSC - Number of Pages used for Cache
XDWMY.E DSDEDSG - Number of Requests for Dynamic Cache
XDWMY.E DSDEDSI - Number of Inserts for Dynamic Cache
XDWMY. DSDEDYNP - No. of Pages Used in Statement Pool
XDWMY.E DSDEFAL - Number of Failures Due to Full EDM Pool
XDWMY. DSDEKFAL - No. of Failures: Full Skeleton Pool
XDWMY. DSDEKFRE - No. of Free Pages in Skeleton Pool
XDWMY. DSDEKNFA - NOT FOUND Records Added to EDM Cache
XDWMY. DSDEKNFM - NOT FOUND Records in EDM Cache
XDWMY. DSDEKNFR - NOT FOUND Recs. Removed from EDM Cache
XDWMY. DSDEKPGE - No. of Pages in Skeleton Pool
XDWMY. DSDEPTA - Pages Used for Package Tables Above 2GB
XDWMY.E DSDEPTG - No. Req for Package Table Sections
XDWMY.E DSDEPTL - No. Loaded Package Table Sections
XDWMY. DSDEPTU - Pages Used for Package Tables Below 2GB
XDWMY. DSDESFAL - No. of Failures: Full Stmt (>2GB) Pool
XDWMY. DSDESFRE - No. of Free Pages in Stmt (>2GB) Pool
XDWMY.E DSDESKC - No. Free Pages Used for SKCT Table
XDWMY.E DSDESKP - No. Free Pages Used for SKPT Table
XDWMY. DSDESPGE - No. of Pages in Statement (>2GB) Pool
XDWMY. DSDESTMT - Number of Statements in EDM Pool
XDWMY.E DSDFETCH - Fetch Statements
XDWMY.E DSDFLSE - No. of False Contentions
XDWMY.E DSDFND - PREPARE Request Satisfied
XDWMY.E DSDFREAP - Attempts To FREE a Package
XDWMY.E DSDFREE - Free Subcommands
XDWMY.E DSDFREEA - Attempts To Free Plan
XDWMY.E DSDFREEP - Plan Successfully Freed
XDWMY.E DSDFREPK - FREE PACKAGE Sub-Cmnds
XDWMY.E DSDFRIDS - Times RID List Overflowed RID Storage
XDWMY.E DSDFRIDT - Times RID List Overflowed RID Exceeded
XDWMY.E DSDFRPG - Number of Free Pages in Free Chain
XDWMY.E DSDGRANT - Grant Statements
XDWMY.E DSDIMWS0 - Count of Immediate Writes Sys Pages 0
XDWMY.E DSDIMWS1 - Count of Immediate Writes Sys Pages 1
XDWMY.E DSDIMWS2 - Count of Immediate Writes Sys Pages 2
XDWMY.E DSDIMWS3 - Count of Immediate Writes Sys Pages 3
XDWMY.E DSDINCRB - Incremental Binds
XDWMY.E DSDINSRT - Insert Statements
XDWMY.E DSDIPRP - Implicit PREPARE Performed
XDWMY.E DSDJINCS - Times RID List Append RID Storage
XDWMY.E DSDJINCT - Times RID List Append RID Exceeded
XDWMY. DSDKLRU - Number of Stealable Skeleton Pkg Table
XDWMY. DSDKSPA - Number of Pages Alloc for Exec Procs
XDWMY.E DSDLABEL - Label Statements
XDWMY.E DSDLEEM - Count of Escalations to Exclusive Mode
XDWMY.E DSDLESM - Count of Escalations to Shared Mode
XDWMY.E DSDLOCK - Lock Table Statements
XDWMY.E DSDLPF0 - No. List Prefetch Requested BP0
XDWMY.E DSDLPF1 - No. List Prefetch Requested BP1
XDWMY.E DSDLPF2 - No. List Prefetch Requested BP2
XDWMY.E DSDLPF3 - No. List Prefetch Requested BP3
XDWMY. DSDMAX0 - BP Not Supp Concur WK File 0
XDWMY. DSDMAX1 - BP Not Supp Concur WK File 1
XDWMY. DSDMAX2 - BP Not Supp Concur WK File 2
XDWMY. DSDMAX3 - BP Not Supp Concur WK File 3
XDWMY.E DSDMERGE - Merge Statements
XDWMY. DSDMIXNL - Mult INDX Not Used - RID Limit
XDWMY. DSDMIXNU - Mult INDX Not Used - No Storage
XDWMY. DSDMIXU - Multiple Index Path Used
XDWMY.E DSDMMRR0 - Media Manager Read Requests 0
XDWMY.E DSDMMRR1 - Media Manager Read Requests 1
XDWMY.E DSDMMRR2 - Media Manager Read Requests 2
XDWMY.E DSDMMRR3 - Media Manager Read Requests 3
XDWMY.E DSDMXCUR - Max PB Count On Free PB
XDWMY.E DSDMXPL - Max. no. of Page locks held
XDWMY.E DSDNFND - PREPARE Request - No Match
XDWMY.E DSDNPRP - PREPARE Avoided
XDWMY.E DSDNREC - Count of Type 100 Subtype 1 Recs
XDWMY.E DSDNVRID - Allocate Requests Nonexist Plan
XDWMY.E DSDOPEN - Open Statements
XDWMY.E DSDPAGE - No. Pages in EDM Pool
XDWMY.E DSDPKABN - Packages Autobound
XDWMY.E DSDPKALC - Attempts To Allocate a Pkg
XDWMY.E DSDPKALL - Packages Allocated
XDWMY.E DSDPKGBD - Packages Bound
XDWMY.E DSDPKGFR - Packages Freed
XDWMY.E DSDPKGRB - Packages Rebound
XDWMY.E DSDPREP - Prepare Statements
XDWMY.E DSDPREPI - Prepare Statements Restricted
XDWMY.E DSDQUERY - Fetch and Select Statements
XDWMY.E DSDRBND - Successful Rebind Plan
XDWMY.E DSDRBNDA - Rebind Plan Attempts
XDWMY.E DSDRBNDP - REBIND PACKAGE Sub-Cmnds
XDWMY.E DSDRBNPA - Attempts To REBIND a Package
XDWMY. DSDRCUR - Int BLKS Currently Alloc
XDWMY.E DSDRDLTD - Deleted Rows
XDWMY.E DSDREBND - Rebind Subcommands
XDWMY.E DSDREEP0 - Prefetch Request Disabled no Read 0
XDWMY.E DSDREEP1 - Prefetch Request Disabled no Read 1
XDWMY.E DSDREEP2 - Prefetch Request Disabled no Read 2
XDWMY.E DSDREEP3 - Prefetch Request Disabled no Read 3
XDWMY.E DSDREOPN - PB Found On Free Q During Open
XDWMY.E DSDREVOK - Revoke Statements
XDWMY.E DSDRFCHD - Fetched Rows
XDWMY.E DSDRFXS0 - Read Pagefixed W/O Real Storage 0
XDWMY.E DSDRFXS1 - Read Pagefixed W/O Real Storage 1
XDWMY.E DSDRFXS2 - Read Pagefixed W/O Real Storage 2
XDWMY.E DSDRFXS3 - Read Pagefixed W/O Real Storage 3
XDWMY. DSDRHIG - Highest # Int BLKS Concur Alloc
XDWMY. DSDRLLM - RLP Stop: RID Limit Exceeded
XDWMY.E DSDRMAX - RLP Stop: Concur. Proc Lim Exceeded
XDWMY. DSDRNIX - Rename Index Statements
XDWMY.E DSDRNSTD - Inserted Rows
XDWMY. DSDRPLM - RLP Stop: DM Limit Exceeded
XDWMY.E DSDRSTG - RLP Stop: Insufficient Storage
XDWMY.E DSDRUDTD - Updated Rows
XDWMY.E DSDSABBP - Total Active Buffers in Buffer Pools
XDWMY.E DSDSARA - Total Pages Moved HPOOL to VPOOL ADMF
XDWMY.E DSDSARF - Total Pages Not Moved via ADMF
XDWMY.E DSDSAWA - Total Pages Moved VPOOL to HPOOL ADMF
XDWMY.E DSDSAWF - Total Pages for Write Not Moved ADMF
XDWMY.E DSDSBPSO - Total Buffer Pool Data Sets Opened
XDWMY. DSDSCIO - Total Castout I/O Operations
XDWMY.E DSDSDBPR - Total Physical Data Base Page Requests
XDWMY.E DSDSDBPU - Total Data Base Page Updates
XDWMY.E DSDSDIO - Total Async Read I/Os Dynamic Prefetch
XDWMY.E DSDSDMCT - Total Times WPHFWT Threshold Reached
XDWMY.E DSDSDPF - Total Times Dynamic Prefetch Requested
XDWMY.E DSDSDPP - Total Async Page Reads Dynamic Prefetch
XDWMY.E DSDSDWRT - Total Times Deferred Write Threshold
XDWMY.E DSDSDWV - Total Times Vert. Defer Write Thresh
XDWMY.E DSDSELCT - Select Statements
XDWMY.E DSDSETHV - NO. of SET HOST-VAR Stmts
XDWMY.E DSDSHBE - Total HPOOL Buffers Backed Exp Storage
XDWMY.E DSDSHPA - Total Successful HPOOL Expand/Contract
XDWMY.E DSDSHPL - Total Buffers Allocated for HPOOL
XDWMY.E DSDSHRA - Total Pages Moved Async HPOOL to VPOOL
XDWMY.E DSDSHRE - Total Success Sync Req HPOOL to VPOOL
XDWMY.E DSDSHRF - Total Pages Read Failed Page Stolen
XDWMY.E DSDSHWA - Total Pages Moved Async VPOOL to HPOOL
XDWMY.E DSDSHWF - Total Pages Write Failed Exp Stg Short
XDWMY.E DSDSHWR - Total Request Move Sync VPOOL to HPOOL
XDWMY.E DSDSIMWS - Total Immediate Writes System Pages
XDWMY.E DSDSIO0 - Sync Read I/Os Seq Access Req BP0
XDWMY.E DSDSIO1 - Sync Read I/Os Seq Access Req BP1
XDWMY.E DSDSIO2 - Sync Read I/Os Seq Access Req BP2
XDWMY.E DSDSIO3 - Sync Read I/Os Seq Access Req BP3
XDWMY.E DSDSJIS - Total Req. Prefetch I/O Streams Denied
XDWMY.E DSDSLIO - Total Async Read I/Os List Prefetch
XDWMY.E DSDSLPF - Total List Prefetch Requested
XDWMY.E DSDSLPP - Total Async Page Reads List Prefetch
XDWMY.E DSDSLWDD - DDs Used for Slow Close TS
XDWMY.E DSDSMAX - Total BP Not Supp Concur WK File
XDWMY.E DSDSMIAP - Times RID List Retrieval Skipped
XDWMY.E DSDSMMRR - Total Media Manager Read Requests
XDWMY.E DSDSMRPR - Total Media Mgr Read Req Phys Req Buf
XDWMY.E DSDSNGT - Total Times Cond GETPAGE Not Satisfied
XDWMY. DSDSPCO - Total Pages Written for Castout I/Os
XDWMY.E DSDSPDF0 - Prefetch Request Disabled no Buffer 0
XDWMY.E DSDSPDF1 - Prefetch Request Disabled no Buffer 1
XDWMY.E DSDSPDF2 - Prefetch Request Disabled no Buffer 2
XDWMY.E DSDSPDF3 - Prefetch Request Disabled no Buffer 3
XDWMY.E DSDSPL1 - Total Times Pref Quantity 1/2 Normal
XDWMY.E DSDSPL2 - Total Times Pref Quantity 1/4 Normal
XDWMY.E DSDSPPF0 - Count Records Read Prefetch Requests 0
XDWMY.E DSDSPPF1 - Count Records Read Prefetch Requests 1
XDWMY.E DSDSPPF2 - Count Records Read Prefetch Requests 2
XDWMY.E DSDSPPF3 - Count Records Read Prefetch Requests 3
XDWMY.E DSDSPQF - Total Times Parallel Buffer Not Alloc
XDWMY.E DSDSPQO - Total Req. Process Queries in Parallel
XDWMY.E DSDSPWPU - Total Page Write per Page Updt Buffer
XDWMY.E DSDSPWR0 - System Pages Written To DASD 0
XDWMY.E DSDSPWR1 - System Pages Written To DASD 1
XDWMY.E DSDSPWR2 - System Pages Written To DASD 2
XDWMY.E DSDSPWR3 - System Pages Written To DASD 3
XDWMY. DSDSQCA - Storage Allocated for Plans (>2GB) Bar
XDWMY. DSDSQCB - Storage Allocated for Plans (<2GB) Bar
XDWMY. DSDSQKA - Storage Allocated for Pkgs (>2GB) Bar
XDWMY. DSDSQKB - Storage Allocated for Pkgs (<2GB) Bar
XDWMY.E DSDSQLID - SET Current SQLID Request Count
XDWMY.E DSDSQPF0 - Count Sequential Prefetch requests 0
XDWMY.E DSDSQPF1 - Count Sequential Prefetch requests 1
XDWMY.E DSDSQPF2 - Count Sequential Prefetch requests 2
XDWMY.E DSDSQPF3 - Count Sequential Prefetch requests 3
XDWMY.E DSDSREEP - Total Prefetch Disabled No Read Engine
XDWMY.E DSDSRFRI - Total Read Frames per Read Req Buffer
XDWMY.E DSDSRFXS - Total Read Pagefixed W/O Real Storage
XDWMY.E DSDSSEF0 - Storage Shortage Expansion Fails 0
XDWMY.E DSDSSEF1 - Storage Shortage Expansion Fails 1
XDWMY.E DSDSSEF2 - Storage Shortage Expansion Fails 2
XDWMY.E DSDSSEF3 - Storage Shortage Expansion Fails 3
XDWMY.E DSDSSGT - Total GETPAGE Requests Seq Access Req
XDWMY.E DSDSSIO - Total Sync Read I/Os Seq Access Req
XDWMY.E DSDSSPDF - Total Seq. Prefetch Disabled No Buffer
XDWMY.E DSDSSPPF - Total Records Read Prefetch Request
XDWMY.E DSDSSPWR - Total System Pages Written to DASD
XDWMY.E DSDSSQPF - Total Sequential Prefetch Requests
XDWMY.E DSDSSSEF - Total Storage Shortage Expansion Fails
XDWMY.E DSDSTMIG - Total Migrated Datasets Encountered
XDWMY.E DSDSTPFB - Total WK File Abort - No BP Available
XDWMY.E DSDSTPFC - Total WK PF End - Concur PF of Page
XDWMY.E DSDSTPF0 - Total WK PF Abort - 0 PF QTY
XDWMY.E DSDSTPIO - Total Prefetch Async Read I/Os
XDWMY.E DSDSTRTO - Total Recall Timeouts
XDWMY.E DSDSUSP - Suspend Count
XDWMY.E DSDSVPA - Total Successful VPOOL Expand/Contract
XDWMY.E DSDSVPL - Total Buffers Allocated for VPOOL
XDWMY.E DSDSWBVQ - Total Pages Deq VDWQ Destr Read Req
XDWMY.E DSDSWDRP - Total Pages Destruct Read Request
XDWMY.E DSDSWFD - Total Work Files Denied Sort Merge
XDWMY.E DSDSWFF - Total Poor Sort Merge - Buffer Short
XDWMY.E DSDSWFM - Total Max WK File Alloc Sort Merge
XDWMY.E DSDSWFR - Total Req Query WK File Sort Merge
XDWMY.E DSDSWFT - Total Work Files Req Sort Merge
XDWMY.E DSDSWFXS - Total Write Pagefixed W/O Real Storage
XDWMY.E DSDSWREE - Total Times Write Engine Unavailable
XDWMY.E DSDSWRMM - Total Write I/Os By Media Manager
XDWMY.E DSDSXFL - Total Buffer Not Located -- VPOOL Full
XDWMY.E DSDSXIS - Total Max # Concur Pref Streams Alloc
XDWMY.E DSDTESTB - Binds Without Plan ID
XDWMY.E DSDTIMO - Timeout Count
XDWMY.E DSDTMIG0 - NO. Migrated Dataset Encounter Buffer 0
XDWMY.E DSDTMIG1 - NO. Migrated Dataset Encounter Buffer 1
XDWMY.E DSDTMIG2 - NO. Migrated Dataset Encounter Buffer 2
XDWMY.E DSDTMIG3 - NO. Migrated Dataset Encounter Buffer 3
XDWMY. DSDTPFB0 - WK File Abort - No BP Available 0
XDWMY. DSDTPFB1 - WK File Abort - No BP Available 1
XDWMY. DSDTPFB2 - WK File Abort - No BP Available 2
XDWMY. DSDTPFB3 - WK File Abort - No BP Available 3
XDWMY. DSDTPFC0 - WK PF End - Concur PF of Page 0
XDWMY. DSDTPFC1 - WK PF End - Concur PF OF PAGE 1
XDWMY. DSDTPFC2 - WK PF End - Concur PF OF PAGE 2
XDWMY. DSDTPFC3 - WK PF End - Concur PF OF PAGE 3
XDWMY. DSDTPF00 - WK PF Abort - 0 PF QTY 0
XDWMY. DSDTPF01 - WK PF Abort - 0 PF QTY 1
XDWMY. DSDTPF02 - WK PF Abort - 0 PF QTY 2
XDWMY. DSDTPF03 - WK PF Abort - 0 PF QTY 3
XDWMY.E DSDTPIO0 - NO. Prefetch Async Read I/Os Buffer 0
XDWMY.E DSDTPIO1 - NO. Prefetch Async Read I/Os Buffer 1
XDWMY.E DSDTPIO2 - NO. Prefetch Async Read I/Os Buffer 2
XDWMY.E DSDTPIO3 - NO. Prefetch Async Read I/Os Buffer 3
XDWMY.E DSDTRTBL - Truncate Table Statements
XDWMY.E DSDTRTO0 - NO. Recall Timeouts Buffer 0
XDWMY.E DSDTRTO1 - NO. Recall Timeouts Buffer 1
XDWMY.E DSDTRTO2 - NO. Recall Timeouts Buffer 2
XDWMY.E DSDTRTO3 - NO. Recall Timeouts Buffer 3
XDWMY.E DSDUPDTE - Update Statements
XDWMY.E DSDUSUC - Checks Actually Authorized
XDWMY.E DSDWBVQ0 - Pages Deq VDWQ Destr Read Rq 0
XDWMY.E DSDWBVQ1 - Pages Deq VDWQ Destr Read Rq 1
XDWMY.E DSDWBVQ2 - Pages Deq VDWQ Destr Read Rq 2
XDWMY.E DSDWBVQ3 - Pages Deq VDWQ Destr Read Rq 3
XDWMY.E DSDWDRP0 - Pages Destruct Read Req 0
XDWMY.E DSDWDRP1 - Pages Destruct Read Req 1
XDWMY.E DSDWDRP2 - Pages Destruct Read Req 2
XDWMY.E DSDWDRP3 - Pages Destruct Read Req 3
XDWMY.E DSDWFD0 - Work Files Denied Sort Merge 0
XDWMY.E DSDWFD1 - Work Files Denied Sort Merge 1
XDWMY.E DSDWFD2 - Work Files Denied Sort Merge 2
XDWMY.E DSDWFD3 - Work Files Denied Sort Merge 3
XDWMY.E DSDWFF0 - Poor Sort Merge - Buf Short 0
XDWMY.E DSDWFF1 - Poor Sort Merge - Buf Short 1
XDWMY.E DSDWFF2 - Poor Sort Merge - Buf Short 2
XDWMY.E DSDWFF3 - Poor Sort Merge - Buf Short 3
XDWMY.E DSDWFM0 - Max WK File Alloc Sort Merge 0
XDWMY.E DSDWFM1 - Max WK File Alloc Sort Merge 1
XDWMY.E DSDWFM2 - Max WK File Alloc Sort Merge 2
XDWMY.E DSDWFM3 - Max WK File Alloc Sort Merge 3
XDWMY.E DSDWFR0 - Req Query WK File Sort Merge 0
XDWMY.E DSDWFR1 - Req Query WK File Sort Merge 1
XDWMY.E DSDWFR2 - Req Query WK File Sort Merge 2
XDWMY.E DSDWFR3 - Req Query WK File Sort Merge 3
XDWMY.E DSDWFT0 - Work Files Req Sort Merge 0
XDWMY.E DSDWFT1 - Work Files Req Sort Merge 1
XDWMY.E DSDWFT2 - Work Files Req Sort Merge 2
XDWMY.E DSDWFT3 - Work Files Req Sort Merge 3
XDWMY.E DSDWFXS0 - Write Pagefixed W/O Real Storage 0
XDWMY.E DSDWFXS1 - Write Pagefixed W/O Real Storage 1
XDWMY.E DSDWFXS2 - Write Pagefixed W/O Real Storage 2
XDWMY.E DSDWFXS3 - Write Pagefixed W/O Real Storage 3
XDWMY.E DSDWREE0 - No. Times Write Engine Unavailable 0
XDWMY.E DSDWREE1 - No. Times Write Engine Unavailable 1
XDWMY.E DSDWREE2 - No. Times Write Engine Unavailable 2
XDWMY.E DSDWREE3 - No. Times Write Engine Unavailable 3
XDWMY.E DSDWRMM0 - Write I/Os By Media Manager 0
XDWMY.E DSDWRMM1 - Write I/Os By Media Manager 1
XDWMY.E DSDWRMM2 - Write I/Os By Media Manager 2
XDWMY.E DSDWRMM3 - Write I/Os By Media Manager 3
Minimum Data Elements
XDWMY. DSDMNCFR - Min Free Pages in Statement Pool
XDWMY. DSDMNDRU - Min Stealable DB Descriptors
XDWMY. DSDMNKFR - Min Free Pages in Skeleton Pool
XDWMY. DSDMNKRU - Min Stealable Skeleton Pkg Table
XDWMY. DSDMNQCA - Min Storage Alloc for Plans (>2GB) Bar
XDWMY. DSDMNQCB - Min Storage Alloc for Plans (<2GB) Bar
XDWMY. DSDMNQKA - Min Storage Alloc for Pkgs (>2GB) Bar
XDWMY. DSDMNQKB - Min Storage Alloc for Pkgs (<2GB) Bar
XDWMY.E DSDMNRPG - Min Free Pages in Free Chain
XDWMY. DSDMNSFR - Min Free Pages in Statement (>2GB) Pool
XDWMY. DSDMNSPA - Min Pgs Alloc for Exec Procs
Maximum Data Elements
XDWMY.E DSDAPREC - How Limit Was Determined
XDWMY.E DSDMXBDG - Max Requests for DBD
XDWMY.E DSDMXBDL - Max Loads of DBD
XDWMY. DSDMXCFA - Max Failures: Full Statement Pool
XDWMY. DSDMXCFR - Max Free Pages in Statement Pool
XDWMY. DSDMXCPG - Max Pages in Statement Pool
XDWMY. DSDMXCTA - Max Pages Used for Cursor Tables (>2GB)
XDWMY.E DSDMXCTG - Max Requests for Cursor Table Sections
XDWMY.E DSDMXCTL - Max Loaded Cursor Table Sections
XDWMY.E DSDMXCTU - Max Pages Used for Cursor Tables (<2GB)
XDWMY.E DSDMXDBD - Max Pages Used for DBD
XDWMY.E DSDMXDRS - Max DDs That Drain Has Produced
XDWMY. DSDMXDRU - Max Stealable Database Descriptors
XDWMY.E DSDMXDSO - Max Data Sets Open Concurrently
XDWMY. DSDMXDYN - Max Pages Used in Statement Pool
XDWMY.E DSDMXFAL - Max. No. Failures Due To Full EDM Pool
XDWMY. DSDMXKFA - Max Failures: Full Skeleton Pool
XDWMY. DSDMXKFR - Max Free Pages in Skeleton Pool
XDWMY. DSDMXKPG - Max Pages in Skeleton Pool
XDWMY. DSDMXKRU - Max Stealable Skeleton Pkg Table
XDWMY.E DSDMXPGE - Max Pages in EDM Pool
XDWMY. DSDMXPTA - Max Pages Used for Pkg Tables (>2GB)
XDWMY.E DSDMXPTG - Max Requests for Package Table Section
XDWMY.E DSDMXPTL - Max Loaded Package Table Sections
XDWMY. DSDMXPTU - Max Pages Used for Pkg Tables (<2GB)
XDWMY. DSDMXQCA - Max Storage Alloc for Plans (>2GB) Bar
XDWMY. DSDMXQCB - Max Storage Alloc for Plans (<2GB) Bar
XDWMY. DSDMXQKA - Max Storage Alloc for Pkgs (>2GB) Bar
XDWMY. DSDMXQKB - Max Storage Alloc for Pkgs (<2GB) Bar
XDWMY.E DSDMXROP - Max PB Found on Free Q During Open
XDWMY.E DSDMXRPG - Max Free Pages in Free Chain
XDWMY. DSDMXSFA - Max Failures: Full Stmt (>2GB) Pool
XDWMY. DSDMXSFR - Max Free Pages in Statement (>2GB) Pool
XDWMY.E DSDMXSKC - Max Pages Used for SKCT Table
XDWMY.E DSDMXSKP - Max Pages Used for SKPT Table
XDWMY.E DSDMXSLW - Max DDs Used for Slow Close TS
XDWMY. DSDMXSPA - Max Pgs Alloc for Exec Procs
XDWMY. DSDMXSPG - Max Pages in Statement (>2GB) Pool
XDWMY. DSDMXSTM - Max Number of Statements in EDM Pool
Derived Data Elements
XDWMY. DSDMRPR0 - Media Read Req Per Phys Req Buffer 0
XDWMY. DSDMRPR1 - Media Read Req Per Phys Req Buffer 1
XDWMY. DSDMRPR2 - Media Read Req Per Phys Req Buffer 2
XDWMY. DSDMRPR3 - Media Read Req Per Phys Req Buffer 3
XDWMY. DSDPCWDP - Duplicate Per Parsed Dyna Stmnts
XDWMY. DSDPCWMP - Matched Per Parsed Dyna Stmnts
XDWMY. DSDPCWRP - Replaced Per Parsed Dyna Stmnts
XDWMY. DSDPWPU0 - Page Write Per Page Update Buffer 0
XDWMY. DSDPWPU1 - Page Write Per Page Update Buffer 1
XDWMY. DSDPWPU2 - Page Write Per Page Update Buffer 2
XDWMY. DSDPWPU3 - Page Write Per Page Update Buffer 3
XDWMY. DSDRFRI0 - Read Frames Per Read Req Buffer 0
XDWMY. DSDRFRI1 - Read Frames Per Read Req Buffer 1
XDWMY. DSDRFRI2 - Read Frames Per Read Req Buffer 2
XDWMY. DSDRFRI3 - Read Frames Per Read Req Buffer 3
