- CQMPARMS volume name
- The volume name for CQMPARMS.
|
No |
Yes |
|
|
- CQMPARMS SMS storage class
- The storage class for CQMPARMS.
|
No |
Yes |
|
|
- Collector AUTHID
- The Db2 AUTHID that is used to establish a connection to
Db2 during interval processing.
|
No |
Yes |
Defaults to the user ID under which the started task will run. |
|
- Main procname
- The Support Services Address
Space
PROCNAME.
|
Yes |
Yes |
None. |
|
- Db2 Query Monitor for z/OS group
- Specifies the name (8-byte, character) of group to which this Query Monitor
Subsystem
belongs.
|
No |
Yes |
None |
|
- Db2 Query Monitor for z/OS alert limit
- The maximum number of alerts that are to be queued for the CAE
Agent
alert processor.
|
No |
Yes |
10 |
|
- Collect Db2 catalog objects
- Indicates whether or not object statistics are collected for catalog objects.
|
No |
Yes |
N |
|
- Data set full
- Instructs Db2 Query
Monitor what to do when a
backstore data set cannot be extended.
|
No |
Yes |
IGNORE |
|
- Interval
- The length of the recording interval in minutes.
|
No |
Yes |
720 |
|
- Interval midnight
- Creates intervals for which the starting times are aligned to midnight.
|
No |
Yes |
Y |
|
- Maximum SQLCODE detail
- The limit on the number of times detailed information for each occurrence of an SQLCODE is
collected.
|
No |
Yes |
0 |
|
- Maximum SQLCODES
- The limit on the number of unique SQLCODES for which information is collected.
|
No |
Yes |
0 |
|
- Maximum memory allocations
- The maximum amount of global shared memory that will be allocated by Db2 Query
Monitor
for internal Integrated Storage
Manager
spaces.
|
No |
Yes |
4096 |
|
- Collect object statistics
- Indicates whether or not to collect object statistics.
|
No |
Yes |
|
|
- Summarization OPTKEYS
- The level of granularity for summary buckets.
|
No |
Yes |
None |
|
- Interval RETAIN count
- How many prior intervals are to be retained on DASD after interval processing is complete.
|
No |
Yes |
6 |
|
- Maximum global shared memory size
- The maximum amount of global shared memory in gigabytes that are allocated by Db2 Query
Monitor
for all purposes.
|
No |
Yes |
5 |
|
- SMS data class
- The SMS data class for the allocation of the Performance History Files.
|
No |
Yes |
Null |
|
- SMS management class
- The SMS management class for the allocation of the Performance History Files.
|
No |
Yes |
Null |
|
- SMS storage class
- The SMS storage class for the allocation of the Performance History Files.
|
No |
Yes |
Null |
|
- Unit name
- The UNITNAME parameter enables you to specify an esoteric name, generic device type or a device
address for the backstore data sets.
|
No |
Yes |
Null |
|
- Volume name
- The VOLUME parameter enables you to specify a volume for the backstore data sets.
|
No |
Yes |
Null |
|
- DB2CDATA DSN mask
- The data set name for the DB2CDATA VSAM backstore data set.
|
Yes |
Yes |
None |
|
- DB2CDATA primary allocation
- The primary space quantity for the DB2CDATA Performance History
File.
|
No |
Yes |
5 |
|
- DB2CDATA secondary allocation
- The secondary space quantity for the DB2CDATA Performance History
File.
|
No |
Yes |
2 |
|
- DB2CDATA allocation space units
- The space units (CYLS or TRKS) for allocation of the DB2CDATA Performance History
File.
|
No |
Yes |
CYLS |
|
- DB2CDATA SMS data class
- The SMS data class for the DB2CDATA Performance History
File.
|
No |
Yes |
None |
|
- DB2CDATA SMS management class
- The SMS management class for the DB2CDATA Performance History
File.
|
No |
Yes |
None |
|
- DB2CDATA SMS storage class
- The SMS storage class for the DB2CDATA Performance History
File.
|
No |
Yes |
None |
|
- DB2CDATA unit name
- An esoteric name, generic device type or a device address for the DB2CDATA Performance History
File.
|
No |
Yes |
None |
|
- DB2CDATA volume name
- The volume for the DB2CDATA Performance History
File.
|
No |
Yes |
None |
|
- EXCPDATA DSN mask
- The data set name for the EXCPDATA VSAM backstore data set.
|
Yes |
Yes |
None |
|
- EXCPDATA primary allocation
- The primary space quantity for the EXCPDATA Performance History
File.
|
No |
Yes |
5 |
|
- EXCPDATA secondary allocation
- The secondary space quantity for the EXCPDATA Performance History
File.
|
No |
Yes |
2 |
|
- EXCPDATA allocation space units
- The space units (CYLS or TRKS) for allocation of the EXCPDATA Performance History
File.
|
No |
Yes |
CYLS |
|
- EXCPDATA SMS data class
- The SMS data class for the EXCPDATA Performance History
File.
|
No |
Yes |
None |
|
- EXCPDATA SMS management class
- The SMS management class for the EXCPDATA Performance History
File.
|
No |
Yes |
None |
|
- EXCPDATA SMS storage class
- The SMS storage class for the EXCPDATA Performance History
File.
|
No |
Yes |
None |
|
- EXCPDATA unit name
- An esoteric name, generic device type or a device address for the EXCPDATA Performance History
File.
|
No |
Yes |
None |
|
- EXCPDATA volume name
- The volume for the EXCPDATA Performance History
File.
|
No |
Yes |
None |
|
- EXCPHSTV DSN mask
- The data set name for the EXCPHSTV Performance History
File.
|
Yes |
Yes |
None |
|
- EXCPHSTV primary allocation
- The primary space quantity for the EXCPHSTV Performance History
File.
|
No |
Yes |
5 |
|
- EXCPHSTV secondary allocation
- The secondary space quantity for the EXCPHSTV Performance History
File.
|
No |
Yes |
2 |
|
- EXCPHSTV allocation space units
- The space units (CYLS or TRKS) for allocation of the EXCPHSTV Performance History
File.
|
No |
Yes |
CYLS |
|
- EXCPHSTV SMS data class
- The SMS data class for the EXCPHSTV Performance History
File.
|
No |
Yes |
None |
|
- EXCPHSTV SMS management class
- The SMS management class for the EXCPHSTV Performance History
File.
|
No |
Yes |
None |
|
- EXCPHSTV SMS storage class
- The SMS storage class for the EXCPHSTV Performance History
File.
|
No |
Yes |
None |
|
- EXCPHSTV unit name
- An esoteric name, generic device type or a device address for the EXCPHSTV Performance History
File.
|
No |
Yes |
None |
|
- EXCPHSTV volume name
- The volume for the EXCPHSTV Performance History
File.
|
No |
Yes |
None |
|
- EXCPINDX DSN mask
- The data set name for the EXCPINDX Performance History
File.
|
Yes |
Yes |
None |
|
- EXCPINDX primary allocation
- The primary space quantity for the EXCPINDX Performance History
File.
|
No |
Yes |
5 |
|
- EXCPINDX secondary allocation
- The secondary space quantity for the EXCPINDX Performance History
File.
|
No |
Yes |
2 |
|
- EXCPINDX allocation space units
- The space units (CYLS or TRKS) for allocation of the EXCPINDX Performance History
File.
|
No |
Yes |
CYLS |
|
- EXCPINDX SMS data class
- The SMS data class for the EXCPTEXT Performance History
File.
|
No |
Yes |
None |
|
- EXCPINDX SMS management class
- The SMS management class for the EXCPINDX Performance History
File.
|
No |
Yes |
None |
|
- EXCPINDX SMS storage class
- The SMS storage class for the EXCPINDX Performance History
File.
|
No |
Yes |
None |
|
- EXCPINDX unit name
- An esoteric name, generic device type or a device address for the EXCPINDX Performance History
File.
|
No |
Yes |
None |
|
- EXCPINDX volume name
- The volume for the EXCPINDX Performance History
File.
|
No |
Yes |
None |
|
- EXCPTEXT DSN mask
- The EXCPTEXT Performance History
File.
|
Yes |
Yes |
None |
|
- EXCPTEXT primary allocation
- The primary space quantity for the EXCPTEXT Performance History
File.
|
No |
Yes |
5 |
|
- EXCPTEXT secondary allocation
- The secondary space quantity for the EXCPTEXT Performance History
File.
|
No |
Yes |
2 |
|
- EXCPTEXT allocation space units
- The space units (CYLS or TRKS) for allocation of the EXCPTEXT Performance History
File.
|
No |
Yes |
CYLS |
|
- EXCPTEXT SMS data class
- Specifies an SMS data class for the EXCPTEXT Performance History
File.
|
No |
Yes |
None |
|
- EXCPTEXT SMS management class
- The SMS management class for the EXCPTEXT Performance History
File.
|
No |
Yes |
None |
|
- EXCPTEXT SMS storage class
- The SMS data class for the EXCPTEXT Performance History
File.
|
No |
Yes |
None |
|
- EXCPTEXT unit name
- An esoteric name, generic device type or a device address for the EXCPTEXT Performance History
File.
|
No |
Yes |
None |
|
- EXCPTEXT volume name
- The volume for the EXCPTEXT Performance History
File.
|
No |
Yes |
None |
|
- METRDATA DSN mask
- The data set name for the METRDATA Performance History
File.
|
Yes |
Yes |
None |
|
- METRDATA primary allocation
- The primary space quantity for the METRDATA Performance History
File.
|
No |
Yes |
5 |
|
- METRDATA secondary allocation
- The secondary space quantity for the METRDATA Performance History
File.
|
No |
Yes |
2 |
|
- METRDATA allocation space units
- The space units (CYLS or TRKS) for allocation of the METRDATA Performance History
File.
|
No |
Yes |
CYLS |
|
- METRDATA SMS data class
- The SMS data class for the METRDATA Performance History
File.
|
No |
Yes |
None |
|
- METRDATA SMS management class
- The SMS management class for the METRDATA Performance History
File.
|
No |
Yes |
None |
|
- METRDATA SMS storage class
- The SMS storage class for the METRDATA Performance History
File.
|
No |
Yes |
None |
|
- METRDATA unit name
- An esoteric name, generic device type or a device address for the METRDATA Performance History
File.
|
No |
Yes |
None |
|
- METRDATA volume name
- The volume for the METRDATA Performance History
File.
|
No |
Yes |
None |
|
- OBJSDATA DSN mask
- The data set name for the OBJSDATA Performance History
File.
|
Yes |
Yes |
None |
|
- OBJSDATA primary allocation
- The primary space quantity for the OBJSDATA Performance History
File.
|
No |
Yes |
5 |
|
- OBJSDATA secondary allocation
- The secondary space quantity for the OBJSDATA Performance History
File.
|
No |
Yes |
2 |
|
- OBJSDATA allocation space units
- The space units CYLS, or TRKS for allocation of the OBJSDATA Performance History
File.
|
No |
Yes |
CYLS |
|
- OBJSDATA SMS data class
- The SMS data class for the OBJSDATA Performance History
File.
|
No |
Yes |
None |
|
- OBJSDATA SMS management class
- The SMS management class for the OBJSDATA Performance History
File.
|
No |
Yes |
None |
|
- OBJSDATA SMS storage class
- The SMS storage class for the OBJSDATA Performance History
File.
|
No |
Yes |
None |
|
- OBJSDATA unit name
- An esoteric name, generic device type or a device address for the OBJSDATA Performance History
File.
|
No |
Yes |
None |
|
- OBJSDATA volume name
- The volume for the OBJSDATA Performance History
File.
|
No |
Yes |
None |
|
- SQLCDATA DSN mask
- The data set name for the SQLCDATA Performance History
File.
|
Yes |
Yes |
None |
|
- SQLCDATA primary allocation
- The primary space quantity for the SQLCDATA Performance History
File.
|
No |
Yes |
5 |
|
- SQLCDATA secondary allocation
- The secondary space quantity for the SQLCDATA Performance History
File.
|
No |
Yes |
2 |
|
- SQLCDATA allocation space units
- The space units (CYLS or TRKS) for allocation of the SQLCDATA Performance History
File.
|
No |
Yes |
CYLS |
|
- SQLCDATA SMS data class
- The SMS data class for the SQLCDATA Performance History
File.
|
No |
Yes |
None |
|
- SQLCDATA SMS management class
- The SMS management class for the SQLCDATA Performance History
File.
|
No |
Yes |
None |
|
- SQLCDATA SMS storage class
- The SMS storage class for the SQLCDATA Performance History
File.
|
No |
Yes |
None |
|
- SQLCDATA unit name
- An esoteric name, generic device type or a device address for the SQLCDATA Performance History
File.
|
No |
Yes |
None |
|
- SQLCDATA volume name
- The volume for the SQLCDATA Performance History
File.
|
No |
Yes |
None |
|
- TEXTDATA DSN mask
- The data set name for the TEXTDATA Performance History
File.
|
Yes |
Yes |
None |
|
- TEXTDATA primary allocation
- The primary space quantity for the TEXTDATA Performance History
File.
|
No |
Yes |
5 |
|
- TEXTDATA secondary allocation
- The secondary space quantity for the TEXTDATA Performance History
File.
|
No |
Yes |
2 |
|
- TEXTDATA allocation space units
- The space units (CYLS or TRKS) for allocation of the TEXTDATA Performance History
File.
|
No |
Yes |
CYLS |
|
- TEXTDATA SMS data class
- The SMS data class for the TEXTDATA Performance History
File.
|
No |
Yes |
None |
|
- TEXTDATA SMS management class
- The SMS management class for the TEXTDATA Performance History
File.
|
No |
Yes |
None |
|
- TEXTDATA SMS storage class
- The SMS storage class for the TEXTDATA Performance History
File.
|
No |
Yes |
None |
|
- TEXTDATA unit name
- An esoteric name, generic device type or a device address for the TEXTDATA Performance History
File.
|
No |
Yes |
None |
|
- TEXTDATA volume name
- The volume for the TEXTDATA Performance History
File.
|
No |
Yes |
None |
|
- Maximum host variables per alert
- The size of the storage allocation for the ALERT HOST VARIABLE SPACE inside the Query Monitor
Subsystem.
|
No |
Yes |
16 |
|
- Maximum objects per alert
- The size of the storage allocation for the ALERT EXCP OBJECTS SPACE inside the Query Monitor
Subsystem.
|
No |
Yes |
8 |
|
- Debug mode for IBM Software
Support
- Turns on Db2 Query
Monitor debug mode and produces
diagnostic messages (in the range CQM9000-CQM-9999) for
use by IBM Software
Support.
|
No |
Yes |
N |
|
- Capturing agent for IBM Software
Support
- Turns on the capturing agent. For use by IBM Software
Support.
This parameter should not be specified without the
advice of IBM Software
Support.
|
No |
Yes |
N |
|
- ISM constraint age
- Controls how much time must have passed since the last storage constraint occurrence for a given
ISM storage space before the constraint event is considered to have been relieved.
|
No |
Yes |
300 |
|
- Number of ISM error blocks
- Determines the number of ISM Error Blocks that are allocated when Db2 Query
Monitor
initializes. If this value is too low, message CQM1219W
might be issued.
|
No |
Yes |
256 |
|
- Number of ISM error message blocks
- The number of ISM Error Message Blocks that are allocated when Db2 Query
Monitor
initializes. If this value is too low, duplicate ISM
error messages may be issued for the same space and
reason instead of incrementing the occurrence
count.
|
No |
Yes |
256 |
|
- ISM error detail
- Controls whether CQM1203I and CQM1204I messages are issued to provide detailed information for
ISM Storage Constraint situations.
|
No |
Yes |
Y |
|