Enabling Db2 EXPLAIN

Explain functions provide an easy-to-read representation of access plan information for your SQL queries and statements. You can use this information to decide how to tune your queries. The built-in explain functions are Easy Explain and the EXPLAIN report.

Before you begin

You must create a database to be used by EXPLAIN. There are no special requirements regarding database name, storage group, or index buffer pool. But you must use an 8 KB buffer pool. The database name has to be specified in parameter KD2_PFxx_EX_D2EXDB.