THREAD_SQLCODE_DUPLICATES
Use the THREAD_SQLCODE_DUPLICATES parameter in CQMPARMS to control the SQLCODE collection behavior of the Query Monitor Subsystem.
- Description
- Limits the number of unique SQLCODE detail records (n) that Db2 Query
Monitor collects and reports for a thread. After the first
n unique occurrences of any SQLCODE are collected and reported, no additional
detail records are collected for a thread until either the end of the interval or the end of the
window defined by the THREAD_SQLCODE_DUPLICATES_TIME parameter.Note:
- The MAX_SQLCODES and MAX_SQLCODE_DETAIL parameters affect the collection of events by defining the maximum number of SQLCODES and DETAIL records that can be collected during the interval.
- One detail record is collected for the first occurrence of every SQLCODE even if the THREAD_SQLCODE_DUPLICATES limit is exceeded.
- Syntax
- THREAD_SQLCODE_DUPLICATES(n)
- Default
- 0
- Range
- Integers in the range 0 - 99999
- Example
- THREAD_SQLCODE_DUPLICATES(20)