Performance history files

Db2® Query Monitor uses a set of VSAM data sets, collectively referred to as performance history files, to store information about the Db2 subsystems it monitors.

These performance history files include:

DB2PARMS

Stores information about the monitored Db2 subsystem IDs, the Db2 parameters (including the Db2 ZPARMS member, Db2 Bootstrap DSNs, and Db2 Loadlibs), and the Db2 Query Monitor plan name.

CQMPARMS

Defines the parameters that are used by the Query Monitor subsystem.

CQMINTER

Stores information about intervals (dates, times, interval numbers) and interval processing. You can modify the parameters that control the CQMINTER performance history file by editing the INTERVAL, INTERVAL_MIDNIGHT, and EMPTY_INTERVALS parameters in CQMPARMS.

When Db2 Query Monitor starts, an interval switch occurs, new VSAM data sets are dynamically allocated, and expired data sets are deleted. The RETAIN parameter in CQMPARMS defines how many prior intervals are to be retained on DASD after interval processing is complete. This process requires DFSMS to be active.

CQMPROFS

Stores information about monitoring profiles. You can update the CQMPROFS data set using DB2 Query Monitor Main Menu Option 8 (Work with Profiles) or using QM Subsystem management in the CAE browser client.

Db2 Query Monitor uses the following performance history files to hold captured information about a system's SQL activity:

DB2CDATA

Stores information about the execution of Db2 commands. You can modify the parameters that control the DB2CDATA performance history file by tailoring the DB2CDATA_* parameters in CQMPARMS.

TEXTDATA

Stores information about summary level SQL text data. You can modify the parameters that control the TEXTDATA performance history file by tailoring the TEXTDATA_* parameters in CQMPARMS.

performance history filesMETRDATA

Stores information related to SQL call execution. You can modify the parameters that control the METRDATA performance history file by tailoring the METRDATA_* parameters in CQMPARMS.

OBJSDATA

Stores summary object level data. You can modify the parameters that control the OBJSDATA performance history file by tailoring the OBJSDATA_* parameters in CQMPARMS.

EXCPDATA

Stores information related to exception SQL calls, text, SQLCA, and host variables. You can modify the parameters that control the EXCPDATA performance history file by tailoring the EXCPDATA_* parameters in CQMPARMS.

EXCPINDX

Stores information related to statement-level exceptions. You can modify the parameters that control the EXCPINDX performance history file by tailoring the EXCPINDX_* parameters in CQMPARMS.

SQLCDATA

Stores information about SQLCODES collected during the course of an interval. You can modify the parameters that control the SQLCDATA performance history file by tailoring the SQLCDATA_* parameters in CQMPARMS.

EXCPHSTV

Stores information about exception host variable information collected during the course of an interval. You can modify the parameters that control the EXCPHSTV performance history file by tailoring the EXCPHSTV_* parameters in CQMPARMS.

EXCPTEXT

Stores information about exception SQL text collected during the course of an interval. You can modify the parameters that control the EXCPTEXT performance history file by tailoring the EXCPTEXT_* parameters in CQMPARMS.