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)