At the risk of duplicating what others have said – as this thread has run long…
… I would prefer specifying FILSZ over relying on static sort work allocations – for the cases where DFSORT needs help in working out how much data needs sorting. Also, you can MEASURE sort work tracks allocated and used using SMF 16. So maybe the best thing to do is run a test and conclude something from it. (I’m not sure if it’d be scientific to extrapolate from a small sort to a bigger one, mind.) And I use a very hand wavy 2x ratio – as it’s nice and simple. Of course that’s extremely pessimistic if the sort completes in memory. 😊 Funnily enough a vaguely similar question came up in the context of Db2 Utility executions recently. I should probably experiment with a real customer’s data – as there’s lots of instrumentation to play with here. Including the new Db2 13 Utility History stuff. (But even SYSCOPY – having had my 😊 job name column in for yonks – is pretty useful in this regard.) Cheers, Martin From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> on behalf of kekronbekron <000002dee3fcae33-dmarc-requ...@listserv.ua.edu> Date: Tuesday, 4 July 2023 at 07:11 To: IBM-MAIN@LISTSERV.UA.EDU <IBM-MAIN@LISTSERV.UA.EDU> Subject: [EXTERNAL] Re: SORTWK space usage Yes, IEFUSI is in use. MEMLIT, about 2-6G. - KB ------- Original Message ------- On Tuesday, July 4th, 2023 at 11:32 AM, Sri h Kolusu <skol...@us.ibm.com> wrote: > > > From the few tests I've seen, it seems that DFSORT prefers hiperspaces > > > over memory objects or real memory. > > MEMLIMIT and REGION are decent enough, size-wise, but DFSORT doesn't seem to > touch MO at all; goes directly to Hiperspace. > > KB, > > Do you have any IEFUSI exit in place? Also, what is the MEMLIMIT value in > SMFPRMxx member? > > > Thanks, > Kolusu > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN Unless otherwise stated above: IBM United Kingdom Limited Registered in England and Wales with number 741598 Registered office: PO Box 41, North Harbour, Portsmouth, Hants. PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
