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 IC75842 Status: Closed

CRASH RECOVERY MAY HANG AFTER REACHING LOG FULL CONDITION

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
During a log full condition, if the instance is abruptly 
shutdown, on restart the database needs to go through Crash 
recovery. Crash recovery may hang when it reaches the 
(LOGPRIMARY + LOGSECOND) number of logs and have no further logs 
to write the backward phase log records.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* During a log full condition, if the instance is abruptly     * 
*                                                              * 
* shutdown, on restart the database needs to go through Crash  * 
*                                                              * 
* recovery. Crash recovery may hang when it reaches the        * 
*                                                              * 
* (LOGPRIMARY + LOGSECOND) number of logs and have no further  * 
* logs                                                         * 
* to write the backward phase log records.                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* included in v91fp11                                          * 
****************************************************************
Local Fix:
Update LOGSECOND temporarily to -1 (Infinite logging). After 
crash recovery completes, LOGSECOND can be updated back to the 
old value.
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.04.2011
07.12.2011
07.12.2011
Problem solved at the following versions (IBM BugInfos)
9.1.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.