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 that Db2 Data Access Common Collector is running.
- Syntax
- MAX_SQLCODE_DETAIL(n)
- Default
- 0
- Range
- Integers in the range 0 - 99999
- Example
- MAX_SQLCODE_DETAIL(10)