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

Use Dbvisulalizer link DB2 to view execution plans as reported errors

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

is the execution plan of the table no village, check the execution plan properties.

View connection properties as follows

The explain plan attribute is only available in Db2luw, so the datatype in the connection attribute is first adjusted to DB2 LUW:

And then use, found the same mistake, and finally looked carefully, only to find that there is a hook not on the

Only the Create plan table if not exists is checked, which is created if the schedule table does not exist. Then solve the problem.

Of course we can also drop the following drop Explain Plan table to delete the corresponding information after the execution is complete.

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