Toad World® Forums

Explanation plan fails on Toad 5.5 for db2

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

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.

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?

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

Alright, thanks for your valuable help.