I'm using DB2 9.1 LUW and recently started using IBM Data Studio 2.2 tool. In the Control Center tool, I used Visual Explain by Selected > Explain Query.

Is there a way to run this in IBM Data Studio 2.2? Could someone explain this to me or another option similar? Then the step to do this?

Thank you.

CC

It is much easier to run explains in IBM data studio.
1. Create data development project for the database connection
2. Create SQL script which you want to explain in SQL scripts holder under this project
3. Right click on SQL script and click on open visula explain
4. Upon opening the window select isolation, path, schema, current degree etc and finish.
5. It generates access plan diagram with estimated cost and other details.

Okay I got as far as Step 3 and then I right-click and select Open Visual Explain and get this popup box error "Failed to display access plan diagram. null".

I don't know what to do now, is there a way activate the access plain diagram?

Thank you.

CC