JR60586: PARALLEL JOB THROWS A WARNING WHEN USING CLUSTER KEY CHANGE COLUMN IN A SORT STAGE ON A SORTED DATA

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• Sort Stage after a leading Sort Stage throws the warning:
  "When checking operator: The sort stage re-sorts the data, even
  though the data is already in a sorted order.
  To improve performance, remove this sort stage or uncheck the
  'Perform sort' option before you run the job."
  The sort role is to fill in the Cluster Key Change Column and
  there is no sort performed (Don't sort - previously sorted).
  Leading sort performs the actual sort however a warning is
  thrown. The warning flag may be misleading and should be only
  information message.
  

Local fix

• N/A
  

Problem summary

• ERROR DESCRIPTION:
  Sort Stage after a leading Sort Stage throws the warning:
  "When checking operator: The sort stage re-sorts the data, even
  though the data is already in a sorted order.
  To improve performance, remove this sort stage or uncheck the
  'Perform sort' option before you run the job."
  The sort role is to fill in the Cluster Key Change Column and
  there is no sort performed (Don't sort - previously sorted).
  Leading sort performs the actual sort however a warning is
  thrown. The warning flag may be misleading and should be only
  information message.
  

Problem conclusion

• A patch is available which change the message from a Warning to
  Informational.
  

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

• RB50 PSY

     UP

• RB70 PSY

     UP

• RB71 PSY

     UP