|
Problem IT31568
|
Status: Closed |
UPDATE ON A TABLE WITH A CLUSTERING INDEX MAY TRAP IF THERE ARE LARGE ROWS ON THE TABLE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
An update on a table may trap if it has large rows (rows that
exceed the page size) and there is clustering index on the
table. When the error occurs, the following function will be in
the stack:
0x090000000FF8CA54
sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_
KEYDATAP9sqli_scanPi + 0x1074
0x09000000114DFEE0
IPRA.$sqldFindTargetPageForClustering__FP13SQLD_DFM_WORK + 0x540
0x09000000114DDCD8 sqldInsertRow__FP13SQLD_DFM_WORKi + 0x2F8
0x09000000145AC4CC
IPRA.$sqldCreateOverflow__FP13SQLD_DFM_WORK13SQLD_PAGESLOTN22UlN
25 + 0x22C |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher *
**************************************************************** |
| Comment |
First fixed in Db2 11.1 Mod 4 Fixpack 5 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.01.2020
18.01.2020
18.01.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
