JR41761: THE NETEZZA CONNECTOR STAGE DOES NOT DELIVER SORTED DATA OUTPUT.

APAR status

• Closed as program error.

Error description

• Run the job sequentially to eliminate Datastage parallelism
  issues.
  After execution, review the query plans recorded by the netezza
  query log, it was noted here that the plans generated for the
  netezza connector stage statements do not contain a sort-node
  that would be expected to appear, having in mind that there
  appears one if you run the
  same query against netezza using aginity workbench.
  Is issue related to the use of named pipes for transferring the
  data from the netezza box
  to the DataStage-server? It appears that the netezza box ignores
  the order by clause when transferring data via named pipes.
  

Local fix

Problem summary

• When running a Netezza Connector source  context job using a
  user-defined select statement that contains and ORDER BY clause
  with the intention to return the results in a sorted way, the
  connector seems to ignore the ORDER BY clause and return the
  rows unsorted.
  

Problem conclusion

• Apply the patch to resolve the issue.
  

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 QUALITYSTAG

• Fixed component ID

  5724Q36QS

Applicable component levels

• R850 PSY

     UP

• R870 PSY

     UP