|
Problem IC97387
|
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 / A50 - 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.5 Fix Pack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 10.5 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.11.2013
27.02.2014
27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
