DB2 FOR LUW / DB2FORLUW / A50 - DB2

Under certain circumstances a query may fail during execution 
with the following error: 
 
SQL0901N  The SQL statement or command failed because of a 
database system error. (Reason "(LIKE: search pattern structure 
is NULL) ".)  SQLSTATE=58004 
 
This can happen when the query satisfies all of the following: 
 
- The query includes a LIKE predicate or a reference to one of 
the following builtin functions: LOCATE, POSITION, POSSTR, 
INSTR, INSTRB, INSTR2, INSTR4 or LOCATE_IN_STRING 
- The search pattern for the LIKE expression or search string 
for the builtin function above is an expression that includes a 
non-nullable column reference 
- The non-nullable column is also referenced in an equality 
predicate where the other side is a parameter marker or nullable 
host variable 
 
For example, assuming column T2.C1 is not nullable: 
 
SELECT * FROM T1, T2 
WHERE T1.C1 LIKE T2.C1 and T2.C1 = ?

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4                       * 
****************************************************************

Replace the parameter marker or host variable with a literal. 
Note that this will only work if the statement concentrator is 
disabled

First fixed in Version 10.5 Fix Pack 4

not known / see Local fix

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

01.05.2014
17.03.2015
17.03.2015