Database I/O Activity for Physical Databases (IMS Systems) view (IDAPSUMR)

The Database I/O Activity for Physical Databases (IMS Systems) view (IDAPSUMR) provides information about database I/O activity at the physical database level.

You can use the IDAPSUMR view to analyze I/O information related to physical databases 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. The view shows I/O event totals, rates, and average times for open databases and buffer pool information.

Related topic

Manage-IMS-database-activity

The IDAPSUMR 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.

Important

For VSAM databases, the Num Vols field in some cases may not reflect the actual number of volumes occupied by a specific database. The number of volumes shown can be less than the actual number of volumes if the database has been extended into more than one new volume and has not subsequently been closed and reopened.

If a database is extended into only one new volume, the value shown in the Num Vols field will be accurate, even if that database has not been subsequently closed and reopened.

You can hyperlink to the IDAPSUMR view from the:

  • Database Activity, Databases option in the IMS Fast Menu (EZIFASTR)
  • Database I/O Activity option in the DBCTL DBA Easy Menu (EZIDBA)
  • Databases with I/O field in the IDASDTLR view
  • I/O Rate field in the IDASSUMR view
  • Physical DBNAME field in the IDALSUMR view

IDAPSUMR view

 Physical Database Area/              Num    Read Read  Write Write Pool Pool   
 DBNAME   Type     Partition DDNAME   Vols   Rate AVG   Rate  AVG   ID   Type   
 DB1H     PHIDAM   DB1H1     DB1H1A        1  6.3 0.001   0.0 0.000 OSM4 OSAM   
 DB1H     PHIDAM   DB1H2     DB1H2A        1  4.7 0.001   0.0 0.000 OSM4 OSAM   
 DB1H     PINDEX   DB1H2     DB1H2X        1  4.7 0.001   0.0 0.000 XXXX VSM-D  
 DB1H     PINDEX   DB1H1     DB1H1X        1  4.7 0.001   0.0 0.000 XXXX VSM-D

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

Num Vols

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

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*