Previous Topic: 5.12.1 File Organization

Next Topic: 5.12.3 DB2DPP Usage Considerations

5.12.2 DB2DPP Data Elements List


The table below identifies data elements contained in this
file.  The entries for each data element are:
 
TIMESPAN:  Defines the timespans in which the data element
           is supported.  The timespans are indicated by
           the letters "XDWMYT" as follows:
 
                  X - DETAIL
                  D - DAYS
                  W - WEEKS
                  M - MONTHS
                  Y - YEARS
                  T - TABLES AREA
                  . - File is not supported
 
 The timespan field also indicates Essential Elements with
 the letter E, if applicable.
 
 DATA ELEMENT:  The data element name.
 
 DATA ELEMENT DESCRIPTION:  The data element's long name.
 
 The timespans in which a data element is supported are
 defined by each installation when CA MICS is installed.
 Therefore, this table has been generated as part of the
 installation process to accurately reflect the CA MICS
 system at your installation.

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

 ......E  DAY      - Day of Month
 ......E  DB2CONN  - Connection Identifier
 ......E  DB2ID    - DB2 ID
 ......E  DB2PKNM  - Package/DBRM Name
 ......E  HOUR     - Hour of Day
 ......E  MONTH    - Month of Year
 ......E  SYSID    - System Identifier
 ......E  WEEK     - Week of Year
 ......E  YEAR     - Year of Century
 ......E  ZONE     - Time Zone

Common Data Elements

 ......   DAYNAME  - Name of Day of Week
 ......   DB2ACE   - DB2 Agent Control Element
 ......   DB2ATNM  - Active Trace Number Mask
 ......   DB2AUTH  - Authorization Identifier
 ......   DB2CORR  - Correlation Identifier
 ......   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
 ......   DB2DSTSN - Destination Sequence Number
 ......   DB2ISEQ  - Instrumentation Sequence Number
 ......E  DB2LOCN  - DB2 Local Location ID
 ......   DB2LUNAM - Logical Unit NAME
 ......E  DB2MLVL  - MICS DB2 Maintenance Level
 ......   DB2NETID - Network ID
 ......   DB2OPID  - Original Operator ID
 ......E  DB2PLAN  - Plan Name
 ......E  DB2PTASK - Special Transaction Type Identifier
 ......   DB2REL   - DB2 Release
 ......E  DB2RELN  - DB2 Release Number
 ......   DB2REQID - DB2 Requestor Location ID
 ......   DB2STCK  - DB2 Store Clock At End Event
 ......E  DB2THDTY - DB2 Thread Type
 ......   DB2UNIQ  - DB2 Instance Number
 ......E  ENDTS    - End Time Stamp
 ......E  MICSVER  - CA MICS Version Number
 ......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