|
Problem IC74440
|
Status: Closed |
after takeover, rollforward failed with SQL1265N against the tablespace which is in rollforward pending state on new primary |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
The scenario can be summarized as following:
1) tablespace container on standby DB become unavailible.
2) perform some updates in primary db.
3) takeover.
4) recover the tablespace container
5) perform the rollforward against recovered tablespace
The rollforward could fail with SQL1265N against the recovered
tablespace when using the rollforward command like:
$ db2 "rollforward db hadrtest to end of logs and stop
tablespace(tbtest)"
Similar entries could be written to db2diag.log:
2010-10-18-03.26.59.125363-240 I83754A590 LEVEL: Error
PID : 60375882 TID : 10575 PROC : db2sysc
INSTANCE: zxianing NODE : 000 DB :
HADRTEST
APPHDL : 0-1612 APPID:
*LOCAL.zxianing.101018072658
AUTHID : ZXIANING
EDUID : 10575 EDUNAME: db2agent (HADRTEST)
FUNCTION: DB2 UDB, recovery manager, sqlpInitTblRecovery,
probe:23
RETCODE : ZRC=0x86100017=-2045771753=SQLPR_BAD_VER_LOG_EXT
"Log extent file is the incorrect version"
DIA8424C An incorrect version of a log file was
encountered.
2010-10-18-03.26.59.126412-240 I84345A535 LEVEL: Error
PID : 60375882 TID : 10575 PROC : db2sysc
INSTANCE: zxianing NODE : 000 DB :
HADRTEST
APPHDL : 0-1612 APPID:
*LOCAL.zxianing.101018072658
AUTHID : ZXIANING
EDUID : 10575 EDUNAME: db2agent (HADRTEST)
FUNCTION: DB2 UDB, recovery manager, sqlpInitTblRecovery,
probe:1410
MESSAGE : firstExt:<
DATA #1 : Hexdump, 12 bytes
0x0700000005FF3340 : 0000 0000 0000 0000 0000 0000
............ |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* The scenario can be summarized as following: *
* *
* *
* *
* 1) tablespace container on standby DB become unavailible. *
* *
* *
* *
* 2) perform some updates in primary db. *
* *
* *
* *
* 3) takeover. *
* *
* 4) recover the tablespace container *
* *
* 5) perform the rollforward against recovered tablespace *
* *
* *
* *
* The rollforward could fail with SQL1265N against the *
* recovered *
* tablespace when using the rollforward command like: *
* *
* *
* *
* $ db2 "rollforward db hadrtest to end of logs and stop *
* *
* tablespace(tbtest)" *
* *
* *
* *
* Similar entries could be written to db2diag.log: *
* *
* *
* *
* 2010-10-18-03.26.59.125363-240 I83754A590 LEVEL: *
* Error *
* PID : 60375882 TID : 10575 PROC : *
* db2sysc *
* INSTANCE: zxianing NODE : 000 DB : *
* *
* HADRTEST *
* *
* APPHDL : 0-1612 APPID: *
* *
* *LOCAL.zxianing.101018072658 *
* *
* AUTHID : ZXIANING *
* *
* EDUID : 10575 EDUNAME: db2agent (HADRTEST) *
* *
* FUNCTION: DB2 UDB, recovery manager, sqlpInitTblRecovery, *
* *
* probe:23 *
* *
* RETCODE : ZRC=0x86100017=-2045771753=SQLPR_BAD_VER_LOG_EXT *
* *
* "Log extent file is the incorrect version" *
* *
* DIA8424C An incorrect version of a log file was *
* *
* encountered. *
* *
* *
* *
* 2010-10-18-03.26.59.126412-240 I84345A535 LEVEL: *
* Error *
* PID : 60375882 TID : 10575 PROC : *
* db2sysc *
* INSTANCE: zxianing NODE : 000 DB : *
* *
* HADRTEST *
* *
* APPHDL : 0-1612 APPID: *
* *
* *LOCAL.zxianing.101018072658 *
* *
* AUTHID : ZXIANING *
* *
* EDUID : 10575 EDUNAME: db2agent (HADRTEST) *
* *
* FUNCTION: DB2 UDB, recovery manager, sqlpInitTblRecovery, *
* *
* probe:1410 *
* *
* MESSAGE : firstExt:< *
* *
* DATA #1 : Hexdump, 12 bytes *
* *
* 0x0700000005FF3340 : 0000 0000 0000 0000 0000 0000 *
* *
* ............ *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.5 Fix pack 8 *
**************************************************************** |
| Local Fix: |
Restore the tablespace from db backup image and then perform
rollforward |
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The fix was included in DB2 V9.5 Fix pack8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.02.2011
30.06.2011
30.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.,
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
