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

To gather EXPLAIN information for a query workload from the database server, you must enable the SYSPROC.OPT_EXECUTE_TASK stored procedure.

Before you begin

About this task

By enabling the SYSPROC.OPT_EXECUTE_TASK stored procedure, you can gather and consolidate EXPLAIN information for a query workload from the database server. The stored procedure must also be enabled to consolidate literal values in EXPLAIN information.

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 full client, Version 3.1.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