Db2 response time solution (DB2RESP)

Because transaction response time for all CICS, IMS, and TSO users relies on the Db2 system's ability to reply to requests in the shortest possible time, it is important to obtain data about Db2 response time as early as possible.

Related topic

Db2-performance-management-solutions

This solution examines several BMC AMI Ops Monitor for Db2 (DMR) services for potential performance problems by comparing the observed values to user-defined thresholds and by reporting any observations that are above threshold levels.

DB2RESP is initiated by certain warning messages for elapsed and CPU time monitors or invoked directly by the operator.

The usefulness of this solution depends in large part on the thresholds chosen, so these must be chosen carefully. BMC has supplied defaults with this solution, but you may want to make some modifications to fit your installation.

In the process of determining your installation thresholds, you should become aware of the BMC AMI OpsM for Db2 data items that are good performance indicators for your system.

This solution requires the DB2INIT and DMRUTIL solutions.

This section contains the following topics:

 

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