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
 

 

Easytrieve Tuning

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
PDB

New User


Joined: 18 Sep 2007
Posts: 7
Location: India

PostPosted: Mon Jun 23, 2008 11:31 am    Post subject: Easytrieve Tuning
Reply with quote

Hi,
I need to compare two sequential files and both have account number as key field. There are 4 data fields which I need to compare. These 4 fields reside in two different types of account types. Therefore, I can have one or two entries of an account number. Also, the amount of data I am comparing is huge. I have almost 9 - 10 million records in both the files.

Here's my approach:
In JOB1 I combine the two record types of file A to make single record for every account.
In JOB2 I combine the two record types of file B to make single record for every account.
In JOB3 I compare the two files and write my output.

Now this complete process takes almost 3 hours. I tried giving more space to work files but still the process takes this much time.

Please suggest how the performance can be improved.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jun 23, 2008 11:43 am    Post subject:
Reply with quote

Hello,

How long does it take to simply read both files using easytrieve?
Back to top
View user's profile Send private message
chandrarkar

New User


Joined: 27 May 2008
Posts: 24
Location: india

PostPosted: Mon Jun 23, 2008 12:15 pm    Post subject:
Reply with quote

I think if u provide the individual time taken by each individual job,
we can see which can be fine tuned.
Back to top
View user's profile Send private message
PDB

New User


Joined: 18 Sep 2007
Posts: 7
Location: India

PostPosted: Mon Jun 23, 2008 2:40 pm    Post subject:
Reply with quote

It took 66 minutes to just read 1 file. I gave this parameter:

//EZTVFM DD DISP=(NEW,DELETE),
// SPACE=(CYL,(1000,1000),RLSE),
// UNIT=SYSDA
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jun 23, 2008 11:13 pm    Post subject:
Reply with quote

Hello,

If it took 66 minutes to read only 1 file, the 3-hour total run-time does not seem out of line. . .
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 -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts RACF Easytrieve Plus macro Susan Jackson CA Products 0 Fri Jun 03, 2016 8:25 pm
No new posts Query regarding Easytrieve program shanudarling All Other Mainframe Topics 2 Wed Jan 06, 2016 5:33 pm
No new posts Adjust Heading Position in Easytrieve thesumitk CA Products 4 Mon Dec 21, 2015 3:26 pm


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