Joined: 21 Jun 2006 Posts: 9 Topics: 4 Location: Bangalore
Posted: Tue Jul 04, 2006 3:38 am Post subject: SORT work files
Hi,
Using Sort work files lets us process more records and also I believe it speeds up sorting.
I there any startndard to be followed while giving the size of Work files?
Also how do we decide how many work files to use for any sort?
Any input on this will be really helpful.
Joined: 21 Jun 2006 Posts: 9 Topics: 4 Location: Bangalore
Posted: Wed Jul 12, 2006 6:56 am Post subject:
Hi,
This is the sort job i submitted without WORK files and the input has 8103330. And I got the message saying Sort capacity exceeded. And when I gave Work files and ran it again, it ran to success.
IF DFSORT does dynamic allocation of Work files, then why am I getting SB37 abend?
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Wed Jul 12, 2006 10:14 am Post subject:
Deepa,
You haven't given me enough information to answer your question. It's possible that your site "disabled" dynamic allocation of work data sets, or doesn't have enough space for the needed work data sets, or it could be some other reason.
If you want me to take a look, please add the following to your job to get diagnostic messages:
//SORTDIAG DD DUMMY
rerun it, and send me the JES and //SYSOUT messages offline (yaeger@us.ibm.com). Please put "DFSORT" somewhere in your Subject line to catch my attention. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
