|
Problem IC77599
|
Status: Closed |
PRINT LOG NUMBER FOR REMOTE CATCH UP STANDBY: "HADR STANDBY FOUN DBAD LOG" PRIMARY: "SQLPLFRSCANNEXT RETURNED RC = 0X860F000A" |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
Problem was first fixed in DB2 Version 9.7 and Fix Pack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.07.2011
09.12.2011
09.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
