|
Problem IC66724
|
Status: Geschlossen |
EXCESSIVE MESSAGES ON HADR STANDBY: "EXTENT NNNN IN LOG PATH MAY BE STALE. TRYING ARCHIVE" |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Problem is first fixed in version 9.8 Fixpack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 26.02.2010
21.12.2010
21.12.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.8.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.8.0.3
|
 |
