Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 6970
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: 1535
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: 8211
Location: Dubuque, Iowa, 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 IBEGENER RETURN CODE 12 anilkumar922 All Other Mainframe Topics 5 Wed Dec 13, 2017 11:41 am
No new posts Finding the plan when code compiled u... Ahemad DB2 1 Fri Dec 01, 2017 6:38 pm
No new posts Strange Code amitc23 COBOL Programming 6 Tue Nov 28, 2017 11:25 am
No new posts Comparision with current time arunsoods DFSORT/ICETOOL 5 Thu Nov 09, 2017 10:37 am
This topic is locked: you cannot edit posts or make replies. Comparing current time with the time ... arunsoods SYNCSORT 1 Mon Oct 30, 2017 4:07 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us