HOSTVAR_LIMIT
Use the HOSTVAR_LIMIT parameter in CQMPARMS to control the amount of storage allocated for host variables.
- Description
- The maximum amount of storage (n) to be allocated for host variable
collection per event.Note:
- 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 CQM1203I is encountered, 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)