5. FILES › 5.8 DB2 System DDF Statistics (DB2DDY) File › 5.8.2 Data Element List

5.8.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.

GENERATION DATE: Tue, May 12, 2009

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
 XDWMY.E  DB2RLOCN - DDF Remote Location ID
 XDWMY.E  DB2THDTY - DB2 Thread Type
 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.....   DB2ACE   - DB2 Agent Control Element
 X.....   DB2ATNM  - Active Trace Number Mask
 XDWMY.E  DB2DSGN  - Data Sharing Group Name
 X.....   DB2DSTSN - Destination Sequence Number
 X.....E  DB2ISEQ  - Instrumentation Sequence Number
 XDWMY.E  DB2LOCN  - DB2 Local Location ID
 XDWMY.E  DB2MEMN  - DB2 Member Name
 XDWMY.E  DB2MLVL  - MICS DB2 Maintenance Level
 X.....E  DB2RELN  - DB2 Release Number
 X.....   DB2STCK  - DB2 Store Clock At End Event
 XDWMY.E  DURATION - Recording Interval Time
 XDWMY.E  ENDTS    - End Time Stamp
 XDWMY.E  MICSVER  - CA MICS Version Number
 XDWMY.E  STARTTS  - Start Time Stamp

Accumulated Data Elements

 XDWMY.E  DDYABRR  - DDF Abort Reqs Recvd From Remote
 XDWMY.E  DDYABRS  - DDF Abort Reqs Sent To Remote
 XDWMY.E  DDYBRBF  - DDF Blk Recv Using Blk Fetch
 XDWMY.E  DDYBROW  - DDF Rows In Buf for Blk Fetch
 XDWMY.E  DDYBTBF  - DDF Blk Sent Using Blk Fetch
 XDWMY.E  DDYBYTR  - DDF Bytes Recvd From Remote
 XDWMY.E  DDYBYTS  - DDF Bytes Sent To Remote
 XDWMY.E  DDYCBLB  - DDF Switch Cont To Limited
 XDWMY.E  DDYCNVQ  - DDF Conv Req Queued Waiting Alloc
 XDWMY.E  DDYCNVR  - DDF Convs Recvd From Remote
 XDWMY.E  DDYCNVS  - DDF Convs Sent To Remote
 XDWMY.E  DDYCOMR  - DDF COMMIT Reqs Recvd From Remote
 XDWMY.E  DDYCOMS  - DDF COMMIT Reqs Sent To Remote
 XDWMY.E  DDYMSGR  - DDF Messages Recvd From Remote
 XDWMY.E  DDYMSGS  - DDF Messages Sent To Remote
 XDWMY.E  DDYNTHRD - DDF SMF 100 QLST Segment Count
 XDWMY.E  DDYRBND  - DDF SQL Bound for Remote
 XDWMY.E  DDYROWR  - DDF Rows  Recvd From Remote
 XDWMY.E  DDYROWS  - DDF Rows  Sent To Remote
 XDWMY.E  DDYSQLR  - DDF SQL Stmts Recvd From Remote
 XDWMY.E  DDYSQLS  - DDF SQL Stmts Sent To Remote
 XDWMY.E  DDYTRNR  - DDF Trans Recvd From Remote
 XDWMY.E  DDYTRNS  - DDF Trans Sent To Remote

Maximum Data Elements

 XDWMY.E  DDYMABRR - Max DDF Abort Req Recvd From Remote
 XDWMY.E  DDYMABRS - Max DDF Abort Req Sent To Remote
 XDWMY.E  DDYMBRBF - Max DDF Blk Recv Using Blk Fetch
 XDWMY.E  DDYMBROW - Max DDF Rows In Buf for Blk Fetch
 XDWMY.E  DDYMBTBF - Max DDF Blk Sent Using Blk Fetch
 XDWMY.E  DDYMBYTR - Max DDF Bytes Recvd From Remote
 XDWMY.E  DDYMBYTS - Max DDF Bytes Sent To Remote
 XDWMY.E  DDYMCBLB - Max DDF Switch Cont To Limited
 XDWMY.E  DDYMCNVQ - Max DDF Conversations Queued
 XDWMY.E  DDYMCNVR - Max DDF Convers Recvd From Remote
 XDWMY.E  DDYMCNVS - Max DDF Convers Sent to Remote
 XDWMY.E  DDYMCOMR - Max DDF Commit Req Recvd From Remote
 XDWMY.E  DDYMCOMS - Max DDF Commit Req Sent To Remote
 XDWMY.E  DDYMMSGR - Max DDF Messages Recvd From Remote
 XDWMY.E  DDYMMSGS - Max DDF Messages Sent To Remote
 XDWMY.E  DDYMRBND - Max DDF SQL Bound for Remote
 XDWMY.E  DDYMROWR - Max DDF Data Rows Recvd From Remote
 XDWMY.E  DDYMROWS - Max DDF Data Rows Sent to Remote
 XDWMY.E  DDYMSQLR - Max DDF SQL Stmts Recvd From Remote
 XDWMY.E  DDYMSQLS - Max DDF SQL Stmts Sent to Remote
 XDWMY.E  DDYMTRNR - Max DDF Trans Recvd From Remote
 XDWMY.E  DDYMTRNS - Max DDF Trans Sent To Remote