Monitoring profile parameters

A monitoring profile is a set of configuration values that, when associated with a Db2 subsystem, controls the monitoring functions associated with the Db2 subsystem. If you have multiple Db2 subsystems with the same monitoring requirements, you can use the same monitoring profile for all of the Db2 subsystems. Monitoring profiles are reusable for Db2 subsystems that reside different LPARs and allow you to make changes to monitoring functionality without having to reconfiguring multiple individual Db2 subsystems.

As the runtime members for a Db2 subsystem depend on the configuration values of the monitoring profile as well as the configuration values of the Db2 subsystem itself, the creation of the runtime members requires two steps. The first step creates the profile members, where all values that are specific to the Db2 subsystem are substituted by variables, and writes them to &rhilev.&rte.RKD2PRF. The second step replaces these variables with the actual configuration values of the Db2 subsystem and writes the members to &rhilev.&rte.RKD2SAM and &rhilev.&rte.RKD2PAR.

Table 1. Monitoring functions and parameter sets
For these monitoring functions: Configure the parameters listed in these parameter sets:
Object analysis KD2_PFnn_OA - Object analysis
Periodic exception processing KD2_PFnn_AEXCP - Periodic exception processing
Thread history KD2_PFnn_THRDHIS - Thread history
Snapshot history KD2_PFnn_SH - Snapshot history
Db2 Explain KD2_PFnn_EX - Db2 Explain
Db2 SQL Performance Analyzer KD2_PFnn_SQLPA - Db2 SQL Performance Analyzer
Db2 traces KD2_PFnn_TRACES - Db2 traces
Additional monitoring features KD2_PFnn_ACS - Monitoring
KD2_PFnn_READA - Monitoring