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

HEALTH MONITOR MAY GET WRONG ACTIVE LOG FILE NUMBER WHEN ONLINE BACKUP WAS
ISSUED AND MISTAKENLY ASSUMED FLIPPED OVER BY LOGGING

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
If there were lots of uncommitted transactions when either 
manual online back up was issued or online auto backup was 
performed, then you may see the warning message like below in 2 
hours occasionally in db2diag.log: 
 
2012-10-16-02.07.11.152252-240 I2083621A402       LEVEL: Warning 
PID     : 24117308             TID  : 1047        PROC : db2acd 
INSTANCE: db2inst1             NODE : 000 
EDUID   : 1047                 EDUNAME: db2acd 
FUNCTION: DB2 UDB, database utilities, sqluiirc, probe:150 
DATA #1 : <preformatted> 
Active Log file '0' is smaller then Log File used in Last Backup 
'167'. Asssuming has flipped over.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10 Fix Pack 3                         * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
First fixed in DB2 Version 10 Fix Pack 3
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC97387 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.01.2013
01.11.2013
01.11.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList