It is important to define Workload Manager (WLM) performance goals in such a way that the
WLM service class for the Data Gate stored
procedures can provide enough additional WLM address spaces in a timely manner when
needed.
Before you begin
Important: If you have installed IBM® Db2® Analytics Accelerator
for use with the same Db2
for z/OS system, you
already have a WLM environment and performance goals for the Data Gate stored procedures. In this case, you can skip
this task.
About this task
Data Gate stored procedures are called
from a remote graphical user interface. This requires that enough address spaces are available or
can be started with minimum delay. To ensure such conditions, the goals of the service class for DDF
transactions must be defined accordingly. Under favorable conditions, the starting of an address
space takes two seconds. Under good conditions, this action takes about 10 seconds. However, if the
workload is high, the time that is needed to start an address space can be considerably
longer.
Procedure
- Classify your DDF transactions explicitly.
- Assign the DDF transactions to a WLM service class.
- Make sure that the performance objectives of this service class are in accordance with
the objectives for the rest of the workload on your system. The service class for Data Gate stored procedures must have at least medium
priority.
Important: If classification rules do not exist to classify some or all of your DDF
transactions into service classes, the unclassified transactions are assigned the SYSOTHER service
class. This service class has no performance goal and is even lower in priority than a service class
with a discretionary goal.
-
Assign the address spaces for the stored procedures to a separate service class for started
tasks (STC).