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)
Collects and reports the first 20 occurrences of a unique SQLCODE detail record.