On 9 Oct 2012 08:16:21 -0700, in bit.listserv.ibm-main Chris Blaicher wrote:
Are the manuals for SYNCSORT available on-line, especially any for UNIX. I have fond memories of the power of the version for HP-UX. Clark Morris >Yes, you could say that, but there are trade-offs. > >When dealing with the EQUALS option, a field is internally added to each >record by the sort. That is more data that has to be carried around >internally and on the SORTWK files. > >Consider that to accommodate over 4 billion rows, that increased the DASD >requirements by at least 8G. Please note - I made an error in my previous >post. DB2 Sort and SyncSort can accommodate 2**48 records, not 2**40 records. > >When the amount of data approaches 256 trillion records, I am sure we will >accommodate it. Will we jump to a full 2**64? Probably, but that remains to >be seen. > >When I started with Syncsort, a 100 MegaByte sort was BIG and a 4 billion >record sort was unthinkable. Now a 100M sort can be an in-core sort. What >will the future bring? I certainly don't know, but at the rate data is >growing, in the not too distant future we will look at a 4 billion record sort >and consider it normal. > >Chris Blaicher >Senior Software Engineer, Software Services >Syncsort Incorporated >50 Tice Boulevard, Woodcliff Lake, NJ 07677 >P: 201-930-8260 | M: 512-627-3803 >E: cblaic...@syncsort.com > >> rest snipped ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN