DB2 FOR LUW / DB2FORLUW / B10 - DB2

Insert or update may cause wrong result when the target table 
has a GENERATED ALWAYS expression that references a built-in 
function with more than one string input. 
 
example: 
 
create table t1 ( 
  i int, 
  c1 varchar (18), 
  c2 varchar (18) GENERATED ALWAYS AS 
     (sysibm.ltrim( c1, X'E6BCA2' ) )); 
 
 
create or replace variable v varchar(18) for bit data; 
 
set v = X'E6BCA2E6BCA1'; 
 
insert into t1 values (1, v, default ); 
insert into t1 values (2, X'E6BCA2E6BCA1', default ); 
 
select hex(c1), hex(c2 ) from t1 order by i; 
 
1                                    2 
------------------------------------ 
------------------------------------ 
E6BCA2E6BCA1                         A1 
E6BCA2E6BCA1                         E6BCA1 
 
  2 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 11.1 Mod1 Fix Pack 1 iFix001                  * 
****************************************************************

Avoid using function with more than one string argument  in the 
definition  OF GENERATED ALWAYS 
column

DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
 DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

First fixed in DB2 11.1 Mod1 Fix Pack 1 iFix001

not known / see Local fix

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

30.11.2016
01.05.2017
21.06.2017