query to know thow to cal. average time from sequential file

jaspal · New User Joined: 22 May 2007 Posts: 68 Location: mumbai

Hi
Is there any utility or a way to take a average of time of n number of Records from a sequential file input time will be given in HHMMSS
and avg time should be also in HHMMSS

dick scherrer · Posted: Thu May 24, 2007 8:57 pm

Hello and welcome to the forums,

The amount of time will depend on many factors - how many jobs are running in the system, how busy the i/o and cpu, how long the records are and how they are blocked, any access to vsam or database info in the run unit.

If you want to run a very simple benchmark, create your job that will read some number of records (say 5 million) and run it several times at different times of the day/night. After the "open" and before the "close" get the date and times and write them into a file that you MOD onto each run. You could also capture the date/time before the open and after the close to see how much time that takes - it is your statistics file, so you can include whatever you want. After you've run a number of tests, you can analyze the file you've created with your elapsed times.

We're here when there are questions.

agkshirsagar · Posted: Thu May 24, 2007 9:06 pm

Dick,
I think you overestimated the question.

As per my understanding OP wants to add time records(Records with HHMMSS format) and divide it by count of (time records)..
I was confused at first but when I read second line 3 times, I stopped thinking on it..
Correct me if I am wrong..

dick scherrer · Posted: Thu May 24, 2007 10:05 pm

Hi Abhijit,

I surely wouldn't say that you are wrong. . . I believe that we still trying to understand the request. . . My understanding is definitely not complete.

I'm confused as to how dividing some "time value" by the number/count of time records yields a meaningful result.

Maybe jaspal will provide some clarification. Some sort of example(s) would be most helpful.

William Thompson · Posted: Thu May 24, 2007 10:18 pm

Agreeing with Abhijit, I'm reading it a the average elapsed times from various records.....

jaspal · New User Joined: 22 May 2007 Posts: 68 Location: mumbai

HI ALL

Agkshirsagar got it
i'll explain by an example

lets have a sequential file with 500 records

SUB-ID ACQ-PROC PROCESS-TIME
1) 111110 10000001 10:10:40
2) 111111 10000001 10:11:36

I M CONSIDERING TWO RECORDS

AS I HAVE DECLARED THE ARRAY AND WILL MOVE SUB-ID,ACQ-PROC ,PROCESS-TIME AND OTHER REQUIRED FIELDS
NOW I HAVE TO TAKE AN AVERAGE AND MOVE IT TO WORKING STORAGE VARIABLES

AVG SHOULD BE 10:11:08

REGARDS,
JASPAL

agkshirsagar · Posted: Fri May 25, 2007 12:07 pm

Below code will work for averaging 2 times, I have tried to give you the
logic, change it as per your requirement. I really don't know if there are any intrinsic functions for 'time' in COBOL.

jaspal · New User Joined: 22 May 2007 Posts: 68 Location: mumbai

thanks Agkshirsagar
i'll try if it serves my problem