5. FILES › 5.4 DB2 User Activity (DB2DSU) File › 5.4.2 Data Element List
5.4.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
.D....E DAY - Day of Month
.DWMY.E DB2ACT1 - AUTHORIZATION ID
.DWMY.E DB2ACT2 - CORRELATION ID
.DWMY.E DB2ACT3 - CONNECTION ID
.DWMY.E DB2ACT4 - DISTRIBUTED THREAD TYPE
.DWMY.E DB2ID - DB2 ID
.DW...E HOUR - Hour of Day
.DWM..E MONTH - Month of Year
.DWMY.E SYSID - System Identifier
.DW...E WEEK - Week of Year
.DWMY.E YEAR - Year of Century
.DWMY.E ZONE - Time Zone
Common Data Elements
.D....E DAYNAME - Name of Day of Week
...... DB2ACE - DB2 Agent Control Element
.DWMY. DB2ATNM - Active Trace Number Mask
.DWMY.E DB2AUTH - Authorization Identifier
.DWMY.E DB2CONN - Connection Identifier
.DWMY.E DB2CORR - Correlation Identifier
......E DB2CPU - DB2 CPU Time
......E DB2CRDLU - CICS/RRSAF/DB Access LU Name
......E DB2CRDNT - CICS/RRSAF/DB Access Network Name
......E DB2CRDUV - CICS/RRSAF/DB Access Uniqueness Value
.DWMY.E DB2DDFCT - DDF DB2 Commits Received from Remote
.DWMY. DB2DSTSN - Destination Sequence Number
.DWMY. DB2ISEQ - Instrumentation Sequence Number
......E DB2LOCN - DB2 Local Location ID
.DWMY. DB2LUNAM - Logical Unit NAME
......E DB2MLVL - MICS DB2 Maintenance Level
.DWMY. DB2NETID - Network ID
.DWMY.E DB2OPID - Original Operator ID
......E DB2PLAN - Plan Name
......E DB2PTASK - Special Transaction Type Identifier
.DWMY. DB2REL - DB2 Release
.DWMY.E DB2RELN - DB2 Release Number
.DWMY.E DB2REQID - DB2 Requestor Location ID
.DWMY.E DB2STCK - DB2 Store Clock At End Event
.DWMY.E DB2THDTY - DB2 Thread Type
...... DB2UNIQ - DB2 Instance Number
.DWMY.E ENDTS - End Time Stamp
.DWMY.E STARTTS - Start Time Stamp
......E TRANETS - Transaction End Time Stamp
......E TRANSTS - Transaction Start Time Stamp
......E UOWID - Unit of Work Id
......E UOWIDSEQ - Unit of Work Id Sequence Number
Retained Data Elements
.DWMY.E DSUAFLG - Flag Byte
.DWMY.E DSUARLID - Resource Limit Table ID
.DWMY.E DSUASLMT - Limit In SUs - ASUTIME
...... DSUBEGSC - Beginning Store Clock
......E DSUBGTCB - Beginning TCB Timer
...... DSUCATYP - Connecting System Type Code
...... DSUDSTSN - Destination Sequence Number
...... DSUENDSC - Ending Store Clock
......E DSUENTCB - Ending TCB Timer
...... DSUISEQ - Instrumentation Sequence Number
.DWMY.E DSUNETID - DB2 Network Identifier
......E DSUOPID - Original Operator ID
......E DSUPLAN - Plan Name
......E DSUREASN - Reason For Accounting Record
.DWMY.E DSURMID - DB2 Resource Manager Identifier
Accumulated Data Elements
.DWMY.E DSUABABD - Abnormal Application Abend
.DWMY.E DSUABEOM - Abnormal End of Memory
.DWMY.E DSUABFRC - Abnormal Force Command
.DWMY.E DSUABORT - Abort Requests
.DWMY.E DSUABRIN - Abnormal Resolve Indoubt
.DWMY.E DSUACHG - Change Request Count
.DWMY.E DSUACHUS - Highest CPU 16 Microseconds Used
.DWMY.E DSUACLMT - Limit In CPU 16 Microseconds
.DWMY.E DSUACNT - No. ACCUMACC Records Encountered
.DWMY.E DSUACSTL - ACCUMACC Count: Staleness
.DWMY.E DSUACSTR - ACCUMACC Count: Storage Exceeded
.DWMY.E DSUACUTR - ACCUMACC Count: Threshold Exceeded
.DWMY.E DSUAIRLM - Other IRLM Request Count
.DWMY.E DSUALDAB - NO. ALTER DATABASE Statements
.DWMY.E DSUALGTM - Class 3 Accum Wait Archive Log Time
.DWMY.E DSUALLTM - Lock & Latch time
.DWMY.E DSUALOCK - Lock Request Count
.DWMY.E DSUALTIX - Alter Index Statements
.DWMY.E DSUALTJR - Alter JAR Statements
.DWMY.E DSUALTST - Alter Stogroup Statements
.DWMY.E DSUALTTA - Alter Table Statements
.DWMY.E DSUALTTS - Alter Tablespace Statements
.DWMY.E DSUALTTX - Alter Trusted Context Statements
.DWMY.E DSUALTVW - Alter View Statements
.DWMY.E DSUAQRY - Query Request Count
.DWMY.E DSUARLCT - NO. Archive Log Suspensions
.DWMY.E DSUARLH - Wait Trace Events Latch Contention
.DWMY.E DSUASLAT - Suspend Count - Latch Conflict
.DWMY.E DSUASOTH - Suspend Count - Other Conflict
.DWMY.E DSUAUNLK - Unlock Request Count
.DWMY.E DSUAWBTM - Wait Time - TCP/IP LOB Material
.DWMY.E DSUAWETM - Class 3 Accum Wait Service Task Time
.DWMY.E DSUAWLTM - Accum Wait Time - Latch Contention
.DWMY.E DSUAWRTM - Class 3 Accum Wait Read Other Time
.DWMY.E DSUAWWTM - Class 3 Accum Wait Write Other Time
.DWMY.E DSUBPNX - Parallel Groups Run Cross Data Share
.DWMY.E DSUCIMW0 - No. of Immed. Sync Write I/O Buffer BP0
.DWMY.E DSUCIMW1 - No. of Immed. Sync Write I/O Buffer BP1
.DWMY.E DSUCIMW2 - No. of Immed. Sync Write I/O Buffer BP2
.DWMY.E DSUCIMW3 - No. of Immed. Sync Write I/O Buffer BP3
.DWMY.E DSUCLOSE - Close Statements
.DWMY.E DSUCLRAB - NO. Log Record Bytes Written
.DWMY.E DSUCLRN - NO. Log Records Written
.DWMY.E DSUCMTON - Comment On Statements
.DWMY.E DSUCOMM2 - Commit Phase Two Invocations
.DWMY.E DSUCOST - Processing Cost
.DWMY.E DSUCPODB - CPU Time Only on a DB2 TCB
.DWMY.E DSUCPUNI - User Instructions
.DWMY.E DSUCPUTM - Accumulated CPU Time
.DWMY.E DSUCPUZ1 - Accum CPU Tm Used on z/OS Spec Eng
.DWMY.E DSUCPUZ2 - CPU Tm Used in DB2 on z/OS Spec Eng
.DWMY.E DSUCP1TM - Total CP Class 1 CPU Time
.DWMY.E DSUCP2TM - Total CP Class 2 CPU Time
.DWMY.E DSUCRAL - CREATE ALIAS
.DWMY.E DSUCRCTX - Create Trusted Context Statements
.DWMY.E DSUCRDAB - Create Database Statements
.DWMY.E DSUCRINX - Create Index Statements
.DWMY.E DSUCRROL - Create Role Statements
.DWMY.E DSUCRSTG - Create Stogroup Statements
.DWMY.E DSUCRSYN - Create Synonym Statements
.DWMY.E DSUCRTAB - Create Table Statements
.DWMY.E DSUCTABS - Create Tablespace Statements
.DWMY.E DSUCWLD - Times Duplicate Concentrate Dyna Stmnts
.DWMY.E DSUCWLM - Times Matched Concentrate Dyna Stmnts
.DWMY.E DSUCWLP - Times Parsed Concentrate Dyna Stmnts
.DWMY.E DSUCWLR - Times Replaced Concentrate Dyna Stmnts
.DWMY.E DSUDEAD - Deadlock Count
.DWMY.E DSUDEFVU - Create View Statements
.DWMY.E DSUDELET - Delete Statements
.DWMY.E DSUDESC - Describe Statements
.DWMY.E DSUDGBUF - Parallel Groups to Seq Storage Short
.DWMY.E DSUDGCUR - Parallel Groups to Seq Cursor Update
.DWMY.E DSUDGESA - Parallel Groups to Seq No ESA Sort
.DWMY.E DSUDRAL - DROP ALIAS
.DWMY.E DSUDRPDB - Drop Database Statements
.DWMY.E DSUDRPIX - Drop Index Statements
.DWMY.E DSUDRPKG - NO. DROP PACKAGE Statements
.DWMY.E DSUDRPRO - Drop Role Statements
.DWMY.E DSUDRPST - Drop Stogroup Statements
.DWMY.E DSUDRPSY - Drop Synonym Statements
.DWMY.E DSUDRPTA - Drop Table Statements
.DWMY.E DSUDRPTS - Drop Tablespace Statements
.DWMY.E DSUDRPTX - Drop Trusted Context Statements
.DWMY.E DSUDRPVU - Drop View Statements
.DWMY.E DSUDSCRT - NO. DESCRIBE TABLE Statements
.DWMY.E DSUEGENC - Parallel Groups Executed Sequential
.DWMY.E DSUELGZP - Accumulated CPU Time zIIP-Eligible Work
.DWMY.E DSUELPTM - Elapsed Time
.DWMY.E DSUENTEX - NO. Entry/Exit events processed
.DWMY.E DSUET2TM - Elapsed Time in DB2
.DWMY.E DSUFETCH - Fetch Statements rel 2
.DWMY.E DSUFRIDS - Times RID List Overflowed RID Storage
.DWMY.E DSUFRIDT - Times RID List Overflowed RID Exceeded
.DWMY.E DSUGPGR0 - GETPAGE Requests BP0
.DWMY.E DSUGPGR1 - GETPAGE Requests BP1
.DWMY.E DSUGPGR2 - GETPAGE Requests BP2
.DWMY.E DSUGPGR3 - GETPAGE Requests BP3
.DWMY.E DSUGRANT - Grant Statements
.DWMY.E DSUINCRB - Incremental Binds
.DWMY.E DSUINSRT - Insert Statements
.DWMY.E DSUIOETM - DB2 Accumulated I/O Elapsed Wait Time
.DWMY.E DSUJINCS - Times RID List Append RID Storage
.DWMY.E DSUJINCT - Times RID List Append RID Exceeded
.DWMY.E DSULABEL - Label Statements rel 2
.DWMY.E DSULEEM - NO. Lock Escalations to Exclusive mode
.DWMY.E DSULESM - NO. Lock Escalations to shared mode
.DWMY.E DSULOCK - Lock Table Statements
.DWMY.E DSULPF0 - No. List Prefetch Requested BP0
.DWMY.E DSULPF1 - No. List Prefetch Requested BP1
.DWMY.E DSULPF2 - No. List Prefetch Requested BP2
.DWMY.E DSULPF3 - No. List Prefetch Requested BP3
.DWMY.E DSUMERGE - Merge Statements
.DWMY.E DSUMIXNL - Mult Indx Not Used - RID Limit
.DWMY.E DSUMIXNU - Mult Indx Not Used - No Storage
.DWMY.E DSUMIXU - Multiple Index Path Used
.DWMY.E DSUMXPL - Max. no. Page locks held
.DWMY.E DSUNATHD - Count of ACCUMACC Roll-up Threads
.DWMY.E DSUNOGRP - Parallel Groups Exec Planned Degree
.DWMY.E DSUNTDEL - Normal Deallocation
.DWMY.E DSUNTEND - Normal Application Ended
.DWMY.E DSUNTEOT - Normal End of Task
.DWMY.E DSUNTHRD - Count Of Threads Initiated
.DWMY.E DSUNTIFI - Normal IFI READS Request
.DWMY.E DSUNTNUS - Normal New User
.DWMY.E DSUNTSUS - Normal Same User Partial Signon
.DWMY.E DSUOPEN - Open Statements
.DWMY.E DSUORNO - Parallel Groups Executed Coordination
.DWMY.E DSUORR - Parallel Groups Executed Repeat-read
.DWMY.E DSUPCWDP - Duplicate Per Parsed Dyna Stmnts
.DWMY.E DSUPCWMP - Matched Per Parsed Dyna Stmnts
.DWMY.E DSUPCWRP - Replaced Per Parsed Dyna Stmnts
.DWMY.E DSUPELPT - Parallel Subtasks Elapsed Time
.DWMY.E DSUPET2T - Parallel Subtasks Elapsed Time in DB2
.DWMY.E DSUPGDTT - Parallel GPS Using UDF - Ex. Single DB2
.DWMY.E DSUPREP - Prepare Statements
.DWMY.E DSUPRFH0 - Prefetch Read Requests Buffer BP0
.DWMY.E DSUPRFH1 - Prefetch Read Requests Buffer BP1
.DWMY.E DSUPRFH2 - Prefetch Read Requests Buffer BP2
.DWMY.E DSUPRFH3 - Prefetch Read Requests Buffer BP3
.DWMY.E DSUPSTCT - Parallel Subtasks Count
.DWMY.E DSUQUERY - Fetch and Select Statements
.DWMY.E DSURDGRP - Parallel Groups Reduced Storage Short
.DWMY.E DSURDLTD - Deleted Rows
.DWMY.E DSUREVOK - Revoke Statements
.DWMY.E DSURFCHD - Fetched Rows
.DWMY.E DSURLFDP - Query Parallelism Disabled by RLF
.DWMY. DSURNIX - Rename Index Statements
.DWMY.E DSURNKCL - No. Wait Trace Glbl Cont. Child LLock
.DWMY.E DSURNMOL - No. Wait Trace Glbl Cont. Other LLock
.DWMY.E DSURNNPL - No. Wait Trace Glbl Cont. PP PLock
.DWMY.E DSURNOPL - No. Wait Trace Glbl Cont. PG PLock
.DWMY.E DSURNQOL - No. Wait Trace Glbl Cont. Other PLock
.DWMY.E DSURNSTD - Inserted Rows
.DWMY.E DSURPOP1 - Parallel GPS Reformatted - Sysplx Conf
.DWMY.E DSURPOP2 - Parallel GPS Reformatted - Buffer Resrc
.DWMY.E DSURRAIC - Commit Specified for RRSAF Thread
.DWMY.E DSURUDTD - Updated Rows
.DWMY.E DSUSCIMW - Total Immed. Sync Write I/Os Count
.DWMY.E DSUSDPF - Total Dynamic Prefetch Requests
.DWMY.E DSUSELCT - Select Statements rel 2
.DWMY.E DSUSETHV - NO. SET HOST-VAR Statements
.DWMY.E DSUSGPGR - Total GETPAGE Requests
.DWMY.E DSUSHPG - Total Pages HPOOL to VPOOL Prefetch
.DWMY.E DSUSHRE - Total Sync Req Move Pge HPOOL to VPOOL
.DWMY.E DSUSHRF - Total Unsucc. Read Req Expanded Stg
.DWMY.E DSUSHWF - Total Unsucc. Write Req Expanded Stg
.DWMY.E DSUSHWR - Total Sync Req Move Pge VPOOL to HPOOL
.DWMY.E DSUSKIP - Parallel Coordination Bypass DB2
.DWMY.E DSUSLPF - Total Times List Prefetch Requested
.DWMY.E DSUSMIAP - Times RID List Retrieval Skipped
.DWMY.E DSUSNGT - Total Times GETPAGE Req Not Satisfied
.DWMY.E DSUSPCTM - Accum CPU Time SQL Procedures Main Unit
.DWMY.E DSUSPRFH - Total Times List Prefetch Requested
.DWMY.E DSUSPRU0 - System Page Record Update BP0
.DWMY.E DSUSPRU1 - System Page Record Update BP1
.DWMY.E DSUSPRU2 - System Page Record Update BP2
.DWMY.E DSUSPRU3 - System Page Record Update BP3
.DWMY.E DSUSPZET - Total Elapsed Time on zIIP Stored Proc.
.DWMY.E DSUSPZTM - CPU Tm Exec Strd Proc on z/OS Spec Eng
.DWMY.E DSUSQLID - NO. Of Set Current SQLID
.DWMY.E DSUSRIO0 - Synchronous Read I/Os BP0
.DWMY.E DSUSRIO1 - Synchronous Read I/Os BP1
.DWMY.E DSUSRIO2 - Synchronous Read I/Os BP2
.DWMY.E DSUSRIO3 - Synchronous Read I/Os BP3
.DWMY.E DSUSSIO - Total Async Pages Read by Prefetch
.DWMY.E DSUSSPRU - Total System Page Record Update
.DWMY.E DSUSSRIO - Total Synchronous Read I/Os
.DWMY.E DSUSUSP - Suspend Count
.DWMY.E DSUTCBTM - TCB Time
.DWMY.E DSUTC2TM - Class 2 Accumulated TCB Time in DB2
.DWMY.E DSUTELPT - Comprehensive Elapsed Time
.DWMY.E DSUTET2T - Comprehensive Elapsed Time in DB2
.DWMY.E DSUTHINA - DDF Thread Becomes Inactive
.DWMY.E DSUTHIN2 - Type 2 Inactive Thread Becomes Inactive
.DWMY.E DSUTIMO - Timeout Count
.DWMY.E DSUTOGRP - Parallel Groups Executed
.DWMY.E DSUTRTBL - Truncate Table Statements
.DWMY.E DSUTRTZP - CPU Tm Exec Triggers on z/OS Spec Eng
.DWMY.E DSUTSQLE - Number of SQL Statements Executed
.DWMY.E DSUUPDTE - Update Statements
.DWMY.E DSUWATRB - Wt Trace for TCP/IP LOB Material
.DWMY.E DSUWATRL - NO. Wait Trace Events for Lock/Latch
.DWMY.E DSUWATRR - NO. Wait Trace Events for Read Other
.DWMY.E DSUWATRW - NO. Wait Trace Events for Write Other
.DWMY.E DSUWATSE - NO. Wait Trace Events for Sync. Exec.
.DWMY.E DSUWATTR - NO. Wait Trace events processed
.DWMY.E DSUWGLTM - Glbl Contention PG P-Lock Wait Time
.DWMY.E DSUWLCTM - Glbl Contention Child L-Lock Wait Time
.DWMY.E DSUWLLTM - Glbl Contention Other L-Locks Wait Time
.DWMY.E DSUWLPTM - Glbl Contention PP P-Lock Wait Time
.DWMY.E DSUWTOTM - Glbl Contention Other P-Locks Wait Time
.DWMY.E DSUWUABD - Work In Doubt Abend
.DWMY.E DSUWUEOM - Work In Doubt End of Memory
.DWMY.E DSUWUFRC - Work In Doubt Force Command
.DWMY.E DSUWURIN - Work In Doubt Resolve Indoubt
.DWMY.E DSUXSODB - DB2 Only and Non zIIP-Eligible CPU Time
.DWMY.E DSUXSPTM - CPU Time Excluding Special CPU Time
Maximum Data Elements
.DWMY.E DSUAPREC - How Limit Was Determined
.DWMY.E DSUMMXPL - Max Max. no. Page locks held
.DWMY.E DSUMXDEG - Max Degree of Parallelism
