|
|
|
As in sampling and catalog extraction, the Harvester can also obtain SQL statements. The harvested statements are from internal DB2 objects and are a more reliable source than sampling, due to the synchronous nature of the process.
There might be circumstances, however, where the harvested SQL is redundant or too voluminous to be processed efficiently. For those instances, CA Mainframe Application Tuner provides commands in the TUNSSP00 member to suppress or modify the harvesting of SQL statements.
Collect harvested SQL data.
A data record is written with the SQL found in internal DB2 control blocks for the address space being monitored. YES will produce the SQL data record each time a call to DB2 is harvested.
The following are valid responses:
YES will harvest the SQL statement.
NO will not harvest the SQL statement.
It is recommend that DB2HVSQL=YES be used.
The default is DB2HVSQL=YES.
Collect dynamic SQL data if DB2HVSQL=NO.
A data record is written with the dynamic SQL found in the internal DB2 control blocks for the address space being monitored.
The following are valid responses:
YES will collect the dynamic SQL data records.
NO will not collect the dynamic SQL data records.
The default is DB2HVDYN =NO.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |