Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    84

    Unanswered: IBM Data Studio 2.2 Visual Explain?

    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

  2. #2
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    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.

  3. #3
    Join Date
    Feb 2007
    Posts
    84
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •