|
View previous topic :: View next topic
|
| Author |
Message |
jerryte
Active User
Joined: 29 Oct 2010
Posts: 202
Location: Toronto, ON, Canada
|
|
|
|
I was given some JCL to modify. It had an step to run ICETOOL SELECT statement. I think this does a sort of the data.
The jcl had 12 SORTWK## datasets. This seems excessive to me. The manual suggest that 3 to 4 is sufficient.
My question - is there a way to determine after the run of the step as to how many of the SORTWK datasets it actually used? If it only uses 2 then I can safely remove 8-10 of the datasets and reduce the clutter in the jcl. Or should I just leave well enough alone and let someone else foot the bill for all that dasd? |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| why not let sort allocate dynamically what it needs ? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
I've not done this in a while, but when the step deallocation info is gnerated (if this happens on your system), the excp counts for the datasets are shown.
Maybe this will help? |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
| Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
|
|
|
|
jerryte,
I would suggest going with DYNALLOC and let DFSORT calculate the required Storage required for Sorting.
ex:
| Code: |
OPTION DYNALLOC=(,6) |
|
|
| Back to top |
|
|
jerryte
Active User
Joined: 29 Oct 2010
Posts: 202
Location: Toronto, ON, Canada
|
|
|
|
Thanks for the tips. I will look into the dynamic allocation.
This is an issue where no harm is done by allocating more then what is needed. However allocating way too much means that someone has to pay for it. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
|
|
