SupportSupport

Mark,

You need to use the IBM driver to enable the explain plan feature. The reason is not that this is unsupported via the Jdbc/Odbc driver but rather they way DbVis determine that DB2 is being used.

Regards

Roger

Roger,

I am trying to setup the db2/udb explain plain functionality according to the documentation: http://www.dbvis.com/products/dbvis/doc/5.0/doc/ug/sqlCommander/sqlCommander.html#mozTocId979712.

I "go to Connection Properties->\[database]" in the driver setup, but do not see "Explain Plan".

Is this supported in the IBM type 4 driver? What am I missing? Thanks.

jack

Sp, I've finally gotten around to needing this again and as I'm now set up with the DB2 driver I thought I'd give it another go.

This time I can see the Explain Plan options in the connection settings and I can see and press the Explain Plan button on the interface. Doing so just returns a Null Pointer Exception however.

I've attached an image showing various settings I'm using and the reported error.

The error occurs irrespective of the statement I want to explain over.

Is there any instability in the DBVis version I'm using? Do I need other packages installed? I'm logged on as a high-permissions user but is there anything else I need to be aware of?

Cheers,

Mark

Hi Roger,

With the debug options set (and checking the Debug JDBC Drivers box) I get this output in the debug window.

DB2Statement closed in finalizer, last SQL: "null"

However, clearing the output and clicking the explain button again doesn't consistently write the message to the debug window, so I'm not sure whether that's directly related or not.

I've attached the debug trace gained from connecting to my target database and then running the explain plan over a simple query (SELECT * FROM schema.some_view).

Actually, whe running against either an actual view OR a mistyping the view name the same message is reported:

09:04:47 \[SELECT - 0 row(s), 0.000 secs] null (java.lang.NullPointerException )
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec \[0 successful, 0 warnings, 1 errors]

I'm sorry I can't give you more. I've re-run this a few times looking for different output but nothing...

It doesn't appear to be a problem with my SQL statement (right or wrong).

What prerequisites are there for me to be able to run the explain plans against db2?

Great. That did it.

It is non-standard (as far as our restrictive environment goes) but as it is an official DB2 driver I think I can work with this.

This is going to make my life a lot easier.

Thanks again.

Mark

I have never been able to get the Explain functionality to work either. Attached is a document with error and debug information. I have the latest driver per this post. What must I do to make this work?