Working with and retrieving EXPLAIN table data

Db2 and certain optimization tools automatically populate EXPLAIN tables, such as PLAN_TABLE and DSN_STATEMNT_TABLE, but you might decide to modify or remove data from certain instances of these tables.

About this task

Although Db2 automatically populates EXPLAIN tables, you might modify the data in your EXPLAIN tables. When Db2 populates EXPLAIN tables, or you ,INSERT triggers on the table are not activated. However, if you use an INSERT statement to add rows manually, then any INSERT triggers are activated.

Recommendation: Because certain optimization tools depend on the data in EXPLAIN tables, be careful not to manually modify data in EXPLAIN table instances created for those tools.

You can enable column and row-level access controls for EXPLAIN tables. However, the access controls do not apply when Db2 inserts data into the EXPLAIN tables.