Martin,
The default is Half the LRECL for VLR processing and you are remembering
it correctly. :) However I suggest that you run the STATS operator to find
the avg/min/max lrecl's
//STEP0100 EXEC PGM=ICETOOL
//DFSMSG DD SYSOUT=*
//IN DD DISP=SHR,DSN=Your VB file
//TOOLMSG DD SYSOUT=*
//TOOLIN DD *
STATS FROM(IN) ON(VLEN)
//*
and you will get a detailed report in TOOLMSG similar to this
ICE630I 0 MODE IN EFFECT: STOP
STATS FROM(IN) ON(VLEN)
ICE627I 0 DFSORT CALL 0001 FOR COPY FROM IN TO E35 EXIT COMPLETED
ICE628I 0 RECORD COUNT: 000000000005776
ICE607I 0 STATISTICS FOR (VLEN) :
ICE608I 0 MINIMUM: +000000000000032, MAXIMUM: +000000000000821
ICE609I 0 AVERAGE: +000000000000176, TOTAL : +000000001017663
ICE602I 0 OPERATION RETURN CODE: 00
Thanks,
Kolusu
DFSORT Development
IBM Corporation
IBM Mainframe Discussion List <[email protected]> wrote on
09/10/2015 08:41:09 AM:
> From: Martin Packer <[email protected]>
> To: [email protected]
> Date: 09/10/2015 08:51 AM
> Subject: Re: DFSORT (old) enhancement
> Sent by: IBM Mainframe Discussion List <[email protected]>
>
> Not sure whether it's relevant but AVGRLEN is another thing you can use
to
> help DFSORT do the calculations, I seem to recall. (Someone long ago
once
> said for Variable-Length the default is half the LRECL.)
>
> Cheers, Martin
>
> Martin Packer,
> zChampion, Principal Systems Investigator,
> Worldwide Banking Center of Excellence, IBM
>
> +44-7802-245-584
>
> email: [email protected]
>
> Twitter / Facebook IDs: MartinPacker
> Blog:
> https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker
>
>
>
> From: Sri h Kolusu <[email protected]>
> To: [email protected]
> Date: 10/09/2015 16:03
> Subject: Re: DFSORT (old) enhancement
> Sent by: IBM Mainframe Discussion List <[email protected]>
>
>
>
> > Q: How can I use the above enhancement or read more about it?
>
> RS,
>
> As lizette kindly pointed out you need to use DFSORT's Dynamic
Allocation.
>
>
>
> DFSORT's dynamic allocation of work data sets has been enhanced to
improve
>
> reliability in situations where the disk work space requirements are
> larger than expected. A new DYNAPCT installation and run-time option
> allows you to specify additional work data sets to be allocated with
zero
> space. DFSORT only extends these data sets when necessary to complete a
> sort application. New message ICE278I is issued if these additional work
> data sets are used.
>
> DFSORT's new shipped installation default of DYNAPCT=10 increases the
> number of dynamically allocated work data sets by 10%. These additional
> work data sets are allocated with zero space and only extended if
required
>
> to complete a sort application. The availability of these additional
work
> data sets can improve reliability in situations where the disk work
space
> requirements are larger than expected. The DYNAPCT=n percentage can be
> changed at installation or run-time, if appropriate. If you want DFSORT
to
>
> behave as it did in prior releases, you can set DYNAPCT=OLD.
>
> You can read about it here
>
> http://tinyurl.com/pd4q3td
>
>
> >>If any kind of SORT E15/E35 exits are being used where data is being
> passed to SORT(internal COBOL sort, DB2 utilities) and no FILESZ or a
> record count is being passed, OR reading from a unix path name, then
SORT
> will fail miserably dynamically allocating sortwork, or will at least
use
> the default dynamic allocation specified in your ICEOPTS, which may or
may
>
> not be sufficient.
>
> Dave Jousma,
>
> A slight correction in your statement, DB2 Utilities invoke DFSORT
passing
>
> us the filesize. DFSORT automatically calculates the file size and
> determines the right amount of storage required for the job complete.
> However when customers are inserting records via an E15 exit or Invoking
> DFSORT via a program, DFSORT will have no way of knowing an accurate
> record count for the file size without it being specified. You can
always
> get around this passing an estimate of the number of records to be
sorted
>
> (x) or an estimate of the number of records in the input data sets (y)
> using the parm OPTION FILSZ=Ennnnn. This value is not used for the
record
> check. It is used for the file size calculations, but only if DFSORT
could
>
> not reasonably estimate the input file size itself.
>
> Thanks,
> Kolusu
> DFSORT Development
> IBM Corporation
>
> IBM Mainframe Discussion List <[email protected]> wrote on
> 09/10/2015 07:21:13 AM:
>
> > From: "R.S." <[email protected]>
> > To: [email protected]
> > Date: 09/10/2015 07:21 AM
> > Subject: DFSORT (old) enhancement
> > Sent by: IBM Mainframe Discussion List <[email protected]>
> >
> > I'm just reading DFSORT presentation and found the following:
> >
> > Additional work data sets
> > –DFSORT V1R12 provided capability for dynamic allocation of additional
> > work data sets that are only used if needed
> > –Primary space of zero
> > –Secondary space only allocated if needed
> >
> > Q: How can I use the above enhancement or read more about it?
> >
> >
> > --
> > Radoslaw Skorupka
> > Lodz, Poland
> >
> >
> >
> >
> >
> >
> > --
> > Treść tej wiadomości może zawierać informacje prawnie chronione
> > Banku przeznaczone wyłącznie do użytku służbowego adresata. Odbiorcą
> > może być jedynie jej adresat z wyłączeniem dostępu osób trzecich.
> > Jeżeli nie jesteś adresatem niniejszej wiadomości lub pracownikiem
> > upoważnionym do jej przekazania adresatowi, informujemy, że jej
> > rozpowszechnianie, kopiowanie, rozprowadzanie lub inne działanie o
> > podobnym charakterze jest prawnie zabronione i może być karalne.
> > Jeżeli otrzymałeś tę wiadomość omyłkowo, prosimy niezwłocznie
> > zawiadomić nadawcę wysyłając odpowiedź oraz trwale usunąć tę
> > wiadomość włączając w to wszelkie jej kopie wydrukowane lub zapisanena
> dysku.
> >
> > This e-mail may contain legally privileged information of the Bank
> > and is intended solely for business use of the addressee. This e-
> > mail may only be received by the addressee and may not be disclosed
> > to any third parties. If you are not the intended addressee of this
> > e-mail or the employee authorized to forward it to the addressee, be
> > advised that any dissemination, copying, distribution or any other
> > similar activity is legally prohibited and may be punishable. If you
> > received this e-mail by mistake please advise the sender immediately
> > by using the reply facility in your e-mail software and delete
> > permanently this e-mail including any copies of it either printed or
> > saved to hard drive.
> >
> > mBank S.A. z siedzibą w Warszawie, ul. Senatorska 18, 00-950 Warszawa,
> > www.mBank.pl, e-mail: [email protected]
> > Sąd Rejonowy dla m. st. Warszawy XII Wydział Gospodarczy Krajowego
> > Rejestru Sądowego, nr rejestru przedsiębiorców KRS 0000025237, NIP:
> > 526-021-50-88. Według stanu na dzień 01.01.2015 r. kapitał zakładowy
> > mBanku S.A. (w całości wpłacony) wynosi 168.840.228 złotych.
> >
> >
> > ----------------------------------------------------------------------
> > For IBM-MAIN subscribe / signoff / archive access instructions,
> > send email to [email protected] with the message: INFO IBM-MAIN
>
>
>
> ----------------------------------------------------------------------
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to [email protected] with the message: INFO IBM-MAIN
>
>
>
>
> ----------------------------------------------------------------------
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
