home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC84230 Status: Geschlossen

HADR STANDBY MAY TRY TO RETRIEVE LOG FILES EVEN WHEN LOG ARCHIVE METHOD IS
SET TO LOGRETAIN

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
HADR standby database may still try to retrieve log files from 
archive device even after userexit is turned off. 
 
 
When hitting the problem, database configuration looks like 
this: 
 Log retain for recovery enabled             (LOGRETAIN) = 
RECOVERY 
 First log archive method                 (LOGARCHMETH1) = 
LOGRETAIN 
 User exit for logging enabled                (USEREXIT) = OFF 
 
Normally, with the above configuration, HADR standby should not 
retrieve log files for local catchup. However, when hitting this 
problem, similar messages could be found in db2diag.log: 
 
2011-05-21-20.37.50.736389-300 I71697A360         LEVEL: Warning 
PID     : 25165998             TID  : 5792        PROC : db2sysc 
0 
INSTANCE: db2inst1               NODE : 000 
EDUID   : 5792                 EDUNAME: db2lfr (SAMPLE) 0 
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:600 
MESSAGE : Extent 249204 in log path may be stale. Trying 
archive. 
 
2011-05-21-20.37.50.736576-300 I72058A364         LEVEL: Warning 
PID     : 25165998             TID  : 5021        PROC : db2sysc 
0 
INSTANCE: db2inst1               NODE : 000 
EDUID   : 5021                 EDUNAME: db2logmgr (SAMPLE) 0 
FUNCTION: DB2 UDB, data protection services, 
sqlpgRetrieveLogFile, probe:4130 
MESSAGE : Started retrieve for log file S0249204.LOG. 
 
2011-05-21-20.37.50.736675-300 I72423A418         LEVEL: Warning 
PID     : 25165998             TID  : 5021        PROC : db2sysc 
0 
INSTANCE: db2inst1               NODE : 000 
EDUID   : 5021                 EDUNAME: db2logmgr (HADRDB) 0 
FUNCTION: DB2 UDB, data protection services, 
sqlpgRetrieveLogFile, probe:4148 
MESSAGE : Completed retrieve for log file S0249204.LOG on chain 
0 to 
          /db2/P21/log_dir/NODE0000/. 
 
Please also take db2pd -db dbname -dpsdbcb and send the output 
to 
IBM or further investigation.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 FP1 or subsequent fix pack               * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
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

Lösung
Problem First Fixed in DB2 Version 10.1 Fix Pack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.06.2012
05.12.2012
05.12.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.1 FixList
10.5.0.1 FixList