Enhancement For Users of DB2 EXPLAIN
MartinPacker 11000094DH Visits (934)
APAR PK15454 documents an extension to DB2's EXPLAIN function which makes correlation of the various tables involved much easier. This enhancement is used by Visual Explain but can also be used by people querying the tables EXPLAIN produces, in particular DSN_FILTER_TABLE and DSN_PREDICAT_TABLE.
When you EXPLAIN a statement it produces rows in the well-known PLAN_TABLE table, but also in these other two tables (and some other lesser-known tables).
To quote from the APAR description a number of problems were fixed...
The LITERALS column in DSN_PREDICAT_TABLE does not display SMALLINT properly.