SQL Optimizer for DB2 not working when "Use plan table from SYSTOOLS" selected (77219)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SQL Optimizer for DB2 not working when "Use plan table from SYSTOOLS" selected
Description

When the new ‘Use plan table from SYSTOOLS’ option is enabled (in File | Options | General), SQL Optimizer is not doing anything during SQL Rewrite.
Resolution

WORKAROUND
Check when using an OS user if it has a database schema map to it.
RESOLUTION
Waiting for a fix in a future release of Quest SQL Optimizer for DB2.
Defect ID

ST88573

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title