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

The Database I/O Activity for Databases/Volumes (IMS Systems) view (IDAXSUMR) provides information about database I/O activity at the database volume level and the VSAM component level.

You can use the IDAXSUMR view to analyze I/O statistics as they relate to the physical database volumes, and in the case of VSAM, as they relate to specific VSAM database components. You can also use the view 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

IDAXSUMR summarizes information by database, with one row for each volume that the database occupies. A database that occupies more than one volume will have as many lines as it has volumes. The view shows I/O totals, rates, average times, and buffer pool information.

The IDAXSUMR 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 IDAXSUMR view from the:

  • Database Activity I/O Rate fields in the IMS Dashboard view (IMSDASSR)
  • Database Activity options in the DBCTL Dashboard Menu (DBCMDASH)
  • Physical DBNAME field in the IDAVSUMR and IDABSUMR views
  • Databases with I/O field in the IDABOSMR, IDABVDTR, IDABODTR views
  • Num Vols field in the IDAPSUMR view

IDAXSUMR view

 Physical Database Area/                           Read Read  Write Write Pool
 DBNAME   Type     Partition DDNAME   Type  VOLSER Rate AVG   Rate  AVG   ID   
 DB1H     PHIDAM   DB1H1     DB1H1A   OSAM  BAB321  4.9 0.001   0.0 0.000 OSM4
 DB1H     PHIDAM   DB1H2     DB1H2A   OSAM  BAB321  3.7 0.001   0.0 0.000 OSM4
 DB1H     PINDEX   DB1H2     DB1H2X   VSM-D BAB305  3.7 0.001   0.0 0.000 XXXX

The following hyperlinks are provided on the view:

Hyperlink from

To access

Physical DBNAME

Database Overview view (IDBSUMR), which shows database status and provides commands for database management

VOLSER

Database I/O Activity for Volumes (IMS Systems) view (IDAVSUMR), where you can see statistics for all I/O to this volume, not just to this database, and where you can see how much of the I/O total is occurring to the volume

Pool ID

Database Activity Detail for a VSAM Buffer Pool (IMS Systems) view (IDABVDTR) for VSAM databases or Database Activity Detail for an OSAM Buffer Pool (IMS Systems) view (IDABODTR) for OSAM databases, which show buffer pool activity for the selected buffer pool


 

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