SB_SSA_DB2AUTOFILTER_SETTING

Description:
The Strobe DB2AUTOFILTER parameter specifies whether Strobe automatically adds a filter to the Db2 trace started by Strobe's SQL Agent when capturing SQL results.

Reason for the Check:
Turning on this option decreases the overhead placed on the Db2 address space by the trace that the Strobe SQL Agent starts. We recommend setting this parameter to YES. This check is only applicable when Strobe parameter SSA is set to YES.

Parameters Accepted:
No

User Override of BMC Values:
No

Debug Support:

No

Verbose Support:
No

Reference:
For more information, see DB2AUTOFILTER=YES.

Messages:
This check issues the following exception messages:

  • STRKH01I (Successful)
  • STRKH02E (Exception)

Output:
When successful, the SB_SSA_DB2AUTOFILTER_SETTING check produces the report shown in the following figure.

Sample SB_SSA_DB2AUTOFILTER_SETTING Successful Report

image2021-2-3_10-26-26.png

When the DB2AUTOFILTER setting is not at the recommended value, SB_SSA_DB2AUTOFILTER_SETTING check produces the report show in the following figure.

Sample SB_SSA_DB2AUTOFILTER_SETTING Exception Report

image2021-2-3_10-27-48.png

 

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