|
Problem IT19223
|
Status: Closed |
DB2 MAY ABEND IN AN MPP ENVIRONMENT WHEN A QUERY INVOLVES XML COLUMNS AND THE KEYWORD DISTINCT |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
DB2 may trap or otherwise terminate abnormally in a DPF/MPP
environment when a query involves XML and the DISTINCT keyword.
Due to the nature of the error, stacks may look like, but are
not limited to ones like:
0x090000000A85F344 @59@sqlkt_tq_save_tuple__FP9sqlri_taol + 0xC8
0x090000000A85EF48
@59@sqlkt_tq_find_winner__FP8sqeAgentP9sqlri_taoP11SQLKT_SLDESP5
sqlcaPUiPUl + 0x498
0x090000000A860AE4 sqlktfts__FP8sqeAgentP9sqlri_taoP5sqlcaPUiPUl
+ 0xF40
0x090000000A8613D4 sqlritqa__FP8sqlrr_cb + 0x6C4
0x090000000867337C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x74 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users using MPP environment and using XML column *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version DB2 LUW 10.5 FixPack 9 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem was first fixed in DB2 LUW Version 10.5 FixPack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.02.2017
01.03.2017
01.03.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
