Hi
I have problem with sort. My job fails always saying "SORT CAPACITY EXCEEDED". Log is as follows:
EXCP ACCESS METHOD USED FOR SORTOUT
EXCP ACCESS METHOD USED FOR SORTIN
DC 255482332 TC 0 CS DSVUU KSZ 47 VSZ 47
FSZ=2870588 RC IGN=300000 E AVG=96 0 WSP=357926 C DYN=0 0
SORT CAPACITY EXCEEDED - RECORD COUNT 2870420
DE-K10929 D5-K05352 E8-K11698
END OF DFSORT
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Suggest you increase the space allocatoin for the work files and the sortout dataset.
The process has estimates of 150k and 300k records, but sort failed messages menmtion RECORD COUNT 2870420 records before exceeding capacity. I'd try changing the trk specifcations to cyl. I'd also try an estimate of E3000000.
Good luck - someone will be here if ther are new opportunities
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
I'd also try an estimate of E3000000
The FILSZ estimate is NOT needed. DFSORT has determined the filesize automatically, so it ignores the estimate.
Quote:
I'd try changing the trk specifcations to cyl.
Yes, it woud be better to use CYL, but with TRK DFSORT will reallocate the work data sets to cylinders automatically.
Quote:
Suggest you increase the space allocatoin for the work file
That would be one approach. A better approach would be to remove the SORTWKdd DD statements and let DFSORT allocate the work space dynamically. The default number of work data sets will probably work fine, but if more work data sets are needed, the maximum can be specified using DYNALLOC=(,n). For example, if a maximum of 8 work data sets are needed, use: