|
Problem IC75706
|
Status: Closed |
HADR STANDBY CAN IGNORE ARCHIVED LOGS IN LOCAL CATCHUP IF OVERFLOWLOGPATH IS SET |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The HADR Standby reads all locally-available log files during
Local Catchup. This includes log files in its active log path,
as well as log files available from a log archive device. A
problem can occur in this process if:
1) the Standby has a copy of a log file in its active log path
AND
2) the Standby tries to retrieve the log file from the archive
AND
3) the Standby has OVERFLOWLOGPATH configured.
In such a scenario, the Standby will incorrectly transition to
Remote Catchup prematurely, even though more log files are
available in the archive. The Standby will then request log
files from the HADR Primary, and otherwise function normally. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* HADR users with OVERFLOWLOGPATH enabled *
****************************************************************
* PROBLEM DESCRIPTION: *
* HADR Standby transitions from Local Catchup to Remote *
* Catchup prematurely while retrieving log files from log *
* archive if overflowlogpath is enabled. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fixpack 5. *
**************************************************************** |
| Local Fix: |
Unset OVERFLOWLOGPATH |
| 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 |
Starting in DB2 Version 9.7 Fixpack 5, the HADR Standby reads
all locally available log files regardless of whether or not
overflowlogpath is set. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.04.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5,
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
