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.
Procedure
Set parameter KD2_PFxx_EX_D2EXACT to Y.
What to do next
After you enable explain functions and generate the runtime members, you must
complete steps listed in Complete the Configuration.