On 14 Jun 2012 12:49:54 -0700, in bit.listserv.ibm-main you wrote: >Dave, > >You asked what should be done if you were using SyncSort. I would recommend >that you set the DYNALLOC to 64. SyncSort will not allocate that many SORTWKs >unless it actually needs them so you don't need to work about using space you >will not need. I would also recommend that you pass VSCORET=96M. A sort of >this size would benefit from the extra space. My final recommendation would >be to pass BMSG. This will produce diagnostic messages that could be used to >ensure the sort is running properly. > >You can put these all in a $ORTPARM DD. It would be: > >DYNALLOC=(SYSDA,64),VSCORET=96M,BMSG > >If you are not happy with the performance let me know and we can work with you >on it.
This response brought up a question I have had because I am interested in the manuals for SYNCSORT on UNIX systems. I found the capabilities of it on a HP-UX system where I worked for better than those on z/OS. Clark Morris > >John Reda >Syncsort, Inc. > >-----Original Message----- >From: IBM Mainframe Discussion List [mailto:[email protected]] On >Behalf Of Gibney, Dave >Sent: Thursday, June 14, 2012 3:33 PM >To: [email protected] >Subject: DFSORT 180M recs > >This is for a friend at another installation. I Sync rather than DF, so I'm >not the best to answer the question. I have already asked for the error >message detail :) I've also said to not use the FILSZ parm and let DFSORT >figure it out. > >I am having trouble getting dfsort to sort 180,000,000 records. I think it is >failing for a lack of space. The records have an average length of 261 bytes. > The key is the first 25 characters of the record and there should be no >duplicates. The dfsort parms I have tried include: > >OPTION MAINSIZE=64M,DYNALLOC=(SYSDA,20), >FILSZ=E180000000,AVGRLEN=261 > >The DYNALLOC tells the sort to create 20 sortwork files. Maybe I need to >create 50 sortwork files? FILSZ tells sort approximately how many records are >to be sorted and sort is supposed to get the space it needs to do it. >If you were going to sort this in syncsort how would you do it? > >One idea I had was to break the main file up into 30 million record groups. >Sort those and then merge them back together into one file. I haven't tried >that yet. It seems like I should be able to sort the large number of records. > > >Dave Gibney >Information Technology Services >Washington State University > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, send email to >[email protected] with the message: INFO IBM-MAIN > > > >ATTENTION: ----- > >The information contained in this message (including any files transmitted >with this message) may contain proprietary, trade secret or other >confidential and/or legally privileged information. Any pricing information >contained in this message or in any files transmitted with this message is >always confidential and cannot be shared with any third parties without prior >written approval from Syncsort. This message is intended to be read only by >the individual or entity to whom it is addressed or by their designee. If the >reader of this message is not the intended recipient, you are on notice that >any use, disclosure, copying or distribution of this message, in any form, is >strictly prohibited. If you have received this message in error, please >immediately notify the sender and/or Syncsort and destroy all copies of this >message in your possession, custody or control. > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
