JR41984: REDUCED MEMORY CONSUMPTION OF SORT STAGE ON SERVER CANVAS

IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• SORT stage consumes huge temporary space when row size has large
  variations
  Problem is seen only when row has character/binary data and
  varying row size.
  Size allocated / record is more then actual record size
  

Local fix

Problem summary

• Reduced memory consumption of SORT stage on server canvas
  SORT stage consumes huge temporary space when row size has large
  variations.
  Problem is seen only when row has character/binary data and
  varying row size.
  Actually size allocated per record is more then actual record
  size.
  

Problem conclusion

• Memory allocated per record now limited to size of actual
  record, resulting in reduced memory and temporary space
  consumption.
  Good performance improvement seen when records size has very
  large variation.
  

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

• R870 PSN

     UP