Previous Topic: Background DB2 Catalog Extraction

Next Topic: Limit Harvested SQL

Synchronous Data Gatherer

The third method of data collection that CA Mainframe Application Tuner uses is the Synchronous Data Gatherer.

Data is collected (harvested) on each call to DB2 at a point when processing of the statement is near completion.

The harvested information is more reliable than sampling because data collection occurs at the same point for each call and after all DB2 objects have been fully populated.

The Synchronous Data Gatherer is activated by an entry in the TUNSSP00 member.

DB2HRVST

Synchronous Data Gatherer activation.

During initialization of the Server, this parameter prepares the environment for the Harvester to accept START and STOP exit commands.

When the DB2 Harvesters are in place, absolute DB2 counts, CPU time, and elapsed times are gathered.

The following are valid responses:

YES activates the DB2 Harvester facility and allows CA Mainframe Application Tuner to gather data.

NO prevents the activation of the DB2 Harvester facility and CA Mainframe Application Tuner will not gather data.

The default is DB2HRVST=NO (for no DB2 support).

Recommendation: When customizing for DB2 support, set this value to YES.