|
Problem IT31569
|
Status: Closed |
DATABASE ROLLFORWARD TO A POINT IN TIME MAY FAIL DUE TO A BOUNDARY CONDITION
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
A rollforward to a point in time may fail due to a boundary case
when the log record that contain the point in time spans across
2 log pages
where the second page is the first page of a ping pong set.
You will see the following db2diag.log entries.
2018-09-27-08.28.42.414435-240 I3625876E459 LEVEL: Info
PID : 4838 TID : 139805937624832 PROC :
db2sysc
INSTANCE: xxxxx NODE : 000 DB :
xxxxxxxxxx
HOSTNAME: xxxxxxxxx
EDUID : 77 EDUNAME: db2loggr (xxxxxxxx)
FUNCTION: DB2 UDB, recovery manager, sqlpgSwitchCopyPongToPing,
probe:1040
DATA #1 :
writing BufferArray 0 to log stream 0 log extent 10 tailPage 9
pageLso 65683374
2018-09-27-08.28.42.414664-240 I3626336E617 LEVEL:
Severe
PID : 4838 TID : 139805937624832 PROC :
db2sysc
INSTANCE: xxxx NODE : 000 DB :
xxxxxxxx
HOSTNAME: xxxxxxx
EDUID : 77 EDUNAME: db2loggr (xxxxxxxx)
FUNCTION: DB2 UDB, data protection services, sqlpWriteOnePage,
probe:909
MESSAGE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File
cannot be used"
DIA8414C Logging can not continue due to an error.
DATA #1 :
TailPage 9 does not match pageLso 65683374 and firstLso
65639905.
lowLso: 65676589, highLso: 65680665 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1.4.5 or higher *
**************************************************************** |
| Local Fix: |
Use a different PIT (point in time) for the ROLLFORWARD command. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1.4.5 or higher *
**************************************************************** |
| Comment |
Upgrade to Db2 11.1.4.5 or higher |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.01.2020
21.01.2020
21.01.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
