5. FILES › 5.15 DB2 Plan Buffer Pool Activity (DBPDBP)File › 5.15.2 Data Element List

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

 ......E  DAY      - Day of Month
 ......E  DB2ID    - DB2 ID
 ......E  DB2PID   - DB2 BUFFER POOL ID
 ......E  DB2PLAN  - Plan 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

 ......E  DAYNAME  - Name of Day of Week
 ......   DB2ACE   - DB2 Agent Control Element
 ......   DB2ATNM  - Active Trace Number Mask
 ......E  DB2AUTH  - Authorization Identifier
 ......E  DB2CONN  - Connection Identifier
 ......E  DB2CORR  - Correlation Identifier
 ......E  DB2CPU   - DB2 CPU Time
 ......E  DB2DDFCT - DDF DB2 Commits Received from Remote
 ......   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
 ......E  DB2OPID  - Original Operator ID
 ......E  DB2PTASK - Special Transaction Type Identifier
 ......   DB2REL   - DB2 Release
 ......E  DB2RELN  - DB2 Release Number
 ......E  DB2REQID - DB2 Requestor Location ID
 ......E  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

Accumulated Data Elements

 ......E  DBPCIMW  - NO. Of Immed. Sync Write I/O
 ......E  DBPGPGR  - Get Page Requests
 ......E  DBPLPF   - NO. Times LIST PREFETCH req.
 ......E  DBPPRFH  - Prefetch Read Requests
 ......E  DBPSPRU  - System Page Record Update
 ......E  DBPSRIO  - Synchronous Read IOs