DJ, If I understand your question correctly you want IO converted to seconds and then divide the IO by the seconds?
for ex : 14.59 = 14*60+59 = 899 seconds and then you want 14.59/899 = 0.0162291434927697 So how many decimals do you want? How do you want the result to be? 0 0.0 0.01 0.016 0.0162 ... or do you need some kind of rounding? If you let me know what you are looking for then I can show you how to do it. Thanks, Kolusu DFSORT Development IBM Corporation From: Dave Jones <[email protected]> To: [email protected] Date: 03/02/2015 08:47 AM Subject: Re: DFSORT question.... Sent by: IBM Mainframe Discussion List <[email protected]> Thanks, Rex. Here's the question: --------------------------------------------------------------------------------------------------------------- I have tried samples from the DFSORT manual,, and can’t seem to find a method that works.. I am losing my mind .. I have this simple sort JCL,, which works fine,,, I have not aligned the header yet,, but will do that later as I am adding fields … Ihave attached the output from the run so you can see the results .. All I want do, is this,, (add this column(s) to the report..) FROM THE outrec multiply the time ,, in this case 14.59 like this .. (14*60) +59 to get total seconds Then,, divide the Total I/O rate by the preciously calculated seconds, to get I/O rate.. Everything I have tried doesn’t seem to work .. Any thoughts? *//* //SYSIN DD * SORT FIELDS=(051,04,CH,A,892,12,CH,D) INCLUDE COND=(43,4,CH,EQ,C'SUMC') OPTION NOLIST,MSGPRT=CRITICAL OUTFIL FNAMES=RPTOUT, HEADER1=(001:'** SAMPLE REPORT SORTED BY SYSID & TOTAL IO COUNT **', /,001:05' '), HEADER2=(001:' TOTAL IO', 018:'DATE', 029:'TIME', 039:'SERIAL #', 051:'CUID', 057:'VEND', 063:'READ BYTES', 077:'WRITE BYTES', /,001:90'-'), OUTREC=(0051,04,02X'40', 0077,05,02X'40', 0892,12,02X'40', 0059,10,02X'40', 0069,08,02X'40', 0712,12,02X'40', 0121,04,02X'40', 0703,04,02X'40', 0760,12,02X'40', 0808,12,40X'40') /* *//* Output 1** SAMPLE REPORT SORTED BY SYSID & TOTAL IO COUNT ** 1 *//*TOTAL IO DATE TIME SERIAL # CUID VEND READ BYTES WRITE BYTES ------------------------------------------------------------------------------------------ THRA 14.59 000002893000 09/20/2014 22.15.00 0000000ZK231 6400 IBM 000154100000 000020800000 THRA 14.59 000002785000 09/20/2014 22.15.00 0000000ZK231 6280 IBM 000146700000 000021000000 THRA 14.59 000002770000 09/20/2014 22.15.00 0000000ZK231 6300 IBM 000150600000 000016200000 THRA 14.59 000002696000 09/20/2014 22.15.00 0000000ZK231 6180 IBM 000143100000 000018100000 THRA 14.59 000002560000 09/20/2014 22.15.00 0000000ZK231 6380 IBM 000133400000 000020900000 THRA 14.59 000002463000 09/20/2014 22.15.00 0000000ZK231 6080 IBM 000144600000 000003800000 THRA 14.59 000002022000 09/20/2014 22.15.00 0000000ZK231 6200 IBM 000105500000 000014700000 THRA 14.59 000002021000 09/20/2014 22.15.00 0000000ZK231 6480 IBM 000087800000 000027200000 THRA 14.59 000001926000 09/20/2014 22.15.00 0000000ZK231 6000 IBM 000095100000 000013600000 THRA 14.59 000001885000 09/20/2014 22.15.00 0000000ZK231 6100 IBM 000095100000 000018700000 THRA 14.59 000001411000 09/20/2014 22.15.00 0000000VC941 9780 IBM 000069600000 000016700000 THRA 14.59 000001278000 09/20/2014 22.15.00 0000000VC941 9800 IBM 000062300000 000015900000 THRA 14.59 000001126000 09/20/2014 22.15.00 0000000ZK811 7580 IBM 000035200000 000024100000 THRA 14.59 000001074000 09/20/2014 22.15.00 0000000VC941 9880 IBM 000052100000 000013100000 THRA 14.59 000000590515 09/20/2014 22.15.00 0000000ZK241 D000 IBM 000015400000 000016400000 THRA 14.59 000000556085 09/20/2014 22.15.00 0000000ZK811 7080 IBM 000004800000 000026000000 THRA 14.59 000000555184 09/20/2014 22.15.00 0000000ZK241 D180 IBM 000003000000 000025300000 THRA 14.59 000000553421 09/20/2014 22.15.00 0000000ZK241 D400 IBM 000016600000 000021900000 --------------------------------------------------------------------------------------------------------------- Granted, it's not the clearest question I've ever been asked....:-) Thanks. DJ ---------------------------------------------------------------------- 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
