Database logging enhancements

Db2 11.5.5 includes enhancements that help ensure that your data remains available.

Attention: The enhancements in this topic are included in the Db2 11.5.5 mod pack release, which is available for the following products:
The following table displays a list of database logging enhancements in 11.5.5:
Table 1. Logging enhancements in 11.5.5
Enhancement Description
Basic mirror log support for Advanced Log Space Management (ALSM)

Advanced Log Space Management (ALSM) helps to minimize application failures caused by log full errors (SQL0964N) as the result of a long running transaction holding back the active log. This is particularly useful if such a long running transaction does not generate much transaction log data in comparison to other concurrently running transactions.

Databases configured with a MIRRORLOGPATH can now gain the benefit of this feature as long as log data can be read from the active log files found in either the active or mirror log path and the extracted log data can be written to the extraction log files found under the active log path.

For details, refer to Advanced Log Space Management.