Changes to EXPLAIN tables in Db2 11.5.5

Db2® 11.5.5 contains changes to the format of EXPLAIN tables.

Attention: The enhancements in this topic are included in the Db2 11.5.5 mod pack release, which is available for the following products:

Db2 on-premises
The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS)
The container micro-service deployment of Db2 on Red Hat OpenShift

Details

The format of the EXPLAIN tables has been changed in Db2 11.5.5. Existing EXPLAIN tables must be updated to the new format using either the db2exmig tool or the M action of the SYSINSTALLOBJECTS procedure.