It is possible to set options that pertain only to individual measurements. By default, CA MAT will not issue the EXPLAIN command to request information about the access path for SQL statement. By default, it will collect SQL text from the DB2 catalog. Any of these options can be overridden for an individual monitor by specifying other values on the DB2 Monitor Criteria panel.
Requests that information regarding DB2 access path selection be obtained from DB2 SQL statements by issuing the EXPLAIN command and externalizing the data.
Specifies that DB2 EXPLAIN data is collected for all statements seen. The call for Explain data is made while the address space is being measured. If YES is specified then Use DB2 Catalog for EXPLAIN must also be YES.
Specifies that no DB2 EXPLAIN data is gathered. This is the default.
This option determines if CA MAT extracts the plan or package statements from the DB2 catalog or extracts them directly from DB2 control blocks when monitoring a DB2 application.
Specifies the collection of SQL data for each plan or package sampled or harvested from the DB2 catalog.
Specifies no collection of SQL statements from the DB2 catalog. This is the default and is recommended.
If you are using TUNCALL to define a MONITOR, the DB2EXPL and DB2CTSQL keywords correspond to the EXPLAIN SQL and Collect SQL from Catalog options respectively.
|
Copyright © 2012 CA Technologies.
All rights reserved.
|
|