Hi,
We are processing a data volume of more than 100 million records with each record having 304 columns. The business rules require them to be in a sorted manner.
So, any performance improvement suggestion to be incorporated in the sort stage. Tried with keeping "Stable Sort" as False & increasing the "Restricting Memory Usage" option but haven't got more than 4000 rows/sec.
Thanks in advance !
Sortung on voluminous data
Moderators: chulett, rschirm, roy
Sortung on voluminous data
Rgds,
MB
MB
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Just out of curiosity, how fast does the UNIX sort command sort this volume of data? Do you have any third-party sort utilities, such as SyncSort or CoSort, available?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.