Database Activity for Logical Databases (IMS Systems) view (IDALSUMR)

The Database Activity for Logical Databases (IMS Systems) view (IDALSUMR) provides statistics about the activity of logical databases.

You can use the IDALSUMR view to analyze database I/O and DL/I call information related to logical databases and to recognize and solve N-way data sharing problems resulting from badly organized databases, buffer cross-invalidation, or I/O contention.

The IDALSUMR view shows totals, rates, and averages for DL/I calls and I/O events. Statistics are for each open database associated with a PCB (program control block) against which DL/I calls have been made.

The database named in a PCB can be either a physical database or a logical database. Rows in the IDALSUMR view that report on logical databases may include I/O statistics for one or more physical databases.

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

Related topic

Manage-IMS-database-activity

You can hyperlink to the IDALSUMR view from the:

  • Databases with calls field in the IDASDTLR view
  • Call Rate field in the IDASSUMR view

IDALSUMR view

 PCB      Physical Call Call    Call   Call  I/O  I/O   Read Read  Write Write
 DBNAME   DBNAME   Rate AVG     %I/O   I/Os  Rate AVG   Rate AVG   Rate  AVG   
 DB1H     DB1H     125. 0.00064 20.3    0.10 13.7 0.001 11.9 0.001   1.8 0.001

No hyperlinks are available on the view.


 

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