DB2 FOR LUW / DB2FORLUW / B10 - DB2

- Create a new unicode database

- Update the database configuration
db2 update db cfg for  using string_units
codeunits32

- Restart the database
db2stop
db2start

- Define an 8k bufferpool and an 8k temporary table space

db2 create bufferpool test12  size 2000 pagesize 8k
db2 create system temporary tablespace test12t  pagesize 8k
bufferpool test12

- Run the runGSEDemo, it will result in an error in enablement:

Want to abort if any error occurs?(y/n) DEFAULT = y: y
==========> Initializing the Spatial Extender runGseDemo program
...
--- FATAL ERROR, Attempting to rollback transaction --
>--- ERROR -- RC= -1 Reported from runGseDemo.c, line 512
------------
         SQLSTATE: 42611
Native Error Code: -604
[IBM][CLI Driver][DB2/NT64] SQL0604N  The length, precision, or
scale attribute
for column, distinct type, structured type, array type,
attribute of structured
type, routine, cast target type, type mapping, or global
variable "VARCHAR(32672
)" is not valid.  LINE NUMBER=1.  SQLSTATE=42611

- The demo program uses a varchar variable length that is too
long when STRING_UNITS are set to CODEUNITS32.
Note that if the database configuration parameter STRING_UNITS
is set to SYSTEM, there is no problem running the demo.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher               *
****************************************************************

Run the runGSEDemo using a database that does not have
STRING_UNITS=CODEUNITS32 set.

not known / see Local fix

forerunner  : IT17827 
follow-up : 

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

02.10.2017
24.10.2017
24.10.2017