home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList