Troubleshooting problems with InfoSphere Optim Query Workload Tuner for DB2 for z/OS
Some common problems can occur when you are configuring DB2® for z/OS® for use with InfoSphere® Optim™ Query Workload Tuner.
EXPLAIN tables are missing or in an unknown format
Follow these steps when an error message requires you to create missing EXPLAIN tables or to recreate them.
EXPLAIN tables are at an out-of-date version
Follow these steps when an error message requires you to migrate EXPLAIN tables to the latest version for your version of DB2 for z/OS.
Query Tuner tables and views that are used for query-workload tuning are missing or are in an unknown format
Follow these steps when an error message requires you to create missing Query Tuner tables and views or to recreate them.
Query Tuner tables and views are at an out-of-date version
Follow these steps when an error message requires you to migrate Query Tuner tables and views to the latest version.
Query Tuner packages are missing
Follow these steps when an error message requires you to bind missing Query Tuner packages.
Stored procedures are missing
Follow these steps when an error message requires you to enable one or more stored procedures.
The Workload Analytics Acceleration Advisor cannot run
If the Workload Analytics Acceleration Advisor is not able to run, check the items in this list.
Feedback