Problem

The explain tables allow to create access plans and visualize them. Before the explain feature of DB2 can be used, the EXPLAIN tables need to be generated.

Solution

To create the EXPLAIN tables, the following command needs to be issued while connected to the database that the access plain needs to be generated in: