The Explain table "xxx.plan_table", column "xxx" does not have the proper definition or is missing. (4323664)

Chat now with support

The Explain table "xxx.plan_table", column "xxx" does not have the proper definition or is missing. (4323664)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

The Explain table "xxx.plan_table", column "xxx" does not have the proper definition or is missing.
Description

Error shows after logging in:

[IBM][CLI Driver][DB2/AIX64] SQL0220N The Explain table "xxx.ADVISE_INDEX", column "NLEAF" does not have the proper definition or is missing. SQLSTATE=55002
Cause

Different version of the plan table definition.
Resolution

1. Backup existing table "ADVISE_INDEX" (DDL and its data if any) for precautionary measure.
2. Drop the table:

Drop TABLE ADVISE_INDEX;

3. Connect to SQL Optimizer and you will be prompted to recreate the table.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title