FILTER_DB2_SUBSYSTEM

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

Description

A list of up to 32 Db2® subsystem names (SSIDs) for which data is offloaded into tables. Data for all other Db2 subsystems are ignored. Only the records that match the specified Db2 subsystems are selected.

Syntax

FILTER_DB2_SYBSYSTEM(ssid1,ssid2,…,ssid32)

ssid1,ssid2,…,ssid32

The names of the Db2 subsystems for which you want to offload Db2 Query Monitor data. The maximum number of SSIDs that can be specified is 32.

*

Specify FILTER_DB2_SYBSYSTEM(*) to offload all SSIDs. Be aware that although FILTER_DB2_SYBSYSTEM(*) is similar to removing the FILTER_DB2_SUBSYSTEM parameter, it reduces performance.

Default

None

Example

FILTER_DB2_SYBSYSTEM(DB2_NAME1,DB2_NAME2,DB2_NAME3)