Sort Capacity Exceeded.....heavy sigh

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Sort Capacity Exceeded.....heavy sigh

Postby BLJ » Wed Oct 24, 2007 6:30 am

I am trying to find the right fit for sorting large files and the sort Options. I'm running 64-bit architecture with 8GB of memory. I know the change to 64-bt changed many of the ways sort (and other tasks) use memory since it is now all central storage (no more expanded). I've tried a variety of tweaks based on the DFSORT 1.5 Tuning Manual, info APARs, DB2 tuning references (one DB2 sort ate all the aux. storage - the sortworks accidentally went to VIO) and can't seem to find a good fit. I also have the problem of what else is running on the system with regard to memory allocations: I can run a sort on a quiet system but not when it is busy. This leads me to think the sort options are requesting too many resources but adjusting down doesn't work either. I'm simply trying to figure out the type of options that will work for the majority of Sorts performed. There are a lot more 'capacity exeeced' issues now that 64-bit is around and DB2 V8 utilities are munching I'm very confused about the variety of recommendations in the documentation for DFSORT and other products, e.g., DB2 that invoke DFSORT. Is there somewhere to find ROT without other product bias? Or understandable calculations to apply?
Thanks in advance. :roll:
Posts: 1
Joined: Tue Oct 23, 2007 3:37 am
Has thanked: 0 time
Been thanked: 0 time

Re: Sort Capacity Exceeded.....heavy sigh

Postby Frank Yaeger » Wed Oct 24, 2007 8:46 pm

The answer is specific to your environment and can't really be answered in a "general" way. I'd suggest you open a PMR ("problem report") with IBM service so they can help you by collecting the needed information about your environment and doing an appropriate analysis.
Frank Yaeger - DFSORT Development Team (IBM) -
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at
User avatar
Frank Yaeger
Global moderator
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times



  • Related topics
    Last post