Configuration Best Practices › DB2 Configuration Best Practices › Defining the Size of the Internal Table

Previous Topic: Setting the Granularity of SQL Statements

Next Topic: Parameter Recommendations When Using Performance Management Assistant

Defining the Size of the Internal Table

We recommend setting DB2HVSUM to 300. This parameter defines the size of the internal table that is used by CA Mainframe Application Tuner to aggregate the performance metrics of SQL statements by the DB2 Harvester.

Business Value:

Defining the size of an internal table for the aggregation of the performance metrics for SQL statements by the DB2 Harvester reduces overhead.

Additional Information:

The recommended value of 300 is a good compromise but needs to be monitored depending on the volume of DB2 data gathered. If the size is too small, the result is an increased size to the monitor data set. If the number is too high, this may lead to additional storage usage during measurements and higher table search overhead.