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.1.
To find
out which packages are missing:
- In the Data Source Explorer, expand the connection to the subsystem.
- Right-click the subsystem and select .
- 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:
- Install the SYSPROC.DSNAEXP stored procedure, if users do not have the
privilege to explain SQL statements or the SQLADM authority (for DB2 10 for z/OS or later).
- Install the SYSPROC.DSNAHVPM stored procedure.
- Install the following two stored procedures to enable users to
review zParms and to turn on tracing for the dynamic statement cache.
- SYSPROC.DSNWZP
- SYSPROC.DSNACCMD (for DB2 Version 9.1
for z/OS) or SYSPROC.ADMIN_COMMAND_DB2
(DB2 10 for z/OS or
later)
- Install the SYSPROC.DSNUTILU stored procedure,
so that users can run RUNSTATS jobs that are recommended
by the Statistics Advisor and Workload Statistics Advisor.
- Install the SYSPROC.ADMIN_INFO_SQL stored procedure, so that users can
collect information that IBM support requires for resolving
PMRs about performance problems on DB2 10 for z/OS or later.
- Install the SYSPROC.SET_PLAN_HINT stored procedure, so that users can
validate and deploy subsystem-level hints on DB2 10 for z/OS or later. This stored procedure is also required by the
selectivity override feature, which you can use on DB2 11 for
z/OS or later
- Install the SYSPROC.ADMIN_COMMAND_DSN stored
procedure, so that users can validate and deploy optimization hints.