MAX_SQLCODE_DETAIL

Use the MAX_SQLCODE_DETAIL parameter in CQMPARMS to control the SQLCODE collection behavior of your Query Monitor Subsystem.

Description
The maximum number of times (n) detailed information for each occurrence of an SQLCODE is collected. This parameter helps you to prevent flooding of the Performance History Files with -SQLCODE events.
Notes:
  • An asterisk (*) displays in the Occurrences column on the Db2 QM SQL Code Summary panel when the MAX_SQLCODE_DETAIL value is exceeded.
  • If you want to track a high level of SQLCODE detail, consider tracking the work in exceptions.
  • The MAX_SQLCODE_DETAIL limit applies to a given interval, not the entire time the IBM® Db2 Data Access Common Collector for z/OS is running.
Syntax
MAX_SQLCODE_DETAIL(n)
Default
0
Range
Integers in the range 0 - 99999
Example
MAX_SQLCODE_DETAIL(10)