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. 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
