+219   THE REQUIRED EXPLANATION TABLE table-name DOES NOT EXIST

Explanation

The EXPLAIN statement assumes the existence of an EXPLAIN table and it is not defined in the DB2® subsystem as a base table.

System action

A valid plan or package will be created if no errors are detected. The statement is bound dynamically on each execution of the statement.

Programmer response

For better performance, rebind the plan or package after correcting the statement. To correct the statement, determine whether the required EXPLAIN table does exist. If not, create the required table.

SQLSTATE

01532