SORT WORK SPACE ISSUE.



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

SORT WORK SPACE ISSUE.

Postby Vineet » Fri Apr 24, 2015 12:48 am

Hi All,
I am having a File with Record Count = 115 Million, LRECL = 131, RECFM=FB. I want to SORT the File to eliminate duplicate records. I am Trying with Dynamic Allocation. Below is my Job Card.

//STPRDF11 EXEC PGM=SORT,PARM='FILEZ=E550000000,DYNALLOC=(SYSDA,32)',
// COND=(4,LT)

Job is failing with error "RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DATA SETS - Reason Code 58'. I tried using Tape for Temporary Workstorage, not sure how to do. I know It's recomended to use DASD not TAPE. Please suggest how to Sort Such a Big File.

Thanks
Kind Rgd's
Vineet
 
Posts: 86
Joined: Tue Jun 19, 2007 11:38 am
Has thanked: 0 time
Been thanked: 0 time

Re: SORT WORK SPACE ISSUE.

Postby enrico-sorichetti » Fri Apr 24, 2015 1:28 am

the only people who can help You are the people from the storage support!

look at the storage estimates for dfsort work files and find out if there is enough dasd space for them.

a very rough estimate should be around 20000 3390 cylinders ?

to be on the safe side around 10% more than the input dataset size

according to a table found in the dfsort manuals
for a FB file with a record size up to 160 bytes
MB 40, INPUT CYLS 51,workarea cyls 56
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3002
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: SORT WORK SPACE ISSUE.

Postby BillyBoyo » Fri Apr 24, 2015 2:02 am

Can you show a representative sample of the file, including a couple of duplicates?

Are you SORTing just to be able to use SUM FIELDS=NONE? How did the duplicates occur? Is there anything which can be used as a "key"
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post