JR58369: DB2 CONNECTOR IN SERVER JOB CANNOT BULK LOAD NON-ASCII CHARACTERS WITH DEL FILE TYPE.

APAR status

• Closed as program error.

Error description

• DB2 Connector in Server job cannot bulk load non-ASCII
  characters (like Korean character Hangul) with DEL file type.
  

Local fix

• Use ASC file type.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DB2 connector users loading non-ASCII data in 'server' type jobs
  using DEL file with DB2 client code page different from
  operating system code page on DataStage engine server.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When bulk loading data into DB2 database using DB2 connector in
  a server job, preparation of delimited (DEL) data file for the
  load operation corrupts non-ASCII characters from input data.
  DataStage job finishes without error, but data in the database
  is corrupted.
  
  
  ****************************************************************
  RECOMMENDATION:
  Install APAR JR58369 patch.
  ****************************************************************
  

Problem conclusion

• DB2 Connector has been fixed to correctly convert input text
  data and store it in the intermediate DEL data file.
  

Temporary fix

• N/A
  

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

• RB50 PSY

     UP