What I do for my very large DB2 SAS Processes is use the following
//DFSPARM DD DISP=SHR,DSN=SYSS.DFSORT.CNTLLIB(DFSORT) In the DFSORT member I just have coded OPTION DYNALLOC=(,32) I have removed all SORTWKxx or variation (you may be using SASSWKxx) in the SAS Proc or MXG Proc. Now I just let DFSORT figure out what it needs. Lizette > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Vernooij, CP (ITOPT1) - KLM > Sent: Monday, July 25, 2016 11:25 PM > To: [email protected] > Subject: Re: DFSORT DYNALLOC/DYNAPCT question > > Hi Dave, > > Thanks for the explanation. > We sometimes have problems with very large sorts from SAS 9.2, which known to > provide DFSORT with incorrect information about the amount of data to be > sorted. DFSORT then tries to recover from B37 abend which is mostly but not > always successful. > So I think I will raise DYNALLOC to 6 and also set DYNAPCT to 100, to help > DFSORT to handle large sorts that were provided with incorrect size info. > > Regards, > Kees. > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of David Betten > Sent: 26 July, 2016 8:12 > To: [email protected] > Subject: Re: DFSORT DYNALLOC/DYNAPCT question > > The dynamic allocation space calculations are going to be based on the > DYNALLOC number. As a simple example, if DFSORT calculates that it needs > 6,000 cylinders of work space, and DYNALLOC=4 with DYNAPCT=50, it will need > 4 volumes with at least 1500 cylinders of free space. But with DYNALLOC=6 and > DYNAPCT=10, it will need 6 volumes with at least 1,000 cylinders of free > space. The work data sets allocated for DYNAPCT are not factored into the > initial work space allocation. Rather they are allocated with zero space and > only extended later on if the sort unexpectedly requires more space and the > initial DYNALLOC work data sets have been exhausted. So my suggestion would > be to increase DYNALLOC to 6. > > > > Have a nice day, > Dave Betten > z/OS Performance Specialist > Cloud and Systems Performance > IBM Corporation > email: [email protected] > > > IBM Mainframe Discussion List <[email protected]> wrote on > 07/25/2016 04:30:16 AM: > > > From: "Vernooij, CP (ITOPT1) - KLM" <[email protected]> > > To: [email protected] > > Date: 07/25/2016 04:31 AM > > Subject: DFSORT DYNALLOC/DYNAPCT question Sent by: IBM Mainframe > > Discussion List <[email protected]> > > > > Hello DFSORT experts, > > > > The DYNALLOC description says that the default number of SORTWKs is > > 4 and not to specify an unnecessary high number. > > The DYNAPCT parameter allocates an extra number of SORTWKs to be used > > in case the DYNALLOC number of SORTWKs appears to be not enough. > > > > I can: > > > > a. raise the DYNALLOC default to 6 SORTWKs > > > > b. set the DYNAPCT value to 50 > > In each case 6 SORTWKs are allocated. What is the difference and what > > is advisable? > > > > Kees. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
