5. FILES › 5.10 DB2 Plan DDF Activity (DB2DDP) File › 5.10.2 Data Element List

Previous Topic: 5.10.1 File Organization

Next Topic: 5.10.3 Usage Considerations

5.10.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  DB2CONN  - Connection Identifier
 .DWMY.E  DB2ID    - DB2 ID
 .DWMY.E  DB2PLAN  - Plan Name
 .DWMY.E  DB2RLOCN - DDF Remote Location ID
 .DWMY.E  DB2THDTY - DB2 Thread Type
 .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
 ......   DB2ATNM  - Active Trace Number Mask
 ......   DB2AUTH  - Authorization Identifier
 ......   DB2CORR  - Correlation Identifier
 .DWMY.E  DB2DDFCT - DDF DB2 Commits Received from Remote
 .DWMY.E  DB2DSGN  - Data Sharing Group Name
 ......   DB2DSTSN - Destination Sequence Number
 ......   DB2ISEQ  - Instrumentation Sequence Number
 .DWMY.   DB2LOCN  - DB2 Local Location ID
 .DWMY.   DB2LUNAM - Logical Unit NAME
 .DWMY.E  DB2MEMN  - DB2 Member Name
 .DWMY.E  DB2MLVL  - MICS DB2 Maintenance Level
 .DWMY.   DB2NETID - Network ID
 ......   DB2OPID  - Original Operator ID
 ......E  DB2RELN  - DB2 Release Number
 .DWMY.   DB2REQID - DB2 Requestor Location ID
 ......   DB2STCK  - DB2 Store Clock At End Event
 ......   DB2UNIQ  - DB2 Instance Number
 .DWMY.E  ENDTS    - End Time Stamp
 .DWMY.E  MICSVER  - CA MICS Version Number
 .DWMY.E  STARTTS  - Start Time Stamp

Retained Data Elements

 .DWM..E  DDPPRID  - DDF Product ID of Remote Location
 .DWM..E  DDPPRIDR - DDF Product ID of Remote Location
 .DWMY.E  DDPRUQL  - DDF Roll Up Flag
 .DWMY.E  DDPSRQL  - DDF Summary Roll Up Flag

Accumulated Data Elements

 .DWMY.E  DDPABRR  - DDF Abort Reqs Recvd From Remote
 .DWMY.E  DDPABRS  - DDF Abort Reqs Sent To Remote
 .DWMY.E  DDPBRBF  - DDF Received Blocks - Block Fetch
 .DWMY.E  DDPBROW  - DDF Rows in Buffer - Block Fetch
 .DWMY.E  DDPBTBF  - DDF Transmit Blocks - Block Fetch
 .DWMY.E  DDPBYTR  - DDF Bytes Recvd From Remote
 .DWMY.E  DDPBYTS  - DDF Bytes Sent To Remote
 .DWMY.E  DDPCBLB  - DDF Switch Continuous to Limited
 .DWMY.E  DDPCIEL  - DDF Max. Conversations Open
 .DWMY.E  DDPCNVA  - DDF Successful Conversations
 .DWMY.E  DDPCNVQ  - DDF Conv Req Queued Waiting Alloc
 .DWMY.E  DDPCNVR  - DDF Convs Recvd From Remote
 .DWMY.E  DDPCNVS  - DDF Convs Sent To Remote
 .DWMY.E  DDPCNVT  - DDF Conversations Terminated
 .DWMY.E  DDPCOMR  - DDF COMMIT Reqs Recvd From Remote
 .DWMY.E  DDPCOMS  - DDF COMMIT Reqs Sent To Remote
 .DWMY.E  DDPCPUR  - DDF DBAT CPU Reported To Requestor
 .DWMY.E  DDPELPL  - DDF Local Elapsed Time
 .DWMY.E  DDPELPR  - DDF Remote Elapsed Time
 .DWMY.E  DDPMSGR  - DDF Messages Recvd From Remote
 .DWMY.E  DDPMSGS  - DDF Messages Sent To Remote
 .DWMY.E  DDPNTHRD - DDF SMF 101 QLAC Segment Count
 .DWMY.E  DDPRBND  - DDF Bound SQL for Remote
 .DWMY.E  DDPROWR  - DDF Rows  Recvd From Remote
 .DWMY.E  DDPROWS  - DDF Rows  Sent To Remote
 .DWMY.E  DDPSQLR  - DDF SQL Stmts Recvd From Remote
 .DWMY.E  DDPSQLS  - DDF SQL Stmts Sent To Remote
 .DWMY.   DDPTRNR  - DDF Trans Recvd From Remote
 .DWMY.   DDPTRNS  - DDF Trans Sent To Remote

Maximum Data Elements

 .DWMY.E  DDPMABRR - Max DDF Aborts Received
 .DWMY.E  DDPMABRS - Max DDF Aborts Sent
 .DWMY.E  DDPMBRBF - Max DDF Received Blocks - Block Fetch
 .DWMY.E  DDPMBROW - Max DDF Rows in Buffer - Block Fetch
 .DWMY.E  DDPMBTBF - Max DDF Transmit Blocks - Block Fetch
 .DWMY.E  DDPMBYTR - Max DDF Bytes Received
 .DWMY.E  DDPMBYTS - Max DDF Bytes Sent To Remote
 .DWMY.E  DDPMCBLB - Max DDF Switch Continuous to Limited
 .DWMY.E  DDPMCIEL - Max DDF Conversations Open
 .DWMY.E  DDPMCNVA - Max DDF Successful Conversations
 .DWMY.E  DDPMCNVQ - Max DDF Conversations Queued
 .DWMY.E  DDPMCNVR - Max DDF Conversations Received
 .DWMY.E  DDPMCNVS - Max DDF Conversations Sent
 .DWMY.E  DDPMCNVT - Max DDF Conversations Terminated
 .DWMY.E  DDPMCOMR - Max DDF Commits Received
 .DWMY.E  DDPMCOMS - Max DDF Commits Sent
 .DWMY.E  DDPMCPUR - Max DDF DBAT CPU Reported To Requestor
 .DWMY.E  DDPMELPL - Max DDF Local Elapsed Time
 .DWMY.E  DDPMELPR - Max DDF Remote Elapsed Time
 .DWMY.E  DDPMMSGR - Max DDF Messages Received
 .DWMY.E  DDPMMSGS - Max DDF Messages Sent
 .DWMY.E  DDPMRBND - Max DDF Bound SQL for Remote
 .DWMY.E  DDPMROWR - Max DDF Rows Received
 .DWMY.E  DDPMROWS - Max DDF Rows Sent To Remote
 .DWMY.E  DDPMSQLR - Max DDF SQL Stmts Received
 .DWMY.E  DDPMSQLS - Max DDF SQL Stmts Sent