- 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. |
|
- Master procname
- The
master address space
PROCNAME.
|
Yes |
Yes |
CQMMST34 |
|
- 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 files.
|
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 |
|
- OMEGAMON Data Provider Store Name
- The name of the ODP store.
|
No |
Yes |
OMEGAMON |
|
- OMEGAMON Data Provider Broker Name
- The name of the ODP broker.
|
No |
Yes |
ODP_BROKER |
|
- Publish Interval metrics to ODP
- Indicates whether to publish interval metrics to
ODP.
|
No |
Yes |
N |
|
- Publish Summary metrics to ODP
- Indicates whether to publish summary metrics to
ODP.
|
No |
Yes |
N |
|
- Publish SQLCODES metrics to ODP
- Indicates whether to publish SQLCODE metrics to
ODP.
|
No |
Yes |
N |
|
- Publish Exceptions metrics to ODP
- Indicates whether to publish exception metrics to
ODP.
|
No |
Yes |
N |
|