Status section

Use this section to find out which features are enabled for tuning single SQL statements and query workloads.

On the Basic page, use the Status subsection to find out whether your authorization ID has access to a set of EXPLAIN tables to use for gathering EXPLAIN information about the SQL statements that you tune. Use the Features subsection to see a list of the features that are enabled for use.

On the Advanced page, find out whether the stored procedures for scheduling tasks to run on the connected DB2® for z/OS® subsystem are configured correctly. If you want to schedule tasks to run on query workloads by using the DB2 for z/OS administrative scheduler, two stored procedures must be enabled: SYSPROC.OPT_EXECUTE_TASK and SYSPROC.OPT_RUNSQL. See Configuring a DB2 for z/OS subsystem for the Optim™ Query Tuner client from the server side.


Feedback