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 UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts READ A PACKED "NEGATIVE" FI... jdesouza CA Products 3 Tue May 02, 2017 11:43 pm
No new posts Batch job tuning sgandhla Testing & Performance analysis 5 Fri Mar 24, 2017 9:41 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am


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