DB2_SQLCODE_DUPLICATES_TIME
Use the DB2_SQLCODE_DUPLICATES_TIME parameter in CQMPARMS to control the SQLCODE collection behavior of your Query Monitor Subsystem.
- Description
- The time in minutes (n) after which Db2 Query Monitor resumes SQLCODE collection for a Db2 subsystem after being suspended when the DB2_SQLCODE_DUPLICATES limit is reached. When the DB2_SQLCODE_DUPLICATES_TIME is reached, SQLCODE collection resumes when the next SQLCODE is encountered.
- Syntax
- DB2_SQLCODE_DUPLICATES_TIME(n)
- Default
- 0
- Range
- Integers in the range 0-99999
- Example
- DB2_SQLCODE_DUPLICATES_TIME(60)
Db2 Query Monitor resumes SQLCODE collection again for a Db2 subsystem after 60 minutes has passed and the next SQLCODE has been encountered.