Enabling Performance Expert Agent for DB2 Connect Monitoring support

The Performance Expert Agent for Db2 Connect Monitoring monitors connections of remote applications within the Distributed Relational Database Architecture™ (DRDA) of DB2 that are connected through DB2. It is installed on the DB2 Connect Server gateway and provides DB2 Connect data for the OMEGAMON Collector.

Before you begin

You must enable Performance Warehouse before beginning. See Enabling Performance Warehouse for more information.
Tip: If you do not want to use Performance Warehouse for purposes other than DB2 Connect Monitoring, you can enable it a single time, verify that the OMEGAMON Collector has created the Performance Warehouse tables, and then disable it. If you disable Performance Warehouse, you must enable it again before you install a PTF that indicates that in the ++HOLD. Otherwise, the necessary changes to the Performance Warehouse database are not made. This might result in SQL errors.

About this task

If you are installing or configuring OMEGAMON for Db2 Performance Expert in a data sharing environment, you might need to alter configuration of certain components. Consider the following configurations for a data sharing environment:
  • Monitor one member of a data sharing group. This configuration is sufficient in most data sharing environments, even when the members reside on different LPARS in a sysplex environment.
  • Monitor two or more members of a data sharing group. To enable DB2 Connect Monitoring, you have to enable Snapshot History and activate the collection of DB2 Connect Monitoring data. You can enable that for two or more members of a data sharing group. However, consider the following effects:
    • DB2 Connect Monitoring data is collected and stored for only one member of the data sharing group. Monitoring is started first for this DB2 subsystem.
    • The user interfaces must connect to the member for which DB2 Connect Monitoring data is collected and stored. Otherwise, they cannot display DB2 Connect Monitoring data.
    • If the monitoring for the DB2 subsystem, for which the DB2 Connect Monitoring data was collected, is stopped, and you have enabled DB2 Connect Monitoring for two or more members of a data sharing group, then data collection for another member takes over. Ensure to reconnect the user interface to this member to display DB2 Connect Monitoring data.

Procedure

  1. Set parameter KD2_PFxx_SH_D2SHKHST to Y.
  2. Set parameter KD2_PFxx_DCM_D2SHDCAP to Y.

What to do next

  1. After you have enabled Performance Expert Agent for Db2 Connect Monitoring support, you must install Performance Expert Agent for Db2 Connect Monitoring on the system hosting a DB2 Connect gateway. See Installing Performance Expert Agent for DB2 Connect Monitoring for more information.