Database I/O Activity for VSAM Buffer Pools (IMS Systems) view (IDABVSMR)


The Database I/O Activity for VSAM Buffer Pools (IMS Systems) view (IDABVSMR) provides database I/O activity information for VSAM databases summarized at the buffer pool level.

You can use the IDABVSMR view to analyze I/O information related to buffer pools and to recognize and solve N-way data sharing problems resulting from badly organized databases, I/O contention, buffer pool sizes and assignments, or buffer cross-invalidation.

IDABVSMR shows I/O totals, rates, and average times for all open VSAM databases.

Note

To monitor Database I/O Activity for VSAM Buffer Pools in interval time, use the Database I/O Activity for VSAM Buffer Pools interval view (IDABVSM).

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

  • VSAM Buffer Pools option in the IMS Fast Menu (EZIFASTR) and the DBCTL DBA Easy Menu (EZIDBA)
  • VSAM Wrst Hit and Buf Steal fields in the IMS Dashboard view (IMSDASSR)
  • VSAM Bufr Pool Hit Ratio field in the IDASDTLR view
  • Worst VSAM Pool Hit Ratio field in the IDAGDTLR view
  • VSAMPool HitRatio field in the IDAGSUMR and IDASSUMR views
  • IDABVSMR field in the IDABVSTR view

IDABVSMR view

                        VSAM Buffer Pools                                      
   Command:  UPD  (Create/Modify buffer pools)  IMSCMDS   (Issue IMS Commands)
   Linecmd:  U    (Modify a selected subpool)   IDABVSTR  (VSAM String Metrics)                                
                                                                            
C VSAM    Pool Bufr  Num  Srch  Hit   Hprsp HprHit AVGTime DB's     Read  Write
- Pool ID Type Size  Bufr Rate  Ratio Bufr  Ratio  InPool  with I/O Rate  Rate
  XXXX    DATA  2048    5  1.10  66.7     0   0.00   13.60 IVPDB1I    0.4  0.37
  XXXX    DATA   512    5  0.00   0.0     0   0.00       ?            0.0  0.00
  XXXX    DATA  1024    5  0.00   0.0     0   0.00       ?            0.0  0.00
  XXXX    DATA  4096    5  1.10 100.0     5   0.00       ?            0.0  0.00
  XXXX    DATA  8192    5  0.00   0.0     5   0.00       ?            0.0  0.00

The following hyperlinks are available on this view:

Link from

To access

VSAM Pool ID

Database Activity Detail for a VSAM Buffer Pool (IMS Systems) view (IDABVDTR), where you can see a detailed view of the same buffer pool

DB’s with I/O

Database I/O Activity for Databases/Volumes (IMS Systems) view (IDAXSUMR), where you can see the statistics broken down by database volume and VSAM component and where you can see more specifically where the I/O is occurring within a specific volume or VSAM component

IDABVSTR

VSAM Strings Metrics real time view (IDABVSTR)


 

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