| |
- Causa
- THE REQUIRED EXPLANATION TABLE table-name DOES NOT EXIST
The EXPLAIN statement assumes the existence of the explanation table and it is not defined in the DB2 subsystem as a base table.
Refer to Chapter 5 of DB2 SQL Reference for more information.
- Ação do sistema
- A valid plan or package will be created if no errors are detected.
The statement is bound dynamically on each execution of the statement.
- Resposta ao Desenvolvedor
- For better performance, rebind the plan or package after correcting the statement.
To correct the statement, determine whether the required explanation table does exist. If not, create the required table.
SQLSTATE: 01532
|
| |
