DB2 FOR LUW / DB2FORLUW / A50 - 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 version 10.5 fix pack 9                       * 
****************************************************************

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

First fixed in DB2 version 10.5 fix pack 9

not known / see Local fix

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

01.12.2016
27.09.2017
12.10.2017

9.0.