Hello DFSort experts!
Where can I find the explanation of SORTWK space usage? I seem to recall
reading that only the primary space is used on a SORTWK, so if I have
//SORTWK DD SPACE=(CYL,(5000,2000))...
I will only get the primary space of 5000 cylinders, and the other
14x2000 cylinders is
ubject: [EXTERNAL] Re: SORTWK space usage
This has been a good thread, even if it is a bit long, and it was quite
expedient for me, as I had a client just ask me about how to determine sortwork
sizes needed for a large database file they are processing. The records are
coming from inside a program via
Yes, the records are FB, and I have run several tests today, so I could get a
"close but not exact" count here to see those results.
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listse
>> Yes, IEFUSI is in use.
KB,
Maybe it is limiting the storage based on the jobname and region parm. If you
need me to take a look at the joblog, please send me the complete joblog while
having //SORTDIAG DD DUMMY.
Thanks,
Kolusu
DFSORT Development
IBM Corporation
-
>> Also, I assume there is no way to force a Hipersort or a Dataspace sort? In
>> one of my tests this morning, I saw this:
Don,
If you want to force HIPERSORT, then you need to turn off other paths of code.
You can do that with the following.
MOSIZE=0,DSPSIZE=0,NOMOWRK,HIPRMAX=OPTIMAL
Simil
Ok, thanks, Kolusu. Unless there would be a compelling reason to redirect the
SORT a different way, I will let the program determine the best way to go. So
far, it sounds like each of these memory paths will produce somewhat similar
stats to other paths, and I would not want to ask my client try
;
To IBM-MAIN@listserv.ua.edu
Date 7/5/2023 11:18:26 AM
Subject Re: SORTWK space usage
Also, I assume there is no way to force a Hipersort or a Dataspace sort? In
one of my tests this morning, I saw this:
Don,
If you want to force HIPERSORT, then you need to turn off other paths of code.
>> One question they asked me, about our common SORT proc:
Billy,
Common SORT proc? Does that mean every SORT gets that override? If that is
the intention, why not update the Installation defaults with those overrides?
You can use PARMLIB member and update for both ICEAM1 (JCL Invocations) I
al Message --
From "Sri h Kolusu"
To IBM-MAIN@listserv.ua.edu
Date 7/6/2023 12:05:52 PM
Subject Re: SORTWK space usage
One question they asked me, about our common SORT proc:
Billy,
Common SORT proc? Does that mean every SORT gets that override? If that is
the intention
>> and their intention is to use the common DFSPARM like I showed, but then to
>> concatenate another line there with the FILSZ=E### value. This way, they
>> don't need to specify everything again, and can focus on only the parameter
>> they need.
Billy,
Unfortunately, that would NOT work. Yo
Date 7/6/2023 1:13:39 PM
Subject Re: SORTWK space usage
and their intention is to use the common DFSPARM like I showed, but then to
concatenate another line there with the FILSZ=E### value. This way, they don't
need to specify everything again, and can focus on only the paramete
e questions, but other folks may still jump in, I guess.
>
> Billy Ashton
>
>
> -- Original Message --
> From "Sri h Kolusu"
> To IBM-MAIN@listserv.ua.edu
> Date 7/6/2023 1:13:39 PM
> Subject Re: SORTWK space usage
>
> >>> and their
>> SORT.PARMLIB(SIZEnnnG) Where nnn=001,005,020,100,200,300,400,500,...,999)?
Mike,
Why bother about creating different members based on the size of the file?
Most of the parms that Billy is overriding are good candidates for Installation
defaults. All they need to do is change 1 member and e
Both DFSORT and SYNCSORT make use of primary and secondary space allocations
(up to the z/OS legacy 16 extents per volume) but for only the first volume -
there is not VOLADD processing taken.
Also, if SORTWKxx DDs are hardcoded, then you must also have the DSNTYPE=LARGE
(either explicit or v
**CORRECTION** - sorry, that's 4,369 cylinders or 65,535 tracks
On Mon, 3 Jul 2023 11:13:03 -0500, Scott Barry wrote:
>Both DFSORT and SYNCSORT make use of primary and secondary space allocations
>(up to the z/OS legacy 16 extents per volume) but for only the first volume -
>there is not V
>>I will only get the primary space of 5000 cylinders, and the other 14x2000
>>cylinders is never used. Is that right?
Billy,
No. Incorrect. DFSORT will make use of BOTH primary and secondary space
allocations ( 1 primary + 15 Secondary) for a total of 16 extents. So if you
allocated 1 sortwk
onday, July 3, 2023 12:28 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SORTWK space usage
>>I will only get the primary space of 5000 cylinders, and the other 14x2000
>>cylinders is never used. Is that right?
Billy,
No. Incorrect. DFSORT will make use of BOTH primary and secondar
.ua.edu
Date 7/3/2023 12:44:43 PM
Subject Re: SORTWK space usage
I will add on to Sri's excellent answer with my very STRONG recommendation NOT
to use hard-coded SORTWK's in your JCL. Both of the major SORT vendors (IBM
and Syncsort) do a far, far better job of estimating nec
- Original Message --
From "Farley, Peter" <031df298a9da-dmarc-requ...@listserv.ua.edu>
To IBM-MAIN@listserv.ua.edu
Date 7/3/2023 12:44:43 PM
Subject Re: SORTWK space usage
I will add on to Sri's excellent answer with my very STRONG
recommendation NOT to use hard-coded
regards,
> Billy Ashton
>
>
> -- Original Message --
> From "Farley, Peter" <031df298a9da-dmarc-requ...@listserv.ua.edu>
> To IBM-MAIN@listserv.ua.edu
> Date 7/3/2023 12:44:43 PM
> Subject Re: SORTWK space usage
>
>> I will add on to Sri's e
?
Thank you and best regards,
Billy Ashton
-- Original Message --
From "Doug"
To IBM-MAIN@listserv.ua.edu
Date 7/3/2023 2:45:28 PM
Subject Re: SORTWK space usage
Try adding this instead off sorted dd.
//DFSPARM DD *
OPTION DYNALLOC=(SYSDA,15),DYNSPC=768
/*
You can add oth
e the use of 15 Dynalloc
> SORTWK files, so I would not have to code SORTWK DD statements?
>
> Thank you and best regards,
> Billy Ashton
>
>
> -- Original Message --
> From "Doug"
> To IBM-MAIN@listserv.ua.edu
> Date 7/3/2023 2:45:28 PM
> Subjec
It is on disk, Doug. Thanks for the caveat!
Thank you and best regards,
Billy Ashton
-- Original Message --
From "Doug Shupe"
To IBM-MAIN@listserv.ua.edu
Date 7/3/2023 4:07:05 PM
Subject Re: SORTWK space usage
Billy,
Am only trying to present a possible option. The
July 3, 2023 1:14 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: SORTWK space usage
>
> [EXTERNAL EMAIL]
>
> It is on disk, Doug. Thanks for the caveat!
>
> Thank you and best regards,
> Billy Ashton
>
>
> -- Original Message --
> From "Doug
Development
IBM Corporation
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of
Billy Ashton
Sent: Monday, July 3, 2023 11:14 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: [EXTERNAL] Re: SORTWK space usage
Thanks everyone - these are good recommendations.
However, the guy who
Discussion List On Behalf Of Sri
h Kolusu
Sent: Monday, July 3, 2023 1:55 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: [EXTERNAL] Re: SORTWK space usage
>>450mill * 110 * 1.5 = 7425000 = 69GB so maybe SORTWK01 - SORTWK10
Billy,
Based on your above description, you would need about 1.345 million
shton
Sent: Monday, July 3, 2023 3:48 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SORTWK space usage
Doug, this raises a good point. If I have a COBOL program doing a SORT in the
middle of the program (I am not sure if the big file is doing this, too or
not), is using this DFSPARM the best way to for
From "Farley, Peter" <031df298a9da-dmarc-requ...@listserv.ua.edu>
To IBM-MAIN@listserv.ua.edu
Date 7/3/2023 5:27:52 PM
Subject Re: SORTWK space usage
Billy,
If it is an internal sort then supply the FILSZ=Ennn parameter in
DFSPARM (or $ORTPARM for Syncsor
>> how can I dump off the current SORT system options?
Billy,
Check this.
https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg105660.html
Thanks,
Kolusu
DFSORT Development
IBM Corporation
--
For IBM-MAIN subscribe / sig
docu somewhere that helps interpret the SYSOUT messages).
Thank you and best regards,
Billy Ashton
-- Original Message --
From "Sri h Kolusu"
To IBM-MAIN@listserv.ua.edu
Date 7/3/2023 4:54:39 PM
Subject Re: SORTWK space usage
450mill * 110 * 1.5 = 7425000 = 69GB so mayb
>> you mentioned getting better diagnostics from the SORTDIAG DD DUMMY. Are
>> these diagnostics something I can interpret?
Billy,
Not really. The additional messages would help IBM to diagnose the problem.
Thanks,
Kolusu
DFSORT Development
IBM Corporation
---
take defaults.
Have a good evening, and a happy Independence Day to the US folks!
Thank you and best regards,
Billy Ashton
-- Original Message --
From "Sri h Kolusu"
To IBM-MAIN@listserv.ua.edu
Date 7/3/2023 6:40:56 PM
Subject Re: SORTWK space usage
how can I dump off t
> DFSORT has the capability of using memory (real and auxiliary storage) and if
> it runs out of it, it will then use disk workspace.
Hi Sri,
I understand you can't share the inner workings any more than what's documented
in docs.
>From the few tests I've seen, it seems that DFSORT prefers hipe
>> 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 th
Yes, IEFUSI is in use.
MEMLIT, about 2-6G.
- KB
--- Original Message ---
On Tuesday, July 4th, 2023 at 11:32 AM, Sri h Kolusu wrote:
> > > From the few tests I've seen, it seems that DFSORT prefers hiperspaces
> > > over memory objects or real memory.
>
> MEMLIMIT and REGION are dec
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 wrote:
> > > From the few tests I've seen, it seems that DFSORT prefers hiperspaces
> > >
@LISTSERV.UA.EDU
Subject: SORTWK space usage
[CAUTION: This Email is from outside the Organization. Unless you trust the
sender, Don’t click links or open attachments as it may be a Phishing email,
which can steal your Information and compromise your Computer.]
Hello DFSort experts!
Where can I find the
program to figure
things out.
HTH,
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of
Allan Staller
Sent: Wednesday, July 5, 2023 6:55 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SORTWK space usage
[CAUTION: This Email is from outside the Organization. Unless you
This has been a good thread, even if it is a bit long, and it was quite
expedient for me, as I had a client just ask me about how to determine sortwork
sizes needed for a large database file they are processing. The records are
coming from inside a program via E15/35, so I can't use the standard
first volume. Nothing will get
allocated on subsequent volumes.
Rex
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of
Billy Ashton
Sent: Monday, July 3, 2023 1:14 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: [EXTERNAL] Re: SORTWK space usage
Thanks everyone - these are
message
(including any attachments) in its entirety. Thank you
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Pommier, Rex
Sent: Monday, July 3, 2023 2:08 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: [EXTERNAL] Re: SORTWK space usage
Billy
41 matches
Mail list logo
