THREAD_SQLCODE_DUPLICATES_TIME

Use the THREAD_SQLCODE_DUPLICATES_TIME parameter in CQMPARMS to control the SQLCODE collection behavior of the Query Monitor Subsystem.

Description: The time in minutes (n) after which Db2 Query Monitor can resume SQLCODE collection for a thread, suspended when the THREAD_SQLCODE_DUPLICATES limit was reached. Collection resumes when the next SQLCODE is encountered.
Syntax: THREAD_SQLCODE_DUPLICATES_TIME(n)
Default: 1440
Range: Integers in the range 0 - 99999
Example: THREAD_SQLCODE_DUPLICATES_TIME(10); Db2 Query Monitor resumes SQLCODE collection for a thread after 10 minutes has passed and the next SQLCODE has been encountered.