Monitoring tools for Db2 data sharing

z/OS Resource Measurement Facility (RMF) reports

The z/OS Resource Measurement Facility (RMF) provides single system and Parallel Sysplex® views by reporting on collected resource usage data

• The Sysplex Summary report provides an integrated view of the entire Parallel Sysplex on one screen.
• The Response Time Distribution report contains details about the distribution of response times on a Parallel Sysplex level and includes the capability of zooming into a single system that indicates problems.
• The Coupling Facility reports include information about storage allocation, structure activity, and subchannel activity which allows you to plan for better resource utilization. For an example report, see Group buffer pool monitoring with the coupling facility activity report of RMF
• The Shared Device report provides information about how disks and tape resources are shared among the different systems in the Parallel Sysplex.

Db2 trace

Db2 writes trace records to help you monitor events in the data sharing group. Many trace classes include information about locking and use of the group buffer pool. For more information about Db2 trace, see Db2 trace.

IBM OMEGAMON for Db2 Performance Expert on z/OS

IBM OMEGAMON for Db2 Performance Expert on z/OS can monitor the use of shared Db2 resources such as the catalog and directory, group buffer pools, databases for entire data sharing groups, and databases for individual members of the group. For more information, see Tivoli OMEGAMON XE for Db2 Performance Expert on z/OS .

• Reports and traces with member scope present instrumentation for each member of the data sharing group, without merging the data. These reports and traces are similar to those generated in a non-data-sharing environment, where each report or trace is produced for an individual Db2 subsystem.
• Reports and traces with group scope merge instrumentation data for individual members and present the data for the entire data sharing group. The traces show events in chronological order and indicate which member is reporting the event, and the reports show events summarized for the entire group.

Group-scope reporting is also available in exception processing and graphics: you can define exception thresholds for groups, and you can create graphs showing performance trends for an entire data sharing group.

With IBM OMEGAMON for Db2 Performance Expert on z/OS , you can have processor times reported in service units. This allows times from different central processor complex (CPC) models in the group to be normalized before they are reported.