JR33046: INCORRECT BUFFER LENGTH IN ODBC EE STAGE CAUSES SIGBUS AND SIGSEGV

APAR status

• Closed as program error.

Error description

• A PX ODBC EE job can fail with SIGSEGV or SIGBUS errors when
  varchar/char columns with the extended attribute of unicode are
  used.
  
  The problem is caused by an incorrect buffer size calculation
  being performed for this data types
  

Local fix

• Either remove the 'Unicode' attribute or set the debugging
  attribute of 'APT_DEBUG_MODULE_NAMES' set to 'odbcread
  odbcwrite'.
  
  This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All platforms, ODBC jobs with unicode columns
  ****************************************************************
  PROBLEM DESCRIPTION:
  ODBC Upsert job aborts with SIGBUS error when there are columns
  with type char/varchar with unicode extension and NLS map is
  IOS-8859-1
  ****************************************************************
  RECOMMENDATION:
  Install patch for JR33046
  ****************************************************************
  

Problem conclusion

• RESOLUTION: Ustring data type not being handled correctly in
  ODBC upsert operator. Modified code to allocate sufficient
  buffer for binding parameters.
  

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:

Modules/Macros

• ODBC EE
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP