How to do this, Sort, DB2 or COBOL?



Post anything related to mainframes (IBM & UNISYS) if not fit in any of the above categories

Re: How to do this, Sort, DB2 or COBOL?

Postby dick scherrer » Sat Apr 26, 2008 5:20 am

Hello,

i cannot run the job every 15 min. I need to run the job only once a day.
Yes, once a day will do what you want.

but My question is how can i group by the 15 minute interval from this file
By looking at the time (hh & mm) in each record, you can determine which of the 94 metrics should be acumulated. Just define an array that has 97 "buckets" (the extra is in case there would be an invalid time in some record) and add to the appropriate bucket.

Also let me know if processing 9 million records daily in the above logic will not hamper any performance.
I suspect it will take as long or longer to unload the data than read it and summarize it. Still, the process should take well less than 2 hours (assuming the data is on dasd and the process does not have to wait over and over for tape mounts).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Re: How to do this, Sort, DB2 or COBOL?

 

Re: How to do this, Sort, DB2 or COBOL?

Postby dick scherrer » Sat Apr 26, 2008 10:59 pm

Hello,

To add to my previous reply. . .

How will this data be used after it is collected?

If the code to use the data is not yet developed, the data collection would be very simple if the array for the metric(s) was a 2-dimensional array - the first dimension for the hour and the second dimension for the quarter hour.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Previous

Return to All other Mainframe Topics

 


  • Related topics
    Replies
    Views
    Last post