Enabling the SYSPROC.OPT_RUNSQL stored procedure on DB2 for z/OS subsystems By enabling the SYSPROC.OPT_RUNSQL stored
procedure, you can capture the SQL statements from dynamic statement
caches and store these statements in the DSN_STATEMENT_CACHE_TABLE
table, if you do not have the privilege to run the EXPLAIN STMTCACHE
ALL statement dynamically.
Setting up the administrative scheduler
You have the option
of using the administrative scheduler
to schedule tasks on query workloads, such as workload capture and
monitoring.
Configuring database groups for use with InfoSphere Optim Query Workload Tuner
To be able to capture a workload
from the statement cache
on all subsystems of a data sharing group, you must configure a database
group in the client. This database group must contain the same members
of the data sharing group in a Parallel Sysplex® in your DB2 for z/OS environment.