Warehouse workload management — Underlying work class set and work action set

InfoSphere™ Warehouse Workload Manager uses one work class set that is named DS_WORK_CLASS_SET, and a corresponding work action set that is named DS_WORK_ACTION_SET.

The work classes and work actions in these sets use the estimated cost limits to prioritize database activities by cost. The work classes and work actions also route the DDL and LOAD activities to the priorities that you specify, and automatically route the CALL activities to the service subclass where they run.

The work classes in DS_WORK_CLASS_SET categorize work by the type characteristics. Each work action in DS_WORK_ACTION_SET applies the mapping action to the type of work that the corresponding work class identifies. The work action set supports work actions of the mapping type only.

Table 1. Underlying work classes and the corresponding work actions
Work classes in DS_WORK_CLASS_SET	Activity types of work classes	Work actions in DS_WORK_ACTION_SET	Explanation of work actions
DS_LOW_COST_DML_WC	DML within the low cost limits	DS_MAP_LOW_COST_DML_WA	Maps low cost DML to the DS_HIGH_PRI_SUBCLASS service subclass
DS_MED_COST_DML_WC	DML within the medium cost limits	DS_MAP_MED_COST_DML_WA	Maps medium cost DML to the DS_MED_PRI_SUBCLASS service subclass
DS_HIGH_COST_DML_WC	DML within the high cost limits	DS_MAP_HIGH_COST_DML_WA	Maps high cost DML to the DS_LOW_PRI_SUBCLASS service subclass
DS_CALL_WC	CALL	DS_MAP_CALL_WA	Maps CALL activities to the DS_CALL_SUBCLASS service subclass
DS_DDL_WC	DDL	DS_MAP_DDL_WA	Maps DDL to the service subclass of the specified priority (DS_HIGH_PRI_SUBCLASS, DS_MED_PRI_SUBCLASS, or DS_LOW_PRI_SUBCLASS)
DS_LOAD_WC	LOAD	DS_MAP_LOAD_WA	Maps LOAD activities to the service subclass of the specified priority (DS_HIGH_PRI_SUBCLASS, DS_MED_PRI_SUBCLASS, or DS_LOW_PRI_SUBCLASS)
DS_OTHER_WC	Utilities such as REORG and RUNSTATS	DS_MAP_OTHER_WA	Maps utility type activities to the DS_LOW_PRI_SUBCLASS service subclass