|
Problem IC95369
|
Status: Closed |
HADR standby database encounters log page checksum error |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
HADR standby database encounters log page checksum error, then
shuts itself down.
You may see the following messages in db2diag:
2013-02-09-03.32.13.993712-300 I8918A544 LEVEL: Error
PID : 45940956 TID : 5541 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 5541 EDUNAME: db2lfr.0 (sample) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrGetBlock, probe:40100
MESSAGE : ZRC=0x87800148=-2021654200=HDR_ZRC_BAD_LOG
"HADR standby found bad log"
DATA #1 : <preformatted>
Log page checksum mismatch. pageLso 4258712948508, CheckSum
118415316
2013-02-26-20.31.53.315457-300 I12190A500 LEVEL:
Warning
PID : 12714058 TID : 5656 PROC :
db2sysc 0
INSTANCE: vpcinp01 NODE : 000
EDUID : 5656 EDUNAME: db2lfr.0 (VPCDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrVerifyLogPages,
probe:500
DATA #1 : <preformatted>
LFR Scan Num = 4
LFR Scan Caller's EDUID = 17992
Checksum error when reading page 140870 from log file
S0003158.LOG |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Users on DB2 V10.5 FP2 and lower *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
As a temporary workaround:
1. Identify the affected logs from db2diag.log
2. Deactivate standby database
3. Copy over affected logs from primary database or archive
location to standby database log path.
4. Re-activate standby database |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem Fixed In 10.5.0.3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
03.03.2014
03.03.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
