HOSTVAR_LIMIT
Use the HOSTVAR_LIMIT parameter in CQMPARMS to control the number of host variables collected for an event.
- Description
- The maximum number of host variables (n) to be collected per event.
- If you are using Security Guardium S-TAP for Db2® on z/OS® and Db2 Query Monitor to simultaneously monitor the same Db2 subsystem, all products must have matching HOSTVAR_LIMIT settings to avoid receiving a mismatch error.
- If error message CQM1214W for HOSTV is encountered, accompanied by CQM1203I, with RC=0008, RSN=003F, increase the HOSTVAR_LIMIT setting to accommodate the collection of host variables for the monitored workload.
- Syntax
- HOSTVAR_LIMIT(n)
- Default
- 1500
- Range
- Integers in the range 1 - 99999
- Example
- HOSTVAR_LIMIT(1000)