DB2 - Problem description
Problem IT19370 | Status: Closed |
DB2 MAY ABEND IN AN MPP ENVIRONMENT WHEN A QUERY INVOLVES XML COLUMNS AND THE KEYWORD DISTINCT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - 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: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 11.1 Mod 2 Fix Pack 2 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.02.2017 23.06.2017 23.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |