Skip to Content

Display of hostvars on exceptions and SQL errors

From the filter panel you can select to show hostvars on exceptions and SQL errors. The following table describes the options for host variables and SQL errors.

Related topic

Specifying options for a filter option set

 

Option

Description

Show host variables

Specify whether to collect host variable values for exception records and SQL errors.

Valid values are Y (Yes) and N (No).

To view the collected host variable values, see the Exceptions—SQL Text report (SQMCACTE). (To see the report, select the Workload Analysis option from the SQL Workload Analysis Menu.) Zoom from the Exception Analysis report (SQMCACEX).


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Common Db2 documents 13.1