Optional tasks for configuring DB2 for z/OS subsystems for tuning
Two of the tasks that are involved in configuring subsystems
for tuning are optional.
Enabling the SYSPROC.OPT_RUNSQL stored procedure on a DB2 for z/OS subsystem 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.
Configuring database groups
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.