|
Problem IC74279
|
Status: Closed |
ROLLBACK OF TRANSACTION MAY FAIL WITH SQLI_SMP_ERR "SMP PROBLEMS" WHEN USING PARTITIONED INDEXES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The problem affects partitioned tables with partitioned indexes.
If there is a lock escalation on a partition for a unit of work
and then deletes occur against against records in that
partition, since the application holds an X lock on the
partition, DB2 will perform physical deletes from the index
instead of marking the keys as pseudo deleted. DB2 will also
free index pages instead of marking them as pending pseudo
empty.
If another transaction tries to create an index on the table, it
will create an empty root page and get blocked trying to upgrade
its lock from an IN to an S lock.
If the first transaction rolls back the deletes, we may fail
during the rollback with messages similar to the following:
2011-02-01-16.09.33.969470+060 I75937578A514 LEVEL: Severe
PID : 909350 TID : 36352 PROC : db2sysc
2
INSTANCE: db2inst1 NODE : 002 DB : SAMPLE
APPHDL : 0-35847 APPID:
172.16.99.62.34364.110201143801
AUTHID : ADMDW
EDUID : 36352 EDUNAME: db2agnta (SAMPLE) 2
FUNCTION: DB2 UDB, index manager, sqliundo, probe:2310
RETCODE : ZRC=0x87090052=-2029453230=SQLI_SMP_ERR "SMP problems"
DIA8573C An invalid space map page was found. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of partitioned tables with partitioned indexes. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 5. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 Version 9.7 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.02.2011
23.12.2011
23.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
