Explain tables does not exist. Check the explain plan properties for this database connection., tablesproperties

Explain tables does not exist. Check the explain plan properties for this database connection., tablesproperties

Use DbVisulalizer to connect to db2. An error is reported when you view the execution plan.

Explain tables does not exist. Check the explain plan properties for this database connection.

Check the execution plan attributes if the table of the execution plan is not in the village.

View the connection attributes as follows:

Only the Explain Plan attribute is available in DB2LUW. Therefore, first adjust the ype in the Connection attribute to DB2 LUW:

Then I used it again and found that the error was the same. Finally, I checked it carefully and found that a check was not checked.

Only when the create plan table if not exists is checked, it is created if the schedule does not exist. Then solve the problem.

Of course, we can also delete the corresponding information after the following Drop Explain Plan Table is executed.