|
Problem IT15520
|
Status: Closed |
INDEX SCAN MAY ENCOUNTER CRASH WHEN RID IS NEEDED FOR USER DEFINED TEMP TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When index is defined in user defined temporary tables, such as
declare global temporary table, and rowid is referenced through
index scan, the instance may crash.
The crash is due to unexpected lock request on temporary tables.
Repro script:
db2start
db2createdb wsdb
db2 "create bufferpool mybufferPool size 100 pagesize 8k"
db2 "create user temporary tablespace mytableSpace3 pagesize 8k
bufferpool mybufferPool"
db2 "declare global temporary table dgtt2(C1 int) on commit
preserve rows"
db2 "create index session.gi2 on session.dgtt2(C1)"
db2 " insert into session.dgtt2 values 1, 2, 3"
db2 "select rowid, c1 from session.dgtt2" |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.1 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in DB2 10.1 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.05.2016
02.03.2017
02.03.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
