IBM Mainframe Forum

I'm looking for a sample REXX or CLIST that will take sysout or a task log that contains tape mounts and calculate the difference between the mount request time and the demount time for each tape volume data set. Does anyone have something like that? For example, the sysout would look something like this in a flat file data set:

18.01.47 STC01702 IEC501A M F196,A98407,SL,COMP,OAM,OAM,OAM.PRIMARY.DATA
18.01.47 STC01702 IEF234E K F19C,B49074,PVT,OAM,OAM
18.01.48 STC01702 IEC501A M F195,A50874,SL,COMP,OAM,OAM,OAM.PRIMARY.DATA
18.01.48 STC01702 IEF234E K F58C,B05438,PVT,OAM,OAM
18.01.49 STC01702 IEC501A M F58F,A91835,SL,COMP,OAM,OAM,OAM.PRIMARY.DATA
18.01.50 STC01702 IEC501A M F19E,A97043,SL,COMP,OAM,OAM,OAM.PRIMARY.DATA
18.01.51 STC01702 IEC501A M F19B,B50664,SL,COMP,OAM,OAM,OAM.PRIMARY.DATA
18.01.52 STC01702 IEC501A M F199,A85958,SL,COMP,OAM,OAM,OAM.PRIMARY.DATA
18.01.52 STC01702 IEF234E K F191,A93651,PVT,OAM,OAM
18.01.53 STC01702 IEC501A M F19C,B35889,SL,COMP,OAM,OAM,OAM.PRIMARY.DATA
18.01.53 STC01702 IEF234E K F196,A98407,PVT,OAM,OAM

And I'm looking for output for each tape volume to tabulate the varying differences for each mount in a columnized output as such:

1-5 secs 6-10 secs 11-20 secs 20+ secs
xx xx xx xx

(or something similar). Is this possible and does someone have something that would do this?

Just as an additional note, I'm looking to import to an Excel spreadsheet to show trending of tape mounts and the various retention times.

Not actually an answer to your question, but have you looked at the GFTAVMA program which may give you what you want, rather than reinventing the wheel?

Not sure what the GFTAVMA program is or where to find it?

GOOGLE it?


may get to here: http://publibz.boulder.ibm.com/epubs/pdf/dgt3v100.pdf

or here: https://www.ibm.com/support/knowledgece ... 00/toc.htm

SYS1.SAMPLIB