I do get the Explain Plan feature when connecting to a local DB2 8.x on the same machine (Windows XP). I still don't get the feature when connecting to the remote DB2 7.1 (z/OS).
I'm using DBVis 5.0.0.6 and I've tried it with various driver versions, including the latest IBM Universal JDBC driver (v8 fixpack 11, 2.8.46).
So is the DB2 Explain Plan feature only supported for DB2 8.x and not for 7.x ? If yes, why?
Explain Plan for DB2 is only supported (officially) for DB2 running on Linux/UNIX and Windows. DbVisualizer Personal comes with extended visualization support (aka database profile) for DB2 on z/OS but still it is not a combination we officially support. The reason is that we have limited resources to test it.
If someone have had success running the explain plan feature in DbVisualizer with DB on z/OS then please post.
Sorry to bother you again, but I had no luck so far. I want to give it one last try.
One final question: How does DBVis determine whether to enable the Explain feature or not?
(It's obviously not dependent on the Database Profile or the JDBC driver - I tried the same settings for my local Windows DB2 and the remote z/OS DB2.)
The explain feature is enabled by what JDBC driver is being loaded. If you at connect automatically see Profile: db2 at the bottom of the Connection tab you should also see a DB2 category in Connection Properties. It lists some settings for the Explain feature. If you don't see these at all then it is strange.
- any help is appreciated.
