DB2_SQLCODE_DUPLICATES
Use the DB2_SQLCODE_DUPLICATES parameter in CQMPARMS to control the SQLCODE detail record collection behavior of your Query Monitor Subsystem.
- Description
- Limits the number of unique SQLCODE detail records that Db2 Query Monitor collects and reports for a Db2 subsystem. After the first n unique occurrences of any SQLCODE are collected and reported, no additional detail records are collected for the Db2 subsystem until either the end of the interval or the end of the window, defined by the DB2_SQLCODE_DUPLICATES_TIME parameter. 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.
- Syntax
- DB2_SQLCODE_DUPLICATES(n)
- Default
- 0
- Range
- Integers in the range 0 - 99999
- Example
- DB2_SQLCODE_DUPLICATES(200)
Report the first 200 occurrences of a unique SQLCODE detail record.