DB2 FOR LUW / DB2FORLUW / A10 - DB2

A typical trap file may show the following stack trace: 
 
sqlnq_pid11fixed_value 
address: 0x00007FA4743DF010 
sqlnr_pred_like_rewr 
sqlnr_gen_twin_prd 
address: 0x00007FA474334D9C 
sqlnr_optprep_chunk2_action 
sqlnr_seq 
sqlnr_rcc 
sqlnr_exe 
sqlnn_cmpl 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlrr_prepare 
 
3 conditions: 
1) An OR predicate where at least one operand it a LIKE 
predicate 
2) The search-string or pattern-string of the LIKE predicate to 
be based on expression, or on a column from a sub-select or view 
that is based on expression. 
3) The expression from (2) will contain another LIKE predicate 
that either involves all constants. 
 
For example 
 
 where case 
       when 'Run Report' NOT LIKE '%View Report' then c10 
       else v10 
       end like '%abcd%' 
    or c10nn = 'helloabc'

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1fp5                                      * 
****************************************************************

N/A

not known / see Local fix

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

26.01.2015
15.07.2015
15.07.2015