Re: "Sort Capacity Exceeded" thought / question
John, The answer is that it's a little of both... "technical reason" and "we didn't think of it". We are looking at ways to improve our dynamic allocation of work data sets to provide some additional flexibility. So it is on our list of things we'd like to improve on. Have a nice day, Dave Betten DFSORT Development, Performance Lead IBM Corporation email: bet...@us.ibm.com 1-301-240-3809 DFSORT/MVSontheweb at http://www.ibm.com/storage/dfsort/ IBM Mainframe Discussion List wrote on 12/21/2009 01:57:44 PM: > [image removed] > > Re: "Sort Capacity Exceeded" thought / question > > McKown, John > > to: > > IBM-MAIN > > 12/21/2009 02:02 PM > > Sent by: > > IBM Mainframe Discussion List > > Please respond to IBM Mainframe Discussion List. > > > -Original Message- > > From: IBM Mainframe Discussion List > > [mailto:ibm-m...@bama.ua.edu] On Behalf Of Lizette Koehler > > Sent: Monday, December 21, 2009 12:47 PM > > To: IBM-MAIN@bama.ua.edu > > Subject: Re: "Sort Capacity Exceeded" thought / question > > > > John, > > > > What is your current parameter for dynamic SortWKxx set at? > > Maybe you just need to increase that number? Or if you have > > one-off types, provide them with the SORT Over ride that > > could let them allow for more dynamically allocated sortwk. > > > > Lizette > > > > We have DYNALLOC set to 31. But this is in an ICEAM2 environment > (internal sort). Apparently the application does not pass an > accurate count to SORT. And, from what I can see, it does multiple > internal sorts. I did state a JCL error, but the error was not > having an SORTWKnn statements in the JCL at all. > > But that is not the prime reason for my inquiry. I am just curious > if this facility is not in sort for a technical reason, a business > reason, or a "we didn't think of that" reason. > > I do know how to fix it - we added a lot of large SORTWKnn DD statements. > > -- > John McKown > Systems Engineer IV > IT > > Administrative Services Group > > HealthMarkets(r) > > 9151 Boulevard 26 * N. Richland Hills * TX 76010 > (817) 255-3225 phone * (817)-961-6183 cell > john.mck...@healthmarkets.com * www.HealthMarkets.com > > Confidentiality Notice: This e-mail message may contain confidential > or proprietary information. If you are not the intended recipient, > please contact the sender by reply e-mail and destroy all copies of > the original message. HealthMarkets(r) is the brand name for > products underwritten and issued by the insurance subsidiaries of > HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid- > West National Life Insurance Company of TennesseeSM and The MEGA > Life and Health Insurance Company.SM > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: "Sort Capacity Exceeded" thought / question
I don't know about DFSORT but SYNCSORT has another parm for dynamic allocation besides regular work "McKown, John" To Sent by: IBM IBM-MAIN@bama.ua.edu Mainframe cc Discussion List "Sort Capacity Exceeded" thought / question 12/21/2009 01:30 PM Please respond to IBM Mainframe Discussion List Due to a mistake in JCL, one of our batch jobs got a "Sort Capacity Exceeded" message in DF/SORT on z/OS 1.10. So, I was just wondering about something. When this happens, why can't SORT just allocate another SORTWKnn DD and continue? I know that there is an upper limit on this, but then I got to wondering why SORT cannot simply reallocate an existing SORTWKnn? I guess it would need to copy the current contents to some other dynamically allocated DD, then reallocate and recopy the contents back in. Granted, the overhead on this would be large, but I would prefer it to abending a 4 hour sort. Especially if it were updating a non-recoverable resource, such as a VSAM file. Perhaps a required non-standard option in DFSPARM, as opposed to being able to specify it in the ICEMAC parm or dynamic PARMLIB parm? John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * (817)-961-6183 cell john.mck...@healthmarkets.com * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: "Sort Capacity Exceeded" thought / question
> -Original Message- > From: IBM Mainframe Discussion List > [mailto:ibm-m...@bama.ua.edu] On Behalf Of Lizette Koehler > Sent: Monday, December 21, 2009 12:47 PM > To: IBM-MAIN@bama.ua.edu > Subject: Re: "Sort Capacity Exceeded" thought / question > > John, > > What is your current parameter for dynamic SortWKxx set at? > Maybe you just need to increase that number? Or if you have > one-off types, provide them with the SORT Over ride that > could let them allow for more dynamically allocated sortwk. > > Lizette > We have DYNALLOC set to 31. But this is in an ICEAM2 environment (internal sort). Apparently the application does not pass an accurate count to SORT. And, from what I can see, it does multiple internal sorts. I did state a JCL error, but the error was not having an SORTWKnn statements in the JCL at all. But that is not the prime reason for my inquiry. I am just curious if this facility is not in sort for a technical reason, a business reason, or a "we didn't think of that" reason. I do know how to fix it - we added a lot of large SORTWKnn DD statements. -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * (817)-961-6183 cell john.mck...@healthmarkets.com * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: "Sort Capacity Exceeded" thought / question
John, What is your current parameter for dynamic SortWKxx set at? Maybe you just need to increase that number? Or if you have one-off types, provide them with the SORT Over ride that could let them allow for more dynamically allocated sortwk. Lizette -Original Message- >From: "McKown, John" >Sent: Dec 21, 2009 1:29 PM >To: IBM-MAIN@bama.ua.edu >Subject: "Sort Capacity Exceeded" thought / question > >Due to a mistake in JCL, one of our batch jobs got a "Sort Capacity Exceeded" >message in DF/SORT on z/OS 1.10. So, I was just wondering about something. >When this happens, why can't SORT just allocate another SORTWKnn DD and >continue? I know that there is an upper limit on this, but then I got to >wondering why SORT cannot simply reallocate an existing SORTWKnn? I guess it >would need to copy the current contents to some other dynamically allocated >DD, then reallocate and recopy the contents back in. > >Granted, the overhead on this would be large, but I would prefer it to >abending a 4 hour sort. Especially if it were updating a non-recoverable >resource, such as a VSAM file. Perhaps a required non-standard option in >DFSPARM, as opposed to being able to specify it in the ICEMAC parm or dynamic >PARMLIB parm? > >John McKown >Systems Engineer IV -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
"Sort Capacity Exceeded" thought / question
Due to a mistake in JCL, one of our batch jobs got a "Sort Capacity Exceeded" message in DF/SORT on z/OS 1.10. So, I was just wondering about something. When this happens, why can't SORT just allocate another SORTWKnn DD and continue? I know that there is an upper limit on this, but then I got to wondering why SORT cannot simply reallocate an existing SORTWKnn? I guess it would need to copy the current contents to some other dynamically allocated DD, then reallocate and recopy the contents back in. Granted, the overhead on this would be large, but I would prefer it to abending a 4 hour sort. Especially if it were updating a non-recoverable resource, such as a VSAM file. Perhaps a required non-standard option in DFSPARM, as opposed to being able to specify it in the ICEMAC parm or dynamic PARMLIB parm? John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * (817)-961-6183 cell john.mck...@healthmarkets.com * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html