|
Problem IC66724
|
Status: Closed |
EXCESSIVE MESSAGES ON HADR STANDBY: "EXTENT NNNN IN LOG PATH MAY BE STALE. TRYING ARCHIVE" |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
During normal operation, a HADR Standby will attempt to access
log files from a log archive device. This should only occur in
the HADR state 'Local Catchup'. In rare cases, the HADR Standby
might try, in error, to retrieve log files well beyond entering
'Peer' state.
If this problem occurs, you will be able to observe diag.log
entries similar to the following:
2009-10-07-17.43.47.270826-420 E2005993A367 LEVEL: Event
PID : 1278018 TID : 17549 PROC : db2sysc
0
INSTANCE: testinst NODE : 000
EDUID : 17549 EDUNAME: db2hadrs (TESTDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrSetHdrState, probe:10000
CHANGE : HADR state set to S-Peer (was S-NearlyPeer)
...
2009-10-07-18.10.30.827847-420 I2041779A358 LEVEL: Warning
PID : 1278018 TID : 5213 PROC : db2sysc
0
INSTANCE: testinst NODE : 000
EDUID : 5213 EDUNAME: db2lfr (TESTDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:600
MESSAGE : Extent 1572 in log path may be stale. Trying archive.
...
2009-10-07-18.11.15.014076-420 I2047682A358 LEVEL: Warning
PID : 1278018 TID : 5213 PROC : db2sysc
0
INSTANCE: testinst NODE : 000
EDUID : 5213 EDUNAME: db2lfr (TESTDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:600
MESSAGE : Extent 1573 in log path may be stale. Trying archive.
. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* HADR users *
****************************************************************
* PROBLEM DESCRIPTION: *
* During normal operation, a HADR Standby will attempt to *
* access log files from a log archive device. This should *
* only occur *
* in the HADR state 'Local Catchup'. In rare cases, the HADR *
* Standby might try, in error, to retrieve log files well *
* beyond *
* entering 'Peer' state. *
* *
* If this problem occurs, you will be able to observe diag.log *
* entries similar to the following: *
* *
* 2009-10-07-17.43.47.270826-420 E2005993A367 LEVEL: *
* Event *
* PID : 1278018 TID : 17549 PROC : *
* db2sysc 0 *
* INSTANCE: testinst NODE : 000 *
* EDUID : 17549 EDUNAME: db2hadrs (TESTDB) 0 *
* FUNCTION: DB2 UDB, High Availability Disaster Recovery, *
* hdrSetHdrState, probe:10000 *
* CHANGE : HADR state set to S-Peer (was S-NearlyPeer) *
* *
* ... *
* *
* 2009-10-07-18.10.30.827847-420 I2041779A358 LEVEL: *
* Warning *
* PID : 1278018 TID : 5213 PROC : *
* db2sysc 0 *
* INSTANCE: testinst NODE : 000 *
* EDUID : 5213 EDUNAME: db2lfr (TESTDB) 0 *
* FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, *
* probe:600 *
* MESSAGE : Extent 1572 in log path may be stale. Trying *
* archive. *
* *
* ... *
* *
* 2009-10-07-18.11.15.014076-420 I2047682A358 LEVEL: *
* Warning *
* PID : 1278018 TID : 5213 PROC : *
* db2sysc 0 *
* INSTANCE: testinst NODE : 000 *
* EDUID : 5213 EDUNAME: db2lfr (TESTDB) 0 *
* FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, *
* probe:600 *
* MESSAGE : Extent 1573 in log path may be stale. Trying *
* archive. *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to Fixpack 3 or later *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
Problem is first fixed in version 9.8 Fixpack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.02.2010
21.12.2010
21.12.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.3
|
 |
