DB2 FOR LUW / DB2FORLUW / A50 - DB2

When connected to a database from any node other than the 
catalog node, the NLS_STRING_UNITS session variable is not 
functional.  Assignments can be made to the session variable, 
but the current value of the session variable has no impact on 
the default string units of the user environment. 
 
For example, when NLS_STRING_UNITS is set to 'CODEUNITS32' the 
default string units when defining a character string should be 
CODEUNITS32.  The CREATE TABLE statement in the scenario below 
demonstrates that CODEUNITS32 is not the default. 
 
SET NLS_STRING_UNITS='CODEUNITS32' 
DB20000I  The SQL command completed successfully. 
 
CREATE TABLE T1 (C1 VARCHAR(10)) 
DB20000I  The SQL command completed successfully. 
 
select colname, typename, typestringunits, stringunitslength, 
length from syscat.columns where tabname = 'T1' 
 
COLNAME              TYPENAME             TYPESTRINGUNITS 
STRINGUNITSLENGTH LENGTH 
--------------------       -------------------- 
---------------              ----------------- 
----------- 
C1                             VARCHAR              OCTETS 
10                           10 
 
   1 record(s) selected. 
 
The column C1 should have the data type VARCHAR(10 CODEUNITS32), 
which means the TYPESTRINGUNITS should be 'CODEUNITS32', the 
STRINGUNITSLENGTH should remain as 10, and the LENGTH should be 
40.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users in a DPF environment                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 10.5 Fix Pack 7.                          * 
****************************************************************

As a workaround, the user can manually provide the CODEUNITS32 
keyword when CODEUNITS32 string units are required.  For 
example, when creating a table: 
 
CREATE TABLE T1 (C1 VARCHAR(10 CODEUNITS32))

First fixed in Version 10.5 Fix Pack 7.

not known / see Local fix

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

23.03.2015
26.01.2016
28.04.2016