Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for DBCTL 5.6.

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.

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.

Note

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

Related topic

Manage-IMS-database-activity


 

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