JR61829: DB2 CONNECTOR IS NOT ABLE TO CREATE CHARACTER COLUMN WITH CODEUNITS32 QUALIFIER

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as new function.

Error description

• DB2 Connector has functionality to create or replace database
  table when connector is configured as target. The database
  table definition is built from the table design defined in the
  stage. When the character column datatype is used it is
  possible to select "Unicode" extended property. In such case,
  instead of CHAR or VARCHAR datatype, respectively, the GRAPHIC
  or VARGRAPHIC datatype is used. This behavior allows to store
  each character using two bytes but it is not possible to crete
  a column with 4-bytes for each character: CHAR(size
  CODEUNITS32) or VARCHAR(size CODEUNITS32).
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DB2 Connector users (re)creating tables containing columns with
  "Unicode" extended attribute in DataStage connector design
  ****************************************************************
  PROBLEM DESCRIPTION:
  DB2 Connector has functionality to create or replace database
  table when connector is configured as target. The database table
  definition is built from the table design defined in the stage.
  When the character column datatype is used it is possible to
  select "Unicode" extended property. In such case, instead of
  CHAR or VARCHAR datatype, respectively, the GRAPHIC or
  VARGRAPHIC datatype is used. This behavior allows to store each
  character using two bytes but it is not possible to create a
  column with 4-bytes for each character: CHAR(size CODEUNITS32)
  or VARCHAR(size CODEUNITS32).
  ****************************************************************
  RECOMMENDATION
  Install patch JR61829
  ****************************************************************
  

Problem conclusion

• The new environment variable
  CC_DB2_HANDLE_UNICODE_AS_CODEUNITS32 has been introduced. When
  the variable is defined and set to "TRUE" or "1", each column
  with the "Unicode" extended property set, will be created in
  database as CHAR(size CODEUNITS32) or VARCHAR(size CODEUNITS32).
  
  Limitation: It is not possible to generate table SQL statement
  with CODEUNITS32 qualifier using "Generate" button in the
  connector confguration dialog if the environment variable is set
  on job or project level.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• RB70 PSY

     UP

• RB71 PSY

     UP