After running a successful SQL Analysis collection, however, user couldn't send the SQL to the SQL Optimizer (the button is grayed-out.
If user goes directly to SQL Optimizer for DB2 UDB from the Tools\Quest Tools menu, it works fine.
See attachment Quest.doc and Quest2.doc
It seems to be the link between Toad SQL Analysis for DB2 LUW and SQL Optimizer for DB2 UDB)
STATUS
Waiting for a fix with ST 82705 on a future release of Toad for DB2.
WORKAROUND:
Copy SQL statement then optimize on SQL Optimizer for DB2 LUW.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center