CQM_SUBSYSTEM

Use the CQM_SUBSYSTEM parameter in CQM@WDB2 to control the offload of data to the performance history database.

Description

The source Query Monitor subsystem (qmid) from which data is offloaded. This parameter is only valid for the CQM@WDB2 program. The Query Monitor subsystem associated with the source performance history files does not need to be running to perform the offload. Either a relative interval range or a specific range of intervals can be offloaded. For a relative interval range, the -1 interval is considered to be the last written interval that is contained in the interval data set. If you want to load data from Db2® Query Monitor that is on another LPAR, use the INTERVAL_DSN parameter to specify the interval data set name from the source Query Monitor subsystem.

Syntax

CQM_SUBSYSTEM(qmid)

Default

DBQM

Example

CQM_SUBSYSTEM(QM01)