JR31361: UTF-8 SUPPORT FOR TERADATA, ALSO, AS PER REQUEST FROM RAVI, RASING APAR FOR KNOWN ISSUE/PREVIOUS PATCH TO BE PORTED TO AIX.

APAR status

• Closed as program error.

Error description

• UTF-8 support for Teradata, also, as per request from Ravi,
  rasing APAR for known issue/previous patch to be ported to AIX.
  

Local fix

• None, however workaround of:
  
  enter the following settings in "Teraata CLI settings file:
  "/usr/lib/clispb.dat" and then run TD-EE job.
  
  ============
  charset_type=N
  charset_id=UTF8
  ============
  
  And set the ENV-VAR: "COPLIB" with the value "/usr/lib" (i.e.,
  to the folder containing the "clispb.dat" file, having the above
  settings).
  
  As been suggested and forwarded to customer, awaiting their
  response.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users, running TD-EE jobs with NLSMap set to UTF-8.
  ****************************************************************
  PROBLEM DESCRIPTION:
  TDEE not loading the UTF-8 data correctly.
  ****************************************************************
  RECOMMENDATION:
  This fix is included in Information Server 81 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• Issue with "parcel sizes" while handling UTF-8 encoded data.
   Issue fixed now and found that both load and export jobs are
  writing & reading UTF-8 data 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

• R801 PSN

     UP