Database Activity for IMS Systems view (IDASSUMR)

The Database Activity for IMS Systems view (IDASSUMR) provides information about database I/O activity and DL/I calls for one or more IMS systems.

You can use the IDASSUMR view to analyze I/O information related to logical databases. The view helps you recognize and solve N-way data sharing problems resulting from I/O contention or buffer cross-invalidation, and it shows DL/I call and I/O event totals, rates, and average times for one or more IMS subsystems.

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

Related topic

Manage-IMS-database-activity

You can hyperlink to the IDASSUMR view from the:

  • Number of IMS Systems field in the IDAGDTLR view
  • IMS Name field in the IDAGSUMR view

IDASSUMR view

 IMS      Data     Call Call   Call   I/O  I/O   Read Read  Write Write OSAM XI
 Name     ShrGrp   Rate AVG    %I/O   Rate AVG   Rate AVG   Rate  AVG   RdRate
 IMSxxx   IMSNWAY  46.1 0.0012   90.7 48.8 0.001 48.8 0.001   0.0 0.001       0

The following hyperlinks are provided on the view:

Hyperlink from

To access

IMS Name

Database Activity Detail for an IMS System view (IDASDTLR), which provides detailed information for the selected IMS subsystem

Data ShrGrp

Database Activity Detail for a Data Sharing Group view (IDAGDTLR), which provides information about database I/O activity and DL/I calls for the selected IMS subsystem

Call Rate

Database Activity for Logical Databases (IMS Systems) view (IDALSUMR), which shows the DL/I call and I/O statistics at the logical database level for the selected IMS subsystem

I/O Rate

Database I/O Activity for Physical Databases (IMS Systems) view (IDAPSUMR), where you can see the I/O statistics at the physical database level for the selected IMS subsystem

VSAMPoolHitRatio

Database I/O Activity for VSAM Buffer Pools (IMS Systems) view (IDABVSMR), which provides database I/O activity information for the selected IMS subsystem, summarized at the VSAM buffer pool level

OSAMPoolHitRatio

Database I/O Activity for OSAM Buffer Pools (IMS Systems) view (IDABOSMR), which provides database I/O activity information for the selected IMS subsystem, summarized at the OSAM buffer pool level


 

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