5. FILES › 5.2 DB2 System Activity (DB2DSY) File › 5.2.2 Data Element List
5.2.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
X..... DB2ATNM - Active Trace Number Mask
X.....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 DB2THDTY - DB2 Thread Type
XDWMY.E DURATION - Recording Interval Time
XDWMY.E ENDTS - End Time Stamp
XDWMY.E STARTTS - Start Time Stamp
Retained Data Elements
XDWMY. DSYASP0 - Start Address Space Procedure 0
XDWMY. DSYASP1 - Start Address Space Procedure 1
XDWMY. DSYASP2 - Start Address Space Procedure 2
XDWMY. DSYASP3 - Start Address Space Procedure 3
XDWMY. DSYASP4 - Start Address Space Procedure 4
XDWMY. DSYASP5 - Start Address Space Procedure 5
X..... DSYDSTSN - Destination Sequence Number
X.....E DSYHRBA - High Used Log RBA
X.....E DSYIDESA - Instrumentation Destination 10
X.....E DSYIDESB - Instrumentation Destination 11
X.....E DSYIDESC - Instrumentation Destination 12
X.....E DSYIDESD - Instrumentation Destination 13
X.....E DSYIDESE - Instrumentation Destination 14
X..... DSYIDESF - Instrumentation Destination 15
X.....E DSYIDES1 - Instrumentation Destination 1
X.....E DSYIDES2 - Instrumentation Destination 2
X.....E DSYIDES3 - Instrumentation Destination 3
X.....E DSYIDES4 - Instrumentation Destination 4
X.....E DSYIDES5 - Instrumentation Destination 5
X.....E DSYIDES6 - Instrumentation Destination 6
X.....E DSYIDES7 - Instrumentation Destination 7
X.....E DSYIDES8 - Instrumentation Destination 8
X.....E DSYIDES9 - Instrumentation Destination 9
X..... DSYIFCSD - IFCID Sequence Number Data Base
X..... DSYIFCSS - IFCID Sequence Number System
X..... DSYIFCSU - IFCID Sequence Number User
X..... DSYIFCSX - IFC sequence number Other
X.....E DSYISEQ - Instrumentation Sequence Number
XDWMY. DSYRMID - DB2 Resource Manager Identifier
Accumulated Data Elements
XDWMY.E DSYABORT - Successful Aborts
XDWMY.E DSYACFTQ - ACCUMACC Count: Failure to Qualify
XDWMY.E DSYACSTL - ACCUMACC Count: Staleness
XDWMY.E DSYACSTR - ACCUMACC Count: Storage Exceeded
XDWMY.E DSYACUTR - ACCUMACC Count: Threshold Exceeded
XDWMY. DSYAD0NI - Address Space 0 Instructions
XDWMY. DSYAD1NI - Address Space 1 Instructions
XDWMY. DSYAD2NI - Address Space 2 Instructions
XDWMY. DSYAD3NI - Address Space 3 Instructions
XDWMY. DSYAD4NI - Address Space 4 Instructions
XDWMY. DSYAD5NI - Address Space 5 Instructions
XDWMY.E DSYALGCI - Active Log Control Intervals
XDWMY.E DSYARLOG - Archive Log Count
XDWMY.E DSYARLRA - Archive Log Read Allocations
XDWMY.E DSYARLWA - Archive Log Write Allocations
XDWMY.E DSYBFERA - Count of Buffer errors 10
XDWMY.E DSYBFERB - Count of Buffer errors 11
XDWMY.E DSYBFERC - Count of Buffer errors 12
XDWMY.E DSYBFERD - Count of Buffer errors 13
XDWMY.E DSYBFERE - Count of Buffer errors 14
XDWMY. DSYBFERF - Count of Buffer Errors 15
XDWMY.E DSYBFER1 - Count of Buffer errors 1
XDWMY.E DSYBFER2 - Count of Buffer errors 2
XDWMY.E DSYBFER3 - Count of Buffer errors 3
XDWMY.E DSYBFER4 - Count of Buffer errors 4
XDWMY.E DSYBFER5 - Count of Buffer errors 5
XDWMY.E DSYBFER6 - Count of Buffer errors 6
XDWMY.E DSYBFER7 - Count of Buffer errors 7
XDWMY.E DSYBFER8 - Count of Buffer errors 8
XDWMY.E DSYBFER9 - Count of Buffer errors 9
XDWMY. DSYBNASA - Buffer Not Available Audit 140
XDWMY. DSYBNASB - Buffer Not Available Audit 141
XDWMY. DSYBNASC - Buffer Not Available Audit 142
XDWMY. DSYBNASD - Buffer Not Available Data Base
XDWMY. DSYBNASE - Buffer Not Available End Trace
XDWMY. DSYBNASF - Buffer Not Available Audit 145
XDWMY. DSYBNASG - Buffer Not Available Audit 146
XDWMY. DSYBNASH - Buffer Not Available Audit 143
XDWMY. DSYBNASI - Buffer Not Available Audit 144
XDWMY. DSYBNASP - Buffer Not Available System 106
XDWMY. DSYBNASS - Buffer Not Available System
XDWMY. DSYBNAST - Buffer Not Available Start Trace
XDWMY. DSYBNASU - Buffer Not Available User
XDWMY. DSYBNASX - Buffer Not Available - all perf
XDWMY.E DSYBSDSA - BSDS Accesses
XDWMY.E DSYCIN2 - Current Inactive Connections
XDWMY.E DSYCNAT - Current Active DBATs
XDWMY.E DSYCNINO - Control Intervals Offloaded
XDWMY. DSYCOLFA - Collection Failures Audit 140
XDWMY. DSYCOLFB - Collection Failures Audit 141
XDWMY. DSYCOLFC - Collection Failures Audit 142
XDWMY. DSYCOLFD - Collection Failures Data Base
XDWMY. DSYCOLFE - Collection Failures End Trace
XDWMY. DSYCOLFF - Collection Failures Audit 145
XDWMY. DSYCOLFG - Collection Failures Audit 146
XDWMY. DSYCOLFH - Collection Failures Audit 143
XDWMY. DSYCOLFI - Collection Failures Audit 144
XDWMY. DSYCOLFP - Collection Failures System 106
XDWMY. DSYCOLFS - Collection Failures System
XDWMY. DSYCOLFT - Collection Failures Start Trace
XDWMY. DSYCOLFU - Collection Failures User
XDWMY. DSYCOLFX - Collection Failures - all perf
XDWMY.E DSYCOMM - Successful Commits
XDWMY.E DSYCONEC - Successful Connects To DB2
XDWMY.E DSYCOST - Processing Cost
XDWMY.E DSYCPTM0 - Accumulated CPU Time Addr0
XDWMY.E DSYCPTM1 - Accumulated CPU Time Addr1
XDWMY.E DSYCPTM2 - Accumulated CPU Time Addr 2
XDWMY.E DSYCPTM3 - Accumulated CPU Time Addr 3
XDWMY.E DSYCPTM4 - Accumulated CPU Time Addr 4
XDWMY.E DSYCPTM5 - Accumulated CPU Time Addr 5
XDWMY.E DSYCPUTM - Accumulated CPU Time All ASIDs
XDWMY.E DSYCSTR - Cold Start Connections
XDWMY.E DSYCTHDW - Create Thread Requests Waited
XDWMY.E DSYCTHRD - Successful Create Threads
XDWMY.E DSYCWRAL - Calls To Write Active Log
XDWMY.E DSYDDFCN - CANCEL DDF Commands
XDWMY.E DSYDDFSP - STOP DDF Commands
XDWMY.E DSYDDFST - START DDF Commands
XDWMY. DSYDISPT - DISPLAY TRACE Commands
XDWMY.E DSYDSCA - Count of IFI Abends
XDWMY.E DSYDSCCO - Count of IFI Command Requests
XDWMY.E DSYDSCRA - Count of IFI Reada Requests
XDWMY.E DSYDSCRS - Count of IFI Reads Requests
XDWMY.E DSYDSCU - Count of IFI Unrecognized Functions
XDWMY.E DSYDSCWR - Count of IFI Write Requests
XDWMY.E DSYDSPDB - Display Database Commands
XDWMY.E DSYDSPLC - DISP LOCATION Commands
XDWMY.E DSYDSPTH - Display Thread Commands
XDWMY.E DSYDSPUT - Display Utility Commands
XDWMY.E DSYEOMEM - End of Memory
XDWMY.E DSYEOTSK - End Of Task
XDWMY.E DSYEXIT - Successful DSN3EXITs
XDWMY.E DSYHUHCM - Unrecognized Commands
XDWMY. DSYIFCNA - IFC Records Not Written Audit 140
XDWMY. DSYIFCNB - IFC Records Not Written Audit 141
XDWMY. DSYIFCNC - IFC Records Not Written Audit 142
XDWMY. DSYIFCND - IFC Records Not Written Data
XDWMY. DSYIFCNE - IFC Records Not Written End Trace
XDWMY. DSYIFCNF - IFC Records Not Written Audit 145
XDWMY. DSYIFCNG - IFC Records Not Written Audit 146
XDWMY. DSYIFCNH - IFC Records Not Written Audit 143
XDWMY. DSYIFCNI - IFC Records Not Written Audit 144
XDWMY. DSYIFCNP - IFC Records Not Written System 106
XDWMY. DSYIFCNS - IFC Records Not Written System
XDWMY. DSYIFCNT - IFC Records Not Written Start Trace
XDWMY. DSYIFCNU - IFC Records Not Written User
XDWMY. DSYIFCNX - IFC Records Not Written
XDWMY. DSYIFCWA - IFC Rec Success Written Audit 140
XDWMY. DSYIFCWB - IFC Rec Success Written Audit 141
XDWMY. DSYIFCWC - IFC Rec Success Written Audit 142
XDWMY. DSYIFCWD - IFC Rec Success Written Data Base
XDWMY. DSYIFCWE - IFC Rec Success Written End Trace
XDWMY. DSYIFCWF - IFC Rec Success Written Audit 145
XDWMY. DSYIFCWG - IFC Rec Success Written Audit 146
XDWMY. DSYIFCWH - IFC Rec Success Written Audit 143
XDWMY. DSYIFCWI - IFC Rec Success Written Audit 144
XDWMY. DSYIFCWP - IFC Rec Success Written 106 Record
XDWMY. DSYIFCWS - IFC Rec Success Written System
XDWMY. DSYIFCWT - IFC Rec Success Written Start Trace
XDWMY. DSYIFCWU - IFC Rec Success Written User
XDWMY. DSYIFCWX - IFC Records Written
XDWMY.E DSYINDBT - Number Of Indoubt Threads
X..... DSYINSEA - Instrumentation Sequence Count 10
X..... DSYINSEB - Instrumentation Sequence Count 11
X..... DSYINSEC - Instrumentation Sequence Count 12
X..... DSYINSED - Instrumentation Sequence Count 13
X..... DSYINSEE - Instrumentation Sequence Count 14
X..... DSYINSEF - Instrumentation Sequence Count 15
X..... DSYINSE1 - Instrumentation Sequence Count 1
X..... DSYINSE2 - Instrumentation Sequence Count 2
X..... DSYINSE3 - Instrumentation Sequence Count 3
X..... DSYINSE4 - Instrumentation Sequence Count 4
X..... DSYINSE5 - Instrumentation Sequence Count 5
X..... DSYINSE6 - Instrumentation Sequence Count 6
X..... DSYINSE7 - Instrumentation Sequence Count 7
X..... DSYINSE8 - Instrumentation Sequence Count 8
X..... DSYINSE9 - Instrumentation Sequence Count 9
XDWMY.E DSYLWRF - Log Write Requests Force
XDWMY.E DSYLWRNW - Log Write Requests Nowait
XDWMY.E DSYLWRW - Log Write Requests Wait
XDWMY.E DSYMARD - Max Currently Active DBAT Pkgs Bound
XDWMY.E DSYNADS - Current DBATs Not In Use
XDWMY.E DSYNAERA - Count of Not Active errors 10
XDWMY.E DSYNAERB - Count of Not Active errors 11
XDWMY.E DSYNAERC - Count of Not Active errors 12
XDWMY.E DSYNAERD - Count of Not Active errors 13
XDWMY.E DSYNAERE - Count of Not Active errors 14
XDWMY. DSYNAERF - Count of Not-Active Errors 15
XDWMY.E DSYNAER1 - Count of Not Active errors 1
XDWMY.E DSYNAER2 - Count of Not Active errors 2
XDWMY.E DSYNAER3 - Count of Not Active errors 3
XDWMY.E DSYNAER4 - Count of Not Active errors 4
XDWMY.E DSYNAER5 - Count of Not Active errors 5
XDWMY.E DSYNAER6 - Count of Not Active errors 6
XDWMY.E DSYNAER7 - Count of Not Active errors 7
XDWMY.E DSYNAER8 - Count of Not Active errors 8
XDWMY.E DSYNAER9 - Count of Not Active errors 9
XDWMY.E DSYNARD - Currently Active DBAT Pkgs Bound
XDWMY.E DSYNCKPT - Count of DB2 Checkpoints
XDWMY.E DSYNDBA - DBATs Created
XDWMY.E DSYNITC - Connections Terminated - Max Inactive
XDWMY.E DSYNQR2 - Current Inactive Connections Queued
XDWMY.E DSYNREC - Count of Type 100 Subtype 0 Recs
XDWMY.E DSYPOOL - Pool DBATs Reused
XDWMY.E DSYPREPR - Successful Prepare To Commits
XDWMY.E DSYQCIT - Current Inactive DBATs
XDWMY.E DSYQCRT - Conversations Deallocated - Max Remote
XDWMY.E DSYQDBT - DBATs Queued - Max Remote Active
XDWMY.E DSYQIN2 - Inactive Connections Queued Requests
XDWMY.E DSYRCNAA - Count of Records not accepted 10
XDWMY.E DSYRCNAB - Count of Records not accepted 11
XDWMY.E DSYRCNAC - Count of Records not accepted 12
XDWMY.E DSYRCNAD - Count of Records not accepted 13
XDWMY.E DSYRCNAE - Count of Records not accepted 14
XDWMY. DSYRCNAF - Count of Records Not Accepted 15
XDWMY.E DSYRCNA1 - Count of Records not accepted 1
XDWMY.E DSYRCNA2 - Count of Records not accepted 2
XDWMY.E DSYRCNA3 - Count of Records not accepted 3
XDWMY.E DSYRCNA4 - Count of Records not accepted 4
XDWMY.E DSYRCNA5 - Count of Records not accepted 5
XDWMY.E DSYRCNA6 - Count of Records not accepted 6
XDWMY.E DSYRCNA7 - Count of Records not accepted 7
XDWMY.E DSYRCNA8 - Count of Records not accepted 8
XDWMY.E DSYRCNA9 - Count of Records not accepted 9
XDWMY.E DSYRCNDA - Records Not Desired Audit 140
XDWMY.E DSYRCNDB - Records Not Desired Audit 141
XDWMY.E DSYRCNDC - Records Not Desired Audit 142
XDWMY.E DSYRCNDD - Records Not Desired Data Base
XDWMY.E DSYRCNDE - Records Not Desired End Trace
XDWMY.E DSYRCNDF - Records Not Desired Audit 145
XDWMY.E DSYRCNDG - Records Not Desired Audit 146
XDWMY.E DSYRCNDH - Records Not Desired Audit 143
XDWMY.E DSYRCNDI - Records Not Desired Audit 144
XDWMY.E DSYRCNDP - Records Not Desired System 106
XDWMY.E DSYRCNDS - Records Not Desired System
XDWMY.E DSYRCNDT - Records Not Desired Start Trace
XDWMY.E DSYRCNDU - Records Not Desired User
XDWMY. DSYRCNDX - Records Not Desired - all perf
XDWMY.E DSYRDAA - Reads Delayed Tape Volume Contention
XDWMY.E DSYRDON - Number of Read Only Commits
XDWMY.E DSYRECBS - Recover BSDS Commands
XDWMY.E DSYRECIN - Recover Indoubt Commands
XDWMY.E DSYRECNA - Records Unsuccessfully Written 10
XDWMY.E DSYRECNB - Records Unsuccessfully Written 11
XDWMY.E DSYRECNC - Records Unsuccessfully Written 12
XDWMY.E DSYRECND - Records Unsuccessfully Written 13
XDWMY.E DSYRECNE - Records Unsuccessfully Written 14
XDWMY. DSYRECNF - Records Unsuccessfully Written 15
XDWMY.E DSYRECN1 - Records Unsuccessfully Written 1
XDWMY.E DSYRECN2 - Records Unsuccessfully Written 2
XDWMY.E DSYRECN3 - Records Unsuccessfully Written 3
XDWMY.E DSYRECN4 - Records Unsuccessfully Written 4
XDWMY.E DSYRECN5 - Records Unsuccessfully Written 5
XDWMY.E DSYRECN6 - Records Unsuccessfully Written 6
XDWMY.E DSYRECN7 - Records Unsuccessfully Written 7
XDWMY.E DSYRECN8 - Records Unsuccessfully Written 8
XDWMY.E DSYRECN9 - Records Unsuccessfully Written 9
XDWMY.E DSYRECWA - Records Successfully Written 10
XDWMY.E DSYRECWB - Records Successfully Written 11
XDWMY.E DSYRECWC - Records Successfully Written 12
XDWMY.E DSYRECWD - Records Successfully Written 13
XDWMY.E DSYRECWE - Records Successfully Written 14
XDWMY. DSYRECWF - Records Successfully Written 15
XDWMY.E DSYRECW1 - Records Successfully Written 1
XDWMY.E DSYRECW2 - Records Successfully Written 2
XDWMY.E DSYRECW3 - Records Successfully Written 3
XDWMY.E DSYRECW4 - Records Successfully Written 4
XDWMY.E DSYRECW5 - Records Successfully Written 5
XDWMY.E DSYRECW6 - Records Successfully Written 6
XDWMY.E DSYRECW7 - Records Successfully Written 7
XDWMY.E DSYRECW8 - Records Successfully Written 8
XDWMY.E DSYRECW9 - Records Successfully Written 9
XDWMY.E DSYRESLV - Successful Resolve Indoubts
XDWMY.E DSYRSACL - Reads Satisfied Active Log
XDWMY.E DSYRSARL - Reads Satisfied Archive Log
XDWMY.E DSYRSAT - Resynchronizations Attempted
XDWMY. DSYRSINV - Reason Statistics were taken
XDWMY.E DSYRSOB - Reads Satisfied Output Buffers
XDWMY.E DSYRSSU - Resynchronizations Succeeded
XDWMY.E DSYSIGN - Successful Signons
XDWMY.E DSYSPDBA - Stop Database Commands
XDWMY.E DSYSPDB2 - Stop DB2 Commands
XDWMY.E DSYSPTRC - Stop Trace Commands
XDWMY.E DSYSRBTM - Accumulated SRB Time All ASIDs
XDWMY.E DSYSRTM0 - Accumulated SRB Time Addr0
XDWMY.E DSYSRTM1 - Accumulated SRB Time Addr1
XDWMY.E DSYSRTM2 - Accumulated SRB Time Addr 2
XDWMY.E DSYSRTM3 - Accumulated SRB Time Addr 3
XDWMY.E DSYSRTM4 - Accumulated SRB Time Addr 4
XDWMY.E DSYSRTM5 - Accumulated SRB Time Addr 5
XDWMY.E DSYSSICL - Number of SSI Calls
XDWMY.E DSYSTDBA - Start Database Commands
XDWMY.E DSYSTDB2 - Start DB2 Commands
XDWMY.E DSYSTTRC - Start Trace Commands
XDWMY.E DSYSUSCT - DSY Suspend Count
XDWMY.E DSYSYNC - Successful Synchronizes
XDWMY.E DSYTCBTM - Accumulated TCB Time All ASIDs
XDWMY.E DSYTCTAD - Access Database Commands
XDWMY.E DSYTCTM0 - Accumulated TCB Time Addr0
XDWMY.E DSYTCTM1 - Accumulated TCB Time Addr1
XDWMY.E DSYTCTM2 - Accumulated TCB Time Addr 2
XDWMY.E DSYTCTM3 - Accumulated TCB Time Addr 3
XDWMY.E DSYTCTM4 - Accumulated TCB Time Addr 4
XDWMY.E DSYTCTM5 - Accumulated TCB Time Addr 5
XDWMY.E DSYTCTRE - Start Rlimit Count
XDWMY.E DSYTCTRF - Stop Rlimit Count
XDWMY.E DSYTCTRG - Display Rlimit Count
XDWMY.E DSYTCTRH - Modify Trace Count
XDWMY.E DSYTCTRN - Alter Bufferpool Count
XDWMY.E DSYTCTRO - Display Bufferpool Count
XDWMY.E DSYTCTRP - Set Archive Count
XDWMY.E DSYTCTRQ - Display Archive Count
XDWMY.E DSYTCTRR - Reset Indoubt Count
XDWMY.E DSYTCTSD - Display Profile Commands
XDWMY.E DSYTCTSS - Start Profile Commands
XDWMY.E DSYTCTST - Stop Profile Commands
XDWMY.E DSYTCTX5 - DISPLAY DDF Commands
XDWMY.E DSYTERM - Successful Terminates
XDWMY.E DSYTERMU - Term Utility Commands
XDWMY.E DSYWFAIA - Count of Write failures 10
XDWMY.E DSYWFAIB - Count of Write failures 11
XDWMY.E DSYWFAIC - Count of Write failures 12
XDWMY.E DSYWFAID - Count of Write failures 13
XDWMY.E DSYWFAIE - Count of Write failures 14
XDWMY. DSYWFAIF - Count of Write Failures 15
XDWMY.E DSYWFAI1 - Count of Write failures 1
XDWMY.E DSYWFAI2 - Count of Write failures 2
XDWMY.E DSYWFAI3 - Count of Write failures 3
XDWMY.E DSYWFAI4 - Count of Write failures 4
XDWMY.E DSYWFAI5 - Count of Write failures 5
XDWMY.E DSYWFAI6 - Count of Write failures 6
XDWMY.E DSYWFAI7 - Count of Write failures 7
XDWMY.E DSYWFAI8 - Count of Write failures 8
XDWMY.E DSYWFAI9 - Count of Write failures 9
XDWMY.E DSYWSTR - Warm Start Connections
XDWMY.E DSYWUWB - Wait Unavailable Write Buffer
Maximum Data Elements
XDWMY.E DSYHWCT - High Water Mark for CTHREAD Threads
XDWMY.E DSYHWIB - High Water Mark for IDBACK Threads
XDWMY.E DSYHWIF - High Water Mark for IDFORE Threads
XDWMY.E DSYMHWAT - Active DBATs High-Water Mark
XDWMY.E DSYMHWDT - Remote Connections High-Water Mark
XDWMY.E DSYMMADS - DBATs Not In Use High-Water Mark
XDWMY.E DSYMMIN2 - Inactive Connections High-Water Mark
XDWMY.E DSYMMQR2 - Inactive Connections Queued HWM
XDWMY.E DSYMQMIT - Inactive DBATs High-Water Mark
