DB2 FOR LUW / DB2FORLUW / A50 - DB2

The built-in scalar functions INSTR, LOCATE, LOCATE_IN_STRING 
and POSITION may return an incorrect result or fail with SQLCODE 
-901 when CODEUNITS16 or CODEUNITS32 is specified, e.g.: 
 
  values LOCATE(LOWER('eq'),'1eq3', CODEUNITS16) 
 
  1 
  ----------- 
            0 <- Wrong, should be 2 
 
    1 record(s) selected. 
 
  values LOCATE(UPPER('e'),'1EQ3', CODEUNITS32) 
  SQL0901N  The SQL statement or command failed because of a 
  database system error. (Reason 
  "(POSSTR: unable to precompile search pattern)".) 
  SQLSTATE=58004 
 
This can happen when the search-string is an expression that 
includes only literals and built-in functions.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5 fix pack 4                       * 
****************************************************************

Replace the search-string expression with a simple string 
literal

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in DB2 version 10.5 fix pack 4

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC98379 IC98380 
follow-up : 

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

05.12.2013
08.09.2014
08.09.2014