EXCPTEXT_DSN

Use the EXCPTEXT_DSN parameter in CQMPARMS to control the allocation of the EXCPTEXT Performance History File.

Description
Important: This parameter is required.
The data set name (dsn) for the EXCPTEXT Performance History File. The EXCPTEXT data set contains information related to exception hostv variables and exception SQL text. The data set name might contain valid system symbolics and also include the Db2 Query Monitor-specific 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
EXCPTEXT_DSN(dsn)
Default
None
Example
EXCPTEXT_DSN(CQM.TEST.EDATA.D&LYYMMDD..T&LHR.&LMIN..&INTV.)