Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
gayathiridevi

New User


Joined: 15 Jul 2010
Posts: 8
Location: chennai

PostPosted: Wed Jul 13, 2011 5:33 pm    Post subject: Please give a code to take a End-Time of the job from $AVERS
Reply with quote

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
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Wed Jul 13, 2011 5:35 pm    Post subject:
Reply with quote

Quote:
using the Rexx tool.


comment out line 16 of the second rexx script.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1491
Location: Chennai

PostPosted: Wed Jul 13, 2011 5:38 pm    Post subject:
Reply with quote

Hello,
Quote:

I have tried but it is running for the long time.

Please show us what you have tried out, someone might be able to fine tune it or suggest an alternative to your method.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8057
Location: East Dubuque, Illinois, USA

PostPosted: Wed Jul 13, 2011 11:15 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts DSNACCOX (can it be run on 1 db/ts, t... SRICOBSAS DB2 3 Sat May 06, 2017 12:59 am
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us