JR40893: Netezza Enterprise Stage jobs does not pick code page other than ISO-8859-1 in Update mode

IBM InfoSphere Information Server, Version 8.7 Fix Pack 1
IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• Netezza Enterprise stage job can not load to a table with Hangul
  name if Write Method set to Update, it fails with next error.
  
     Item #: 41
     Event ID: 123
     Timestamp: 2011-10-10 10:10:10
     Type: Warning
     User Name: dsadm
     Message Id: IIS-DSEE-TFCC-00016
     Message: main_program: Invalid character(s) ([xACE0]) found
  converting Unicode string (code point(s): ) to codepage
  ISO-8859-1, substituting.
  nzodbcDriverInterface.C:370
  select * from F_??????? LIMIT 10;
  nzodbcDriverInterface.C:373
   NativeError - Msg :: 118649410936 :: ERROR:  'select * from
  F_??????? LIMIT 10'
  error                    ^ found "?" (at char 17) expecting
  `EXCEPT' or `FOR' or `INTERSECT' or `ORDER' or `UNION'   Index
  1
  nzodbcDriverInterface.C:378
  
  The same problem occurs if column with Hangul name exists in the
  target Netezza table.
  

Local fix

Problem summary

• Netezza jobs does not pick code page other then ISO-8859-1 in
  Update mode
  

Problem conclusion

• Now properly setting code page value passed in Netezza Update
  operator.
  Install patch from APAR JR40893.
  

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

• R850 PSY

     UP

• R810 PSN

     UP

• R870 PSN

     UP