Configuration Best Practices › DB2 Configuration Best Practices › Using DB2 Harvester to Collect Detailed DB2 Information

Previous Topic: DB2 Configuration Best Practices

Next Topic: Getting Information about the Acces Path Chosen by DB2

Using DB2 Harvester to Collect Detailed DB2 Information

We recommend using the DB2 Harvester (DB2HRVST=YES) to collect detailed DB2 information.

Business Value:

CA Mainframe Application Tuner is a sampling-based data collector for z/OS-based applications that measures delays incurred by an application program. You can use the DB2 Harvester technology to gather additional DB2 run-time statistics such as Total CPU, Total Response Time, Get Pages, and so forth. This extra DB2 data can provide useful information about the SQL activity, allowing you to make more informed decisions.

Additional Considerations:

Setting DB2HRVST to YES requires changes to the parameters DB2CTSQL and DB2SPSQL.