IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Easytrieve Tuning


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Mon Jun 23, 2008 11:43 am
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
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
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

Moderator Emeritus


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

PostPosted: Mon Jun 23, 2008 11:13 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Count the number of characters in a f... CA Products 1
No new posts File matching functionality in Easytr... DFSORT/ICETOOL 14
No new posts COBOL Performance Tuning COBOL Programming 6
No new posts Easytrieve EZABX007 with error code 0... CA Products 7
No new posts Workload Manager definitions for Tuni... All Other Mainframe Topics 0
Search our Forums:

Back to Top