Performance tuning enhancements

Db2 11.5.9 provides better control over the display of EXPLAIN information when you generate query access plans.

Attention: This mod pack release is currently available for the following Db2 products:
The following table lists performance tuning enhancements that are included in Db2 11.5.9:
Table 1. Performance tuning enhancements in Db2 11.5.9
Enhancement Description
Easily format how explain information appears for query access plans. With the release of Db2 11.5.9, you can run the EXPLAIN_FORMAT stored procedure to format explain table information that is generated when you explain an SQL statement. The EXPLAIN_FORMAT stored procedure formats the explain information consistent with db2exfmt and stores the result in a new explain table column. For more information about the db2exfmt command, see Understanding db2exfmt information.