Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Multi volume SORTWKnn datasets

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8620
Location: Back in jolly old England

PostPosted: Wed Dec 10, 2008 7:18 pm    Post subject: Multi volume SORTWKnn datasets
Reply with quote

One for our DFSORT development / support guys.

Having tried and also later read through the manual and saw that although SORTWKnn datasets may be multi volume, only the space allocation made upon the first volume will be used by DFSORT.

Are there any plans for DFSORT to support/utilise multi volume work datasets. The problem I encountered was when using PROC SORT within SAS which called to use DFSORT. Unfortunately there is a restriction within SAS that a maximum of 6 SORTWKnn datasets will be used - even though more can be allocated.

The required sortwork space and more was readily available, but was spread over 32 volumes of which SAS restriced me to using only 6 so had constant failures with SB37 on the SORTWKnn DDs.

The file was 49.5 million records, F, LRECL 1420.
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Dec 10, 2008 11:39 pm    Post subject:
Reply with quote

Quote:
Are there any plans for DFSORT to support/utilise multi volume work datasets.


No.

Quote:
Unfortunately there is a restriction within SAS that a maximum of 6 SORTWKnn datasets will be used - even though more can be allocated.


That's an odd restriction considering that DFSORT can use up to 255 work data sets. Are these SORTWKnn DD data sets? If so, I wonder if you could get around the restriction by removing the SORTWKnn DD data sets and using:

Code:

//DFSPARM DD *
  OPTION DYNALLOC=(,32)


Perhaps that will allow DFSORT to use 32 dynamically allocated work data sets without SAS interfering? (That's just a guess - I have no knowledge of how SAS works.)

If that doesn't work, then I suggest you contact SAS and complain about THEIR restriction.
Back to top
View user's profile Send private message
Dave Betten

New User


Joined: 24 Jan 2006
Posts: 26

PostPosted: Wed Dec 10, 2008 11:51 pm    Post subject: Reply to: Multi volume SORTWKnn datasets
Reply with quote

Unfortunately we do not have plans to support multi-volume sortwork data sets. However, I believe you can get past the limit of 6 sortworks by doing the following.

Pass the option DYNALLOC to SAS which says to let the sort program allocate the work data sets.

Add the following to your JCL to tell DFSORT how many work data sets to use.

//DFSPARM DD *
OPTION DYNALLOC=(,32)
/*


This should cause DFSORT to dynamically allocate 32 sortwork data sets instead of the SAS program allocating its own work data sets for DFSORT to use.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8201
Location: Dubuque, Iowa, USA

PostPosted: Wed Dec 10, 2008 11:52 pm    Post subject:
Reply with quote

Quote:
SAS restriced me to using only 6
What does your SORTWKNO option in SAS look like? Did you try running
Code:
PROC SORT ... SORTWKNO=12;
to see if you can get more than six?

This must be a site restriction -- we regularly use up to 12 volumes in SAS sorts and other than people trying to run 5 or 6 sorts of 30 million records at the same time, we don't have many issues with sort work space.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8620
Location: Back in jolly old England

PostPosted: Thu Dec 11, 2008 12:16 pm    Post subject:
Reply with quote

Hi guys,

Thank you for the responses. Much appreciated.

Robert, yes I did try to use the OPTION SORTWKNO= parameter but it was rejected. Will rerun and try putting the parameter in the PROC SORT as you have shown.

I will also try to use the parameters given above and post back the results.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8620
Location: Back in jolly old England

PostPosted: Fri Dec 12, 2008 12:54 pm    Post subject:
Reply with quote

Thank you gentleman,

The insertion of the DFSPARM DD into the JCL worked, although I did also have to specify the SAS system option of SORTPGM=SORT to prevent the SAS sort program from making the SORTWK allocations and using the maximum of 6 restriction.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8201
Location: Dubuque, Iowa, USA

PostPosted: Fri Dec 12, 2008 6:02 pm    Post subject:
Reply with quote

Great to hear you got it to work -- sometimes SAS option settings can be tricky since it can get pretty deep into the system ... sigh.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8620
Location: Back in jolly old England

PostPosted: Fri Dec 12, 2008 7:06 pm    Post subject:
Reply with quote

Yes, eventually. Still managed to retain a couple of handfulls of hair too icon_lol.gif

Obviously each and every site has its own base settings for OPTIONS, and the bit that got me was when I first tried the fix suggested by Frank / Dave, and it failed. Only after finding the part about SORTPGM=SORT to totally bypass any actions from the SAS product sort did it work.

Who says that you can't teach an old dog new tricks icon_lol.gif
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8201
Location: Dubuque, Iowa, USA

PostPosted: Fri Dec 12, 2008 7:17 pm    Post subject:
Reply with quote

Quote:
Who says that you can't teach an old dog new tricks
Uh ... arf? I learn new stuff every day!
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10375
Location: italy

PostPosted: Fri Dec 12, 2008 7:29 pm    Post subject: Reply to: Multi volume SORTWKnn datasets
Reply with quote

it' s much easier to teach an old dog new tricks than the other way around icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISMF Difference between volume count ... upendrasri IBM Tools 2 Tue Dec 05, 2017 12:40 pm
No new posts REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm
No new posts RMM: scratching a volume that RMM thi... Hervey Martinez IBM Tools 0 Mon May 15, 2017 8:51 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us