Would be lovely if STATS operator reported the LRECL. Or would that be redundant? And perhaps in a POINTED way so that AVERAGE was contrasted to 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 17:08 Subject: Re: DFSORT (old) enhancement Sent by: IBM Mainframe Discussion List <[email protected]> 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 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
