"SET OF OPTIONAL COLUMNS" IN EXPLANATION TABLE table-name IS INCOMPLETE. OPTIONAL COLUMN column-name IS MISSING

Conclusão: The EXPLAIN statement assumes the required explanation table is defined properly. The optional column indicated is not defined in the indicated explanation table. PLAN_TABLEs must have one of several specific formats. The format chosen must be complete, and each column in the PLAN_TABLE definition must be correct for the chosen format. The allowed formats for the PLAN_TABLE are described in Chapter 6 of DB2 SQL Reference.

Ação do sistema: The explanation information is not generated.

Resposta ao Desenvolvedor: Correct the definition of the required explanation table to include all of the optional columns in the chosen format, just the Version 2 Release 2 optional columns, or no optional columns. Refer to Chapter 5 of DB2 SQL Reference for information on defining an explanation table.

SQLSTATE: 55002