SQL Performance uses IBM z/OS Enclave services, which also allows z/OS Workload Manager (WLM) to assign performance goals to the SQL Performance unload process that runs in the DBC address space. Using WLM, you can assign a different service class for the unload enclave. This lets you prioritize the work of the unload process within the scope of the system, independent of the DBC address space priority.

The SQL Performance enclave starts when DB2 monitoring starts (during the APPON process) and remains active until the monitoring session ends. The unload process runs at each user-defined interval. Therefore, only single period velocity goals are appropriate.

From the Classification Rules panel inside the WLM definition, you can create a new subsystem type, BMCS, to assign a service and reporting class to the SQL Performance (APPTUNE) unload process. You can define the enclave with the process name, APTUssid, where ssid represents the DBC subsystem ID. If no WLM definitions exist for the BMCS subsystem type, all unload work runs at the priority of the DBC address space.

Warning

If an enclave is assigned to a discretionary or very low priority goal, the time to complete the unload process might increase to a large extent. This might lead to higher virtual storage consumption in the DB2 DBM1 address space. If the time increases excessively, APPTUNE monitoring for the DB2 subsystem might stop.

You must define the process name in all capital letters in the WLM.

Important

You can change the subsystem type value (BMCS) to any four-character value if required. For more information about how to change this value, see the BMC Infrastructure Components Administration documentation and the WLM keyword.

Creating WLM definitions

1. From the WLM Definition menu, select option 6 for Classification Rules.
2. Create a new BMCS subsystem type for the definition.
3. To further delineate the definition, specify the process name in the definition with the PC WLM qualifier code.

The following example shows the WLM panel used to create these definitions.

 Create Rules for the Subsystem Type Row 1 to 3 of 3
Command ===> ___________________________________________ Scroll ===> CSR
Subsystem Type BMCS (Required) Fold qualifier names? Y (Y or N)
Description . . . BMC DBC
Action codes: A=After C=Copy M=Move I=Insert rule B=Before D=Delete row R=Repeat IS=Insert Sub-rule More ===> --------Qualifier-------- -------Class-------- Action Type Name Start Service Report DEFAULTS: STCNRM STORMGMT ____ 1 PC APTUDBC1 STCNRM ________