Plan Table table contents

Plan Table depends on a number of Db2® tables.

The EEEAUTH table
The EEEAUTH table is used to specify the privileges for each Plan Table user.
The EEEWORK table
The EEEWORK table is used internally to find all of the indexes used by a given plan or package if a parameter of INDEX=Condensed has been specified.
The EEEDBRM table
The EEEDBRM table is used internally by Plan Table to store DBRM and package information. This information is used to build the Plan Information report.
The EEEHINT table
The EEEHINT table is used to save hint IDs for the mini-plans generated by Plan Table The ID identifies each mini-plan by a query number, a user ID, and a timestamp.
The EEEPLAN table
The EEEPLAN table is used internally by Plan Table to store plan information for plans explained by Plan Table. The plan information is used to build the Plan Information report.
The EEEPATH table
The EEEPATH table is used to save selected PLAN_TABLE and DSN_STATEMNT_TABLE information that later is sent to SQL PA together with the extracted SQL statements.

Parent topic: Reference information