Stored procedures are missing

Follow these steps when an error message requires you to enable one or more stored procedures.

To follow these steps, you must be using InfoSphere® Optim™ Query Workload Tuner for DB2® for z/OS®, Version 4.1.0.1.

To find out which packages are missing:

  1. In the Data Source Explorer, expand the connection to the subsystem.
  2. Right-click the subsystem and select Analyze and Tune > Configure for Tuning > Advanced Configuration and Privilege Management.
  3. Click Detailed Report.

For steps to enable the SYSPROC.OPT_EXECUTE_TASK stored procedure, which lets you reduce traffic on your network by causing some tuning tasks to run on the connected subsystem independent of the Data Studio client, see Enabling the SYSPROC.OPT_EXECUTE_TASK stored procedure on DB2 for z/OS subsystems.

For steps to enable the SYSPROC.OPT_RUNSQL stored procedure, which lets users capture the SQL statements from dynamic statement caches and store these statements in the DSN_STATEMENT_CACHE_TABLE table, if they do not have the privilege to run the EXPLAIN STMTCACHE ALL statement dynamically, see Enabling the SYSPROC.OPT_RUNSQL stored procedure on DB2 for z/OS subsystems.

For the following stored procedures, see the IBM® Information Management Software for z/OS Solutions Information Center at http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp:


Feedback