Problem with Sql Optimizer invoked from Toad for DB2

I have a query I want to explain using SQL Optimizer. I am connected to the database I want to explain it in in Toad and hit the optimizer button but when it invokes SQL optimizer it is in another database (which happens to be a production database).

Jim -

A couple questions:

Do you have the production database connection defined in the Toad Connection Manager?

Was SQL Optimizer already running when you invoked it from Toad, or did Toad launch the application?


Sorry Jeff. I figured out what I was doing wrong. Thanks.

Jim Rutten

Senior Database Administrator

Staples Promotional Products

7500 W 110th St

Overland Park , KS 66210

p:(913) 319-4709