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 IC77599 Status: Geschlossen

PRINT LOG NUMBER FOR REMOTE CATCH UP STANDBY: "HADR STANDBY FOUN DBAD
LOG" PRIMARY: "SQLPLFRSCANNEXT RETURNED RC = 0X860F000A"

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When we do remote catch up and the needed Log file is not 
available on the Primary any more, on the Primary we will get 
messages like: 
 
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, 
probe:20590 
MESSAGE : HADR primary database failed to read log pages for 
remote catchup. 
          sqlplfrScanNext returned rc = 0x860f000a, scanPages = 
0, scanFlagsOut 
          = 0x2 
 
And on the standby we will get a generic message like: 
 
FUNCTION: DB2 UDB, High Availability Disaster Recovery, 
hdrEduEntry, probe:21150 
RETCODE : ZRC=0x87800148=-2021654200=HDR_ZRC_BAD_LOG 
          "HADR standby found bad log" 
 
This APAR will improve DB2 code to print out the log file that 
we are trying to retrieve, which will help on problem diagnosis 
to asses if really the log is missing or can be retrieved
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* This APAR is an improvement to allow for quicker diagnostics * 
* of a missing log needed for remote catch up.                 * 
* Currently we are just printing the LSO, but it is not        * 
* straight forward for customers to work out the Logical log   * 
* file relevant.                                               * 
*                                                              * 
* FUNCTION: DB2 UDB, High Availability Disaster Recovery,      * 
* hdrEduP, probe:20445                                         * 
* MESSAGE : remote catchup starts at LSO 2298864001            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 and Fix Pack 5                    * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
Problem was first fixed in DB2 Version 9.7 and Fix Pack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.07.2011
09.12.2011
09.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.5 FixList