DB2 - Problem description
Problem IC75495 | Status: Closed |
TOO MANY LOGFILES REMAIN IN THE ACTIVE PATH ALTHOUGH THEY ALREADY GOT ARCHIVED | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
In HADR context, it is possible that after performing an HADR TAKEOVER, some log files will not be reused on the new HADR Primary and thus will stay in the active log files directory. This will have for effect to increase the number of log files in this directory beyond the configured number in LOGPRIMARY database configuration parameter. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Using HADR * **************************************************************** * PROBLEM DESCRIPTION: * * See error description above * **************************************************************** * RECOMMENDATION: * * Upgrade to version 9.7 Fixpack 5 * **************************************************************** | |
Local Fix: | |
You may use the "PRUNE LOGFILE" command to remove the orphaned log files from the primary log path. Please refer to the <A HREF=http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index. jsp?topic=/com.ibm.db2.luw.admin.cmd.doc/doc/r0001992.html>PRUNE </A> command. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Solution | |
This fix improve log file management in HADR take over situation in order to avoid orphaned log files in the primary log path. First fixed in version 9.7 fixpack 5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.04.2011 13.12.2011 13.12.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.5 |