DB2 - Problem description
Problem IT36964 | Status: Closed |
TOO MANY LOG FILES IN ACTIVE LOG PATH ON HADR STANDBY | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Starting from Db2 Version 11.5 Mod Pack 5, on an HADR standby, it is possible to see more log files in the active log path than are needed by the system. This problem only applies to databases where page flushing policy is controlled via the page_age_trgt_mcr database configuration parameter (in other words the softmax database configuration parameter is set to 0). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * STANDBY TO MANY ACTIVE LOGS * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * First fixed in 11.5.7.0. * **************************************************************** | |
Local Fix: | |
Set the softmax database configuration parameter to non-zero value. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * STANDBY TO MANY ACTIVE LOGS * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * First fixed in 11.5.7.0. * **************************************************************** | |
Comment | |
First fixed in 11.5.7.0. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.05.2021 19.11.2021 19.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |