Manage IMS database activity

The IMS database activity views provide a useful tool for database analysis. The views make problem recognition in an N-way data sharing environment much easier.

IMS database activity management overview

Database administrators can use the database activity views to recognize and solve problems related to:

  • I/O contention
  • Buffer pool sizes and assignments
  • Buffer cross-invalidation

While views like STRAC identify I/O at a transaction level, the database activity views provide a database perspective. The views serve as a system-wide resource, showing all:

  • DL/I calls against a database (except for MSDB and GSAM databases)
  • I/O activity for a database (except for MSDB and GSAM databases and I/O due to background write)

Note

DL/I calls and I/O activity are collected for DEDB databases if the Event Collector parameter DBFPLVL in BBPARM member IMFECP00 is set to collect DEDB statistics (the default). Database calls and I/O activity are collected for full function databases if the Event Collector parameter DBFFLVL in IMFECP00 is set to collect full function statistics (the default).

For information about IMFECP00, see Customizing-after-installation. To determine the current setting of the parameters, use the IECPSUMR view.

You can use the database activity views to analyze I/O information related to logical and physical databases. Real-time, interval, and history statistics are provided. Counts, rate, and elapsed time are reported for both DL/I calls and database I/O events.

Information in the database activities views is summarized in the following categories so that you can solve database problems that occur at different levels.

  • Data sharing group
  • System
  • Logical PCB (program control block)
  • Physical database
  • Volume
  • Buffer pool

With the database activity views, you can examine DL/I call and I/O event information at the level of the problem that is occurring. You can pick the view that corresponds to the type of information you want and the level at which you want to see the information.

Note

Only examples of real-time versions of views are used.

If a view grouped by IMS is nearly identical to a view grouped by data sharing group, only the view grouped by IMS is described.

To learn more about a view that is not described in this section, access the view by typing its name on the COMMAND line. Then position the cursor on the view name (in the window information line) and press the Help key.

Following table lists the views that group information by IMS.


View

Name

Page

Database Activity for IMS Systems, real time

IDASSUMR

Database Activity for IMS Systems, interval

IDASSUM

None

Database Activity Detail for an IMS System, real time

IDASDTLR

Database Activity Detail for an IMS System, interval

IDASDTL

None

Database Activity for Logical Databases (IMS Systems), real time

IDALSUMR

Database Activity for Logical Databases (IMS Systems), interval

IDALSUM

None

Database I/O Activity for Physical Databases (IMS Systems), real time

IDAPSUMR

Database I/O Activity for Physical Databases (IMS Systems), interval

IDAPSUM

None

Database I/O Activity for Databases/Volumes (IMS Systems), real time

IDAXSUMR

Database I/O Activity for Databases/Volumes (IMS Systems), interval

IDAXSUM

None

Database I/O Activity for Volumes (IMS Systems), real time

IDAVSUMR

Database I/O Activity for Volumes (IMS Systems), interval

IDAVSUM

None

Database Activity Detail for a VSAM Buffer Pool (IMS Systems), real time

IDABVDTR

Database Activity Detail for a VSAM Buffer Pool (IMS Systems), interval

IDABVDTL

None

Database Activity Detail for an OSAM Buffer Pool (IMS Systems), real time

IDABODTR

Database Activity Detail for an OSAM Buffer Pool (IMS Systems), interval

IDABODTL

None

Database I/O Activity for VSAM Buffer Pools (IMS Systems), real time

IDABVSMR

Database I/O Activity for VSAM Buffer Pools (IMS Systems), interval

IDABVSM

None

Database I/O Activity for OSAM Buffer Pools (IMS Systems), real time

IDABOSMR

Database I/O Activity for OSAM Buffer Pools (IMS Systems), interval

IDABOSM

None

Following table lists the views that group information by data sharing group.

View

Name

Page

Database Activity for Data Sharing Groups, real time

IDAGSUMR

None

Database Activity for Data Sharing Groups, interval

IDAGSUM

None

Database Activity Detail for a Data Sharing Group, real time

IDAGDTLR

Database Activity Detail for a Data Sharing Group, interval

IDAGDTL

None

Database Activity for Logical Databases (Data Sharing Groups), real time

IDALGSMR

None

Database Activity for Logical Databases (Data Sharing Groups), interval

IDALGSM

None

Database I/O Activity for Physical Databases (Data Sharing Groups), real time

IDAPGSMR

None

Database I/O Activity for Physical Databases (Data Sharing Groups), interval

IDAPGSM

None

Database I/O Activity for Databases/Volumes (Data Sharing Groups), real time

IDAXGSMR

None

Database I/O Activity for Databases/Volumes (Data Sharing Groups), interval

IDAXGSM

None

Database I/O Activity for Volumes (Data Sharing Groups), real time

IDAVGSMR

None

Database I/O Activity for Volumes (Data Sharing Groups), interval

IDAVGSM

None

Tip

To access online Help for a view, position the cursor on the view name (in the window information line) and press the Help key. To access help for a field, position the cursor on the field and press the Help key.

This section contains the following topics:


 

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