Defining WLM performance goals for the Data Gate on Cloud stored procedures

It is important to define Workload Manager (WLM) performance goals in such a way that the WLM service class for the Data Gate on Cloud stored procedures can provide a sufficient number of additional WLM address spaces in a timely manner when needed.

Before you begin

Important: If you have installed IBM Cloud® for use with the same Db2® for z/OS system, you already have a WLM environment and performance goals for the Data Gate on Cloud stored procedures. In this case, you can skip this task.

About this task

Data Gate on Cloud stored procedures are called from a remote graphical user interface. This requires that a sufficient number of address spaces is 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 very high, the time needed to start an address space can be considerably longer.

Procedure

  1. Classify your DDF transactions explicitly.
  2. Assign the DDF transactions to a WLM service class.
  3. 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 on Cloud 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.
  4. Assign the address spaces for the stored procedures to a separate service class for started tasks (STC).
    This ensures that the address spaces can be started before DDF transactions (stored procedures) start running. For more information, read Setting performance objectives for distributed workloads by using z/OS Workload Manager in the IBM® Documentation.