DB2 FOR LUW / DB2FORLUW / A50 - DB2

When a column is defined as VARGRAPHIC with string length unit
CODEUNITS32,
it's possible to insert longer-than-allowed values.  For
example:

     create table T (c1 graphic(5 codeunits32),
                           c2 vargraphic(5 codeunits32) );

     insert into T values ('abcdefghij','abcdefghij');
     DB20000I  The SQL command completed successfully.

****************************************************************
* USERS AFFECTED:                                              *
* TABLES WITH VARGRAPHIC CODEUNITS32  columns                  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* See Error Description. Please, install this fix.             *
****************************************************************

In the INSERT statement, explicitly cast constant values to
VARGRAPHIC, e,g.:

     insert into T values
(VARGRAPHIC('abcdefghij'),VARGRAPHIC('abcdefghij'));
     SQL0433N  Value "abcdefghij" is too long.  SQLSTATE=22001

Alternatively, enable the statement concentrator, this replaces
the constant value with a parameter marker:

  db2 update db cfg for  using stmt_conc literals

not known / see Local fix

forerunner  : 
follow-up : IT29941 IT29945 

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

07.08.2019
28.06.2020
28.06.2020