METRDATA_DSN
Use the METRDATA_DSN parameter in CQMPARMS to control the allocation of the METRDATA performance history file.
- Description
- Important: This parameter is required.The data set name (dsn) for the METRDATA performance history file. The METRDATA data set contains summary level information related to SQL call execution. The METRDATA data set is written at interval expiration. The data set name might contain valid system symbols and may also include the Db2 Query Monitor symbol &INTV (the &INTV symbolic resolves to the current interval number).Tip:
- Use the &INTV symbolic when you define this parameter to ensure that the performance history file names that are generated by Db2 Query Monitor are unique.
- Use the full local date format (date, hour, minute, interval number) to ensure that fully qualified data set names are generated. This avoids the allocation of duplicate data set names during interval switch processing.
- Data set names must not resolve to more than 38 bytes because the system appends ".DATA" and ".INDEX" to the VSAM data and index components.
- Syntax
- METRDATA_DSN(dsn)
- Default
- None
- Example
- METRDATA_DSN(CQM.TEST.METRD.D&LYYMMDD..T&LHR.&LMIN..&INTV.)