Explain plan fails

Toad for IBM DB2
1

Hello,
explain plan fails on simple select with:

Plan
Cost
ERROR [55002] [IBM][DB2/NT64] SQL0220N The Explain table “XYZ.EXPLAIN_INSTANCE”, column “25” does not have the proper definition or is missing. SQLSTATE=55002
The corresponding table has only 24 columns.
DB2 Express-C V10
Toad for DB2 4.7 Freeware
Thank you in advance,
Vladimir

2

Hi Vladimir,

Toad for DB2 4.7 does not support DB2 version 10. You’ll need to create the v10 explain tables from the IBM documentation. You can also try a trial of the latest release of Toad for DB2 which supports DB2 version 10.

Regards,

Adam

3

Hello Adam,
thank you for the quick answer.
Regards,
Vladimir
P.S. Not sure that the thread should be marked “answered” before the fix or special caution on the download page.