MAX_SQLCODES
Use the MAX_SQLCODES parameter in CQMPARMS to control the SQLCODE collection behavior of your Query Monitor Subsystem.
- Description
- The maximum number of unique SQLCODES (n) for which performance data is collected. The limit defined by the MAX_SQLCODES parameter applies to a given interval, not the entire time the IBM® Db2 Data Access Common Collector for z/OS is running. If MAX_SQLCODES is set to 0 (the default), SQLCODE collection and display is disabled.
- Syntax
- MAX_SQLCODES(n)
- Default
- 0
- Range
- Integers in the range 0 - 99999
- Example
- MAX_SQLCODES(100)