DB2_SUBSYSTEM

Use the DB2_SUBSYSTEM parameter in CQM@WDB2 to control the offload of data to the Performance History Database.

Description
The target Db2® subsystem to which you want to offload Performance History Files.

If you use the DB2_SUBSYSTEM parameter, you must also specify the INTERVAL_DSN parameter to specify the interval data set name from the source Query Monitor Subsystem.

The Query Monitor Subsystem associated with the source Performance History Files does not need to be running to perform the offload. To perform an offload to an alternate Db2 subsystem on the same LPAR as the Query Monitor Subsystem, only the DB2_SUBSYSTEM parameter is required.

Either relative 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.

Syntax
DB2_SUBSYSTEM(ssid)
ssid
The Db2 subsystem ID where the Performance History Database is located. The Db2 subsystem ID you specify must be defined in the control data set specified by DB2PARMS.
Default
DSN
Example
DB2_SUBSYSTEM(SS01)