When the new ‘Use plan table from SYSTOOLS’ option is enabled (in File | Options | General), SQL Optimizer is not doing anything during SQL Rewrite.
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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy