5. FILES › 5.12 DB2 Package/DBRM Activity (DB2DPP) File › 5.12.2 DB2DPP Data Elements List
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