Database I/O Activity for Volumes (IMS Systems) view (IDAVSUMR)

The Database I/O Activity for Volumes (IMS Systems) view (IDAVSUMR) provides database I/O activity information at the volume level.

You can use the IDAVSUMR view to analyze I/O information related to the volumes 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.

Related topic

Manage-IMS-database-activity

IDAVSUMR shows information about the database I/O activity that occurs to each volume. For each volume, it identifies I/O totals, rates, and average times for open databases.

The IDAVSUMR view reports DEDB database activity if the Event Collector parameter DBFPLVL is set to collect DEDB activity, but it does not report MSDB and GSAM database activity or activity caused by background write.

Note

For VSAM databases, I/O against new extents will not be attributed to a specific volume until the extended database has been closed and reopened. Until the database has been closed and reopened, the I/O will be reported as OTHER in the VolSer field.

You can hyperlink to the IDAVSUMR view from the Database Activity, Volumes option in the IMS Fast Menu (EZIFASTR), from the Volumes with I/O field in the IDASDTLR view, and from the VOLSER field in the IDAXSUMR view.

IDAVSUMR view

        Physical           Read Read    Write Write   Nonkey  Key     NonKey   
 VOLSER DBNAME    DDNAME   Rate AVG     Rate  AVG     ReadAVG ReadAVG WriteAVG
 BAB321 DB1H      DB1H1***  7.7   0.003   1.7   0.002   0.003   0.000    0.002
 BAB305 DB1H      DB1H1X    3.9   0.002   0.0   0.000   0.000   0.002    0.000

No hyperlinks are available on the view.


 

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