Enabling the SYSPROC.OPT_EXECUTE_TASK stored procedure on DB2 for z/OS subsystems

When you are tuning SQL, you can reduce traffic on your network by causing some tuning tasks, such as capturing statements from the dynamic statement cache or explaining query workloads, to run on the connected subsystem independent of the Data Studio client.

Before you begin

About this task

When there is less communication taking place between the subsystem and the Data Studio client, certain tuning tasks can return results to you more quickly. Enabling the SYSPROC.OPT_EXECUTE_TASK stored procedure reduces the amount of this client-server communication.

Procedure

To enable the Java stored procedure SYSPROC.OPT_EXECUTE_TASK:

  1. Upload the file aocwccsp.jar in binary format to the subsystem. This file is installed with the IBM Data Studio client, Version 4.1 in the QueryTunerServerConfig\all_features\ZOS\WCC subdirectory of the installation directory.
  2. Place the file in a location that is specified by CLASSPATH for the WLM environment.

Feedback