Using the Product in a DB2 Environment › Background DB2 Catalog Extraction › Synchronous Data Gatherer › Summary of DB2 Customization Parameters

Summary of DB2 Customization Parameters

The collection of DB2 data during a monitor is controlled by two sets of options:

• Global options set in the UTRSAMP TUNSSP00 member that are in effect for all profiles.
• Monitor specific options that can be set in the DB2 Monitor Criteria panel when a monitor profile is defined. These options would be in effect only for the monitor session associated with the profile.

The DB2 parameters in TUNSSP00 are designed to be hierarchical in nature. The concept is that the administrator of CA MAT can determine the site’s preference for how the data should be collected.

Select one the following methods:

• Sampling by using the standard sampling architecture
• Interception of data from DB2 by using the Harvester

The data collected with the Sampler is based only on active or waiting samples as the samples are taken during the monitor session. Therefore, you see active and waiting sample percentages on the DB2 displays.

The data collected with the Harvester is based on statistics that are maintained and managed by the DB2 subsystem itself. This data includes (but is not limited to) such things as CPU time, counts of the times an SQL statement is executed, buffer counts, and so on.

Data can also be collected by the Sampler and the Harvester at the same time.

The administrator can then determine how granular the data needs to be. Is there a need for thread, or operator or location information? If so, set the appropriate options listed in the section Synchronous Data Gatherer.

If Explain information is necessary for either the sampled SQL, the harvested SQL, or both, set the appropriate Explain options listed in the section DB2 Monitor Profile Options.

More information:

Synchronous Data Gatherer