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 Db2® Data Access Common Collector 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)