Please give a code to take a End-Time of the job from $AVERS

gayathiridevi · New User Joined: 15 Jul 2010 Posts: 8 Location: chennai

Hi,

INPUT to the $avers:
-----------------------
Name=Job name
Type=AH
SD=start date
ED=End date

Using the above information it should get the Average end time of the job.
I have tried but it is running for the long time. Please any one help me to get above information using the Rexx tool.

Thanks,
Gayathiri

dbzTHEdinosauer · Posted: Wed Jul 13, 2011 5:35 pm

vasanthz · Posted: Wed Jul 13, 2011 5:38 pm

Hello,

Robert Sample · Posted: Wed Jul 13, 2011 11:15 pm

Are you trying to use the $AVRPULL batch procedure to extract data from the $AVRS Archive History file? If so, be aware that (1) the job may run for a VERY long time since the system may have to mount multiple tapes to extract the desired data, and (2) you will get back only the job listings that match the criteria; it will be up to you to write code to find the end time of each job and calculate their averages.

Furthermore, since the job data $AVRS maintains is stored in VSAM files in proprietary and compressed formats, your best bet is to use the $AVRPULL job -- no matter how long it takes -- to extract the data. You are not likely to be able to find anyone that can provide you with the format of the data.

And, just out of curiosity, what is an "average end time"? If the job ends at 8 AM, 8:01 AM, 10:13 AM, 2:29 PM, and 11:59 PM -- what would be the value of "average end time", and more importantly, why on earth would you think there to be any signifiance to such a value (no matter how calculated)? This is one of those cases where mode or median would be much more useful and informatve.