Explanation plan fails on Toad 5.5 for db2

Toad for IBM DB2
1

error.png
error.png832×44 2.11 KB

Currently using toad version 5.5 and db2 version 10.5

I am getting this error for even the simplest plain explanation of "select * from table"

Kindly Advice what is the possible problem and solution for me.

Thanks

2

Take a look at the definition of your DB2INST1.EXPLAIN_OBJECT table.

In DB2 v10.5 a new NULLKEYS column is required that has been added at the end of the table (after column NUM_DATA_PARTS).

If the NULLKEYS column is not in your table you can add it via:

ALTER TABLE DB2INST1.EXPLAIN_OBJECT

ADD COLUMN NULLKEYS CHARACTER(1);

Then your explaining should start working.

3

It solved my problem.

Thank you very much.

By the way, do you know where I can find this kind of fix online?

Any knowledge base or documentaries?

4

I don’t know of any place up until my posting that had that fix listed on any web site.

5

Alright, thanks for your valuable help.