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 | |
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.
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
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.
Related topic