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

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[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.

Was this article helpful?

[Select Rating]

Title