If you are monitoring a DB2 job, you can select the DB2 field to display the DB2 Monitoring Criteria panel.
CA MAT ----------------- DB2 Monitoring Criteria ----------------- COMMAND ===> For DB2 SQL Statements: Explain SQL: NO (YES or NO) Collect SQL from Catalog: YES (YES or NO) Press END to return to Monitoring Criteria
The fields in the DB2 Monitoring Criteria panel are described next.
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.
Use this option to determine whether or not CA MAT should extract the plan or package statements from the DB2 catalog or extract them directly from DB2 control blocks when monitoring a DB2 application. Suppressing the collection of the SQL statements from the DB2 catalog can result in the incorrect statement being identified during the sample process.
Indicates that SQL data is collected for each plan or package sampled or harvested from the DB2 catalog. This is the default and is recommended.
Indicates that the SQL statement is not collected from the DB2 catalog.
If EXPLAIN SQL is YES then the Use DB2 Catalog for EXPLAIN is forced to YES (in case, the value was NO previously) because the DB2 Catalog must be accessed to collect EXPLAIN data.
|
Copyright © 2012 CA Technologies.
All rights reserved.
|
|