|
Problem IC69339
|
Status: Closed |
REPLAY OF CERTAIN INTERNAL INDEX OPERATIONS DURING ROLLFORWARD OR CRASH RECOVERY MAY FAIL WITH ERROR DIA8575C |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Replay of certain internal index operations when rolling
forward, either as part of recovery or on an HADR standby, can
lead to a miscalculation of the free space on an index page
resulting in this error being reported:
2010-05-14-21.58.21.582815+120 I18806675E585 LEVEL: Error
PID : 24382 TID : 46912854026560PROC :
db2sysc
INSTANCE: INST1 NODE : 000 DB :
SAMPLE
APPHDL : 0-17 APPID: *LOCAL.DB2.100507185408
EDUID : 85 EDUNAME: db2redow (SAMPLE)
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:155
MESSAGE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
error"
DIA8575C An index manager programming error occurred.
DATA #1 : <preformatted>
REDO failed on LSO(LSN) 15666791888120 (00000E519B932CEF)
This db2diag.log entry is preceded by a message of function
sqliakn at probe 901:
2010-05-14-21.58.21.465469+120 I18763255E646 LEVEL: Severe
PID : 24382 TID : 46912854026560PROC :
db2sysc
INSTANCE: INST1 NODE : 000 DB :
SAMPLE
APPHDL : 0-17 APPID: *LOCAL.DB2.100507185408
EDUID : 85 EDUNAME: db2redow (SAMPLE)
FUNCTION: DB2 UDB, index manager, sqliakn, probe:901
MESSAGE : slotinfo
DATA #1 : Hexdump, 40 bytes |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* Replay of certain internal index operations when *
* rollingforward, either as part of recovery or on an HADR *
* standby,canlead to a miscalculation of the free space on an *
* index pageresulting in this error being *
* reported:2010-05-14-21.58.21.582815+120 I18806675E585 *
* LEVEL:ErrorPID : 24382 TID : *
* 46912854026560PROC :db2syscINSTANCE: INST1 *
* NODE : 000 DB :SAMPLEAPPHDL : 0-17 *
* APPID: *LOCAL.DB2.100507185408EDUID : 85 *
* EDUNAME: db2redow (SAMPLE)FUNCTION: DB2 UDB, recovery *
* manager, sqlpRecDbRedo,probe:155MESSAGE : *
* ZRC=0x87090054=-2029453228=SQLI_PRG_ERR *
* "Programerror"DIA8575C An index manager programming *
* erroroccurred.DATA #1 : <preformatted>REDO failed on *
* LSO(LSN) 15666791888120 (00000E519B932CEF)This db2diag.log *
* entry is preceded by a message of functionsqliakn at probe *
* 901:2010-05-14-21.58.21.465469+120 I18763255E646 *
* LEVEL:SeverePID : 24382 TID : *
* 46912854026560PROC :db2syscINSTANCE: INST1 *
* NODE : 000 DB :SAMPLEAPPHDL : 0-17 *
* APPID: *LOCAL.DB2.100507185408EDUID : 85 *
* EDUNAME: db2redow (SAMPLE)FUNCTION: DB2 UDB, index manager, *
* sqliakn, probe:901MESSAGE : slotinfoDATA #1 : Hexdump, 40 *
* bytes *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 FP3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 |
First fixed in DB2 V9.7 FP3 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC69801
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.06.2010
27.09.2010
27.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
