JR53689: NETEZZA CONNECTOR READ JOBS MIGHT HANG OR ABORT WHEN COLUMN(S) HAVING NULL VALUES ARE DROPPED

InfoSphere Information Server, Version 11.5 for Linux
InfoSphere Information Server, Version 11.5.0.1 for Windows
InfoSphere Information Server, Version 11.5.0.2 for Linux
InfoSphere Information Server, Version 11.5.0.2 for AIX
InfoSphere Information Server, Version 11.5.0.2 for Windows
InfoSphere Information Server, Version 11.5.0.1 for AIX

APAR status

• Closed as program error.

Error description

• In a Netezza Connector read job, if the selected column is not
  mentioned in the Columns tab, those columns will be dropped.
  However, if those dropped columns contain NULL value(s), the job
   may hang or abort.
  

Local fix

• Make sure that all the selected columns in the SELECT statement
  are mentioned in the Columns tab of the Netezza Connector stage.
  OR
  Adjust the user defined SELECT query to select only those
  columns which are mentioned in the Columns tab of the Netezza
  Connector stage.
  

Problem summary

• In a Netezza Connector read job, if the selected column is not
  mentioned in the Columns tab, those columns will be dropped.
  However, if those dropped columns contain NULL value(s), the job
  may hang or abort.
  

Problem conclusion

• Code has been corrected to overcome this problem.
  

Temporary fix

• Make sure that all the selected columns in the SELECT statement
  are mentioned in the Columns tab of the Netezza Connector stage.
  OR
  Adjust the user defined SELECT query to select only those
  columns which are mentioned in the Columns tab of the Netezza
  Connector stage.
  

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

• R870 PSY

     UP

• R910 PSY

     UP

• R912 PSY

     UP