5. FILES › 5.13 DB2 Buffer Pool Activity (DBPDSB) File › 5.13.2 Data Element List

Previous Topic: 5.13.1 File Organization

Next Topic: 5.13.3 Usage Considerations

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

 X.....E  DAY      - Day of Month
 X.....E  DB2ID    - DB2 ID
 X.....E  DB2PID   - DB2 BUFFER POOL ID
 X.....E  HOUR     - Hour of Day
 X.....E  MONTH    - Month of Year
 X.....E  SYSID    - System Identifier
 X.....E  WEEK     - Week of Year
 X.....E  YEAR     - Year of Century
 X.....E  ZONE     - Time Zone

Common Data Elements

 X.....E  DAYNAME  - Name of Day of Week
 X.....E  DB2ISEQ  - Instrumentation Sequence Number
 X.....E  DB2MLVL  - MICS DB2 Maintenance Level
 X.....E  DB2REL   - DB2 Release
 X.....E  DB2RELN  - DB2 Release Number
 X.....E  DURATION - Recording Interval Time
 X.....E  ENDTS    - End Time Stamp
 X.....E  MICSVER  - CA MICS Version Number
 X.....E  STARTTS  - Start Time Stamp

Accumulated Data Elements

 X.....E  DSBABBP  - Active Buffers In Buffer Pool
 X.....E  DSBARA   - Pages Moved HPOOL to VPOOL by ADMF
 X.....E  DSBARF   - Pages Not Moved via ADMF
 X.....E  DSBAWA   - Pages Moved VPOOL to HPOOL by ADMF
 X.....E  DSBAWF   - Pages for Write Not Moved via ADMF
 X.....E  DSBBPSO  - Buffer Pool Data Set Opened
 X.....E  DSBCIO   - CASTOUT I/O OPERATIONS
 X.....E  DSBDBPR  - Physical Data Base Page Requests
 X.....E  DSBDBPU  - Data Base Page Updates
 X.....E  DSBDIO   - Async Read I/O's via Dynamic Pref.
 X.....E  DSBDMCT  - No. Times DM Critical WPHFWT reached
 X.....E  DSBDPF   - No. Times Dynamic Prefetch Req.
 X.....E  DSBDPP   - No. Async Page Reads via Dynamic Pref.
 X.....E  DSBDWRT  - No. Times Deferred Write Threshold
 X.....E  DSBDWV   - Times Vert. Defer. Write Thresh
 X.....E  DSBHBE   - HPOOL Buffers Backed by Exp. Stg.
 X.....E  DSBHPA   - Successful HPOOL Expand/Contract
 X.....E  DSBHPL   - No. Buffers Allocated for a HPOOL
 X.....E  DSBHRA   - Pages Moved Async HPOOL to VPOOL
 X.....E  DSBHRE   - Successful Sync Req HPOOL to VPOOL
 X.....E  DSBHRF   - Pages Read Failed Page Stolen
 X.....E  DSBHWA   - Pages Moved Async Vpool to HPOOL
 X.....E  DSBHWF   - Pages Write Failed Exp. Stg. Short
 X.....E  DSBHWR   - No. Req. Move Sync VPOOL to HPOOL
 X.....E  DSBIMWS  - Count of Immediate writes sys pages
 X.....E  DSBJIS   - Total No. Pref. I/O Streams Denied
 X.....E  DSBLIO   - Async Read I/O's via List Prefetch
 X.....E  DSBLPF   - List Prefetch Requested
 X.....E  DSBLPP   - Async Page Reads via List Prefetch
 X.....E  DSBMAX   - BP Not Supp Concur WK File
 X.....E  DSBMMRR  - Media Manager Read Requests
 X.....E  DSBNGT   - No. Getpage Requests Not Satisfied
 X.....E  DSBNREC  - Count of Type 100 Subtype 1 Records
 X.....E  DSBPCO   - Pages Written for Castout I/Os
 X.....E  DSBPL1   - Total Times Pref. Qty 1/2 Normal
 X.....E  DSBPL2   - Total Times Pref. Qty 1/4 Normal
 X.....E  DSBPQF   - Total Times Parallel Buf. Not Alloc
 X.....E  DSBPQO   - Total No. Parallel Queries
 X.....E  DSBREEP  - Prefetch Request Disabled no Read
 X.....E  DSBRFXS  - Read Pagefixed W/O Real Storage
 X.....E  DSBSGT   - Getpage Req. by Seq. Access Req.
 X.....E  DSBSIO   - Sync Read I/O's Seq Access Req
 X.....E  DSBSPDF  - Prefetch Request Disabled no Buffer
 X.....E  DSBSPPF  - Count Records Read Prefetch Requests
 X.....E  DSBSPWR  - System Pages Written To DASD
 X.....E  DSBSQPF  - Count Sequential Prefetch requests
 X.....E  DSBSSEF  - Storage Shortage Expansion Fails
 X.....E  DSBTMIG  - No. Migrated Dataset Encountered
 X.....E  DSBTPFB  - WK File Abort - No BP Available
 X.....E  DSBTPFC  - WK PF End - Concur PF of PAGE
 X.....E  DSBTPF0  - WK PF Abort - 0 PF QTY
 X.....E  DSBTPIO  - No. Prefetch Async Read I/Os
 X.....E  DSBTRTO  - No. Recall Timeouts
 X.....E  DSBVPA   - Successful VPOOL Expand/Contract
 X.....E  DSBVPL   - No. Buffers Allocated for a VPOOL
 X.....E  DSBWBVQ  - Pages Deq VDWQ Destr Read Rq
 X.....E  DSBWDRP  - Pages Destruct Read Req
 X.....E  DSBWFD   - Work Files Denied Sort Merge
 X.....E  DSBWFF   - Poor Sort Merge - Buf Short
 X.....E  DSBWFM   - Max WK File Alloc Sort Merge
 X.....E  DSBWFR   - Req Query WK File Sort Merge
 X.....E  DSBWFT   - Work Files Req Sort Merge
 X.....E  DSBWFXS  - Write Pagefixed W/O Real Storage
 X.....E  DSBWREE  - No. Times Write Engine unavailable
 X.....E  DSBWRMM  - Write I/Os By Media Manager
 X.....E  DSBXFL   - Buffer Not Located -- VPOOL Full
 X.....E  DSBXIS   - Max No. Concurrent Pref. Streams

Derived Data Elements

 X.....   DSBMRPR  - Media Read Req Per Phys Req
 X.....   DSBPWPU  - Page Write Per Page Update
 X.....   DSBRFRI  - Read Frames Per Read Req