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: 6966
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: 1474
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: 7990
Location: Bellevue, IA

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 Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts scheduling between OPC and TWS give u... nsbl IBM Tools 1 Sun Mar 12, 2017 5:35 pm
No new posts How to get current date -1 and curren... murali.andaluri DFSORT/ICETOOL 3 Wed Mar 08, 2017 2:09 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm


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