DB2 - Problem description
Problem IT35953 | Status: Closed |
INSERT FROM COMPLEX SELECT WITH ORDER BY IN DPF MODE MIGHT LEAD TO SEGV TRAP | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
INSERT from complex SELECT with ORDER BY in DPF mode might lead to signal #11 (segmentation fault) which results in abnormal termination of DB2 instance. Signal #11 function stack will show: sqlkbfix(sqlr_db*,short,SQLKB_TABLE_ENTRY**,sqeAgent*,bool,bool) + 0x990 sqlkbndl(sqlrr_cb*,short,int*,short*,long*,long*,long*) + 0xD8 sqlno_get_pmid_data(sqlno_globals*,sqlno_part*,sqlno_part*,int*, int*,int*,int*) + 0x20A0 sqlno_cost_tq(sqlno_globals*,sqlno_plan_properties*,sqlno_plan_f unction*) + 0x1984 sqlno_prop_tq(sqlno_globals*,sqlno_context*,sqlno_plan_propertie s*,sqlno_plan_function*) + 0xD0C TQ(sqlno_globals*,sqlno_context*,sqlno_plan_operator*,sqlno_part *,sqlno_order_class*,sqlno_key*,sqlno_set*,sqlno_hsjn_bitf_info* ,int,int,SQLNN_BOOLEAN,SQLNN_BOOLEAN,SQLNN_BOOLEAN,sqlno_plan_op erator**) + 0x8B0 sqlno_crule_tq_stream(sqlno_globals*,sqlno_context*,sqlno_plan_o perator*,sqlno_part*,sqlno_order_class*,sqlno_key*,SQLNN_BOOLEAN ,unsigned int*,sqlno_plan_operator**) + 0x1BC (snip) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Data Partitioned Feature * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 * **************************************************************** | |
Local Fix: | |
db2set DB2_REDUCED_OPTIMIZATION="LSRT OFF" -im If the registry variable is already set to a different value, add "LSRT OFF" to the end, separated by a comma (no spaces). For example, if DB2_REDUCED_OPTIMIZATION=NO_SORT_NLJOIN is already set, then update it as follows: db2set DB2_REDUCED_OPTIMIZATION="NO_SORT_NLJOIN,LSRT OFF" -im No DB2 instance restart needed. NOTE: This might slow down INSERT-from-SELECT statements where the SELECT contains an ORDER BY. Test the performance impact of this setting in test environment before implementing in production. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Data Partitioned Feature * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.02.2021 11.06.2021 11.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |