Database Activity Detail for a VSAM Buffer Pool (IMS Systems) view (IDABVDTR)

The Database Activity Detail for a VSAM Buffer Pool (IMS Systems) view provides information about a selected VSAM buffer pool, including definitions, specifications, utilization, and database I/O activity.

The IDABVDTR view shows buffer pool activity levels, hit ratios, the average life of a block in a buffer pool, hiperspace space utilization, and I/O statistics. The I/O statistics are for the open databases using the specified buffer pool.

IDABVDTR identifies the databases that have had activity against the buffer pool and the relative I/O expense for database blocks being read, reread, or written.

Related topic

Manage-IMS-database-activity

You can use the IDABVDTR view to optimize a buffer pool definition by checking to see if a pool needs more buffers. The view shows the current relationships of databases to the buffer pool and their current performance, and you can use that information to decide which databases need to be assigned to a separate pool.

After you make buffer pool changes, you can use the TIME command to compare your results with the results from a prior time.

You can link to the IDABVDTR view from the following views:

  • VSAM Pool ID field in the IDABVSMR view
  • Pool ID field in the IDAPSUMR and IDAXSUMR views

IDABVDTR view

  BUFFER POOL DEFINITION...            Sample Seconds.........         5      
  VSAM Pool ID.............     XXXX   IMS ID.................      I12J      
  VSAM Pool Number.........        3   IMS Name...............  I12J46CT      
  Pool Type................     DATA   MVS Name...............      SJSC      
  Buffer Fix Options.......  BFR,BLK   Data Sharing Group.....      NONE      
  Buffer Size..............     2048   Databases with I/O.....  IVPDB***      
  Number Buffers...........        5   DD Names...............  DFSIVD**      
  Number Hiperspace Buffers        0   VOLSERs................    BAB3**      
  Proclib Member........... DFSVSM1J                                          
  Proclib Section..........      N/A                                           
                                                                              
  BUFFER POOL STATISTICS...            RELATED I/O STATISTICS.                 
  Hit Ratio................   66.667   Read  I/O Rate.........     0.971       
  Average Time In Pool.....     5.15   Write I/O Rate.........     1.553       
  CI Search Rate...........    2.913   Sync  Write Rate.......     0.971       
  Retrieve by Key Rate.....    0.777   Background Write Rate..     0.583       
  Retrieve by RBA Rate.....    5.049   Buffer Steal Write Rate     0.000       
  LRECL Alter Rate.........    0.777                                           
  ESDS LRECL Insert Rate...    0.000                                           
  KSDS LRECL Insert Rate...    0.388

No hyperlinks are available on the view.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*