DB2 FOR LUW / DB2FORLUW / B50 - DB2

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)

****************************************************************
* USERS AFFECTED:                                              *
* Data Partitioned Feature                                     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.5.6                                            *
****************************************************************

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.

****************************************************************
* USERS AFFECTED:                                              *
* Data Partitioned Feature                                     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.5.6                                            *
****************************************************************

Upgrade to 11.5.6

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

18.02.2021
11.06.2021
11.06.2021