DB2 FOR LUW / DB2FORLUW / A10 - DB2

DB2 may trap with the following stack. 
The trap requires a jump-scan along with a LIKE predicate of 
zero length on an indexed column. 
 
Failing instruction at 000007FEF1E196DA offset: 00000000000000FA 
in <sqlriGapResetState> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqri\inc\sqlri_int_inlines.h: 
442> 
 
StackTrace: 
 
offset: 00000000000000FA in <sqlriGapResetState> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqri\inc\sqlri_int_inlines.h: 
442> 
offset: 0000000000000157 in <sqlriGapInit> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqri\sqlri_skipscan.C:1101> 
offset: 0000000000000573 in <sqlriopn> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqri\sqlri_aux.C:2643> 
offset: 00000000000007D6 in <sqlrita> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqri\sqlri_tbl.C:4923> 
offset: 00000000000001F2 in <sqlriSectInvoke> 
<T:\db2_v101fp4\ntx64\s140509\engn\include\sqlriManageSections.h 
:1588> 
offset: 00000000000001A2 in <sqlrr_process_fetch_request> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqr\sqlrr_req_sql.C:6967> 
offset: 000000000000092D in <sqlrr_open> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqr\sqlrr_req_sql.C:2403> 
offset: 000000000000043E in <sqljs_ddm_opnqry> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqjs\sqljsqry.C:1030> 
offset: 00000000000016F5 in <sqljsParse> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqjs\sqljspar.C:429> 
offset: 00000000000002BE in <sqljsSqlam> 
<T:\db2_v101fp4\ntx64\s140509\engn\sqjs\sqljsqam.C:2220> 
... 
 
To avoid the trap, ensure your LIKE expressions are not zero 
length.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 5.                      * 
****************************************************************

To avoid the trap, ensure your LIKE expressions are not zero 
length. 
or use: 
db2set DB2_REDUCED_OPTIMIZATION="JUMPSCAN OFF"

First fixed in DB2 Version 10.1 Fix Pack 5.

not known / see Local fix

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

24.10.2014
14.07.2015
14.07.2015