After creating a statement in Toad for DB2 and then launching SQL Optimizer to optimize it, the following error message is displayed:
"Invalid plan table(s) definition; it may not match with current DB2 LUW version."
"Please refer to the below database message for details."
"[IBM][CLI Driver][DB2/NT] SQL0220N The Explain table "DB2ADMIN.ADVISE_INDEX", column "NLEAF" does not have the proper definition or is missing. SQLSTATE=55002"
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center