|
Problem IC84696
|
Status: Closed |
LOAD WITH COPY YES MIGHT CAUSE INDEX CORRUPTION DURING SUBSEQUEN T ROLLFORWARD WHEN SPECIFYING MULTIPLE COPY TARGET SESSIONS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Load with copy yes writes the same index root page into load
copy files twice when rebuilding indexes: one is empty index
root page and the other is populated one with data.
When specifying multiple copy target sessions, load might write
the two versions (empty and populated ones) of the same index
root page into different copy files when rebuilding indexes, so
that subsequent rollforward issued by HADR standby or standalone
rollforward recovery might overwrite the index root page with
the empty one during restoring load copy files.
This index corruption reported by db2redom by HADR standby or
during the rollforward recovery in db2diag.log is as below:
2012-04-26-11.35.37.549683-300 I11336584A658 LEVEL: Severe
PID : 22937764 TID : 18328 PROC : db2sysc
0
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-336 APPID: *LOCAL.DB2.120426144404
EDUID : 18328 EDUNAME: db2redom (TEST) 0
FUNCTION: DB2 UDB, index manager, sqlidkn, probe:300
MESSAGE : Error in sqlidkn
DATA #1 : Hexdump, 40 bytes
0x070000010EBF8E18 : 0000 0000 0000 0000 0000 0000 0000 0098
................
0x070000010EBF8E28 : 0000 0000 0000 0208 0000 0000 0000 0004
................
0x070000010EBF8E38 : FFFF FFFF FFFF FFFF
........
2012-04-26-11.35.37.550009-300 I11337243A499 LEVEL: Severe
PID : 22937764 TID : 18328 PROC : db2sysc
0
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-336 APPID: *LOCAL.DB2.120426144404
EDUID : 18328 EDUNAME: db2redom (TEST) 0
FUNCTION: DB2 UDB, index manager, sqlidkn, probe:1317
RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
error"
DIA8575C An index manager programming error occurred.
or
2012-05-23-01.17.45.743616-240 I28673E531 LEVEL: Severe
PID : 27495 TID : 46912975661376PROC :
db2sysc
INSTANCE: test NODE : 000 DB :
TEST
APPHDL : 0-2342 APPID: *LOCAL.test.120523051601
AUTHID : TEST
EDUID : 986 EDUNAME: db2redom (TEST)
FUNCTION: DB2 UDB, index manager, sqliCheckKey, probe:350
RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
error"
DIA8575C An index manager programming error occurred. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 7. *
**************************************************************** |
| Local Fix: |
Specify a single copy target session. |
| available fix packs: |
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 |
First fixed in DB2 Version 9.7 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88605
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.06.2012
23.10.2012
23.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
