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 | |
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 |