JR35725: DB2 CONNECTOR STAGE, BULK LOAD OPTION BULK LOAD WITH LOB OR XML COLUMNS=FALSE. CHARACTER 0X00 LOADS AS 0X20.

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• Db2 connector Stage 8.1 rollup patch 2. Target table contains a
  char(1) column. Bulk load is used with lob or XML
  column(s)=false.
  
  Control character 0x00 is load (transfomer is used setting value
  as char(0). This character is load as a space, 0x20.
  

Local fix

• Use insert.
  

Problem summary

• ****************************************************************
  
  USERS AFFECTED:
  The issue occurs when using UDB LOAD stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  The UDB LOAD stage does not correctly handle input data
  containing 0x0 characters.
  ****************************************************************
  RECOMMENDATION:
  Install patch_JR35725
  ****************************************************************
  

Problem conclusion

• The issue has been fixed by patch_JR35725. DB2 UDB Load now
  handles the 0x00 character in 'Char' field correctly.
  

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

• R810 PSY

     UP