Distributing the load across SORTWORK files

[Joe Boyle]

I'm pretty certain the PH only ever uses sortwork0 and sorwork1, regardless of how many sort files you define. So using VMS sort after writing to a flat (sub)file, i.e. non-indexed but including data dictionary, would be a good way to go. There is nothing to stop you VMSsorting the subfile data file component, and then accessing the now sorted subfile and continue with other processing.
  ----- Original Message ----- 
  From: John Stires 
  To: powerh-l at lists.sowder.com 
  Sent: Wednesday, May 17, 2006 8:00 PM
  Subject: Distributing the load across SORTWORK files


  We are doing a very large sort in quiz.  It consistently runs for a time and then dies.  We have 10 SORTWORK files defined, but only one seems to be used.  It grows to several million blocks before the process dies.  The others are virtually untouched.

  We are running OpenVMS V6.2 with PowerHouse version 7.10E6.

  Does anyone have a suggestion on how to distribute the sort load across multiple SORTWORK files.


  Thanks in advance for any help any of you can offer on this.

  John Stires


------------------------------------------------------------------------------


  -- 
  = = = = = = = = = = = = = = = = = = = = = = = = = = = =
  Mailing list: powerh-l at lists.sowder.com
  Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
  Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
  http://lists.sowder.com/mailman/listinfo/powerh-l
  This list is closed, thus to post to the list you must be a subscriber.
  Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060521/5289b9fa/attachment.html