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
 

 

JOINKEYS performance improvement

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Indrajit_57
Warnings : 1

New User


Joined: 27 Jun 2006
Posts: 60

PostPosted: Sat Nov 24, 2012 3:32 am    Post subject: JOINKEYS performance improvement
Reply with quote

Hi,

I need to match records from 2 files using JOINKEYS. File 1 has 1000 records and File 2 has say 1000000 records (in short number of records in File 1 is much lesser than the number of records in File 2 and length of File 1 is also lesser than length of File 2). If a match is found the output should be the entire record from File 2.

Currently code is like SORTJNF1 points to File 2 and SORTJNF2 points to File 1.

My question is, will there be any perfomance improvements if I use SORTJNF1 as File 1 and SORTJNF2 as File 2. I thought of testing this in test regions but I don't have enough volume of data available to see if there are any performance improvements in terms of Elapsed time and CPU utilization.

Thanks,
Indrajit
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sat Nov 24, 2012 3:59 pm    Post subject:
Reply with quote

Then test it in PROD with the allowed permissions. And you should be running multiple iterations to get to your conclusions.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Sat Nov 24, 2012 6:20 pm    Post subject: Reply to: JOINKEYS performance improvement
Reply with quote

If you don't have volume data in Test, create it. SORT, IEBDG, various methods.
Back to top
View user's profile Send private message
Indrajit_57
Warnings : 1

New User


Joined: 27 Jun 2006
Posts: 60

PostPosted: Tue Nov 27, 2012 9:22 am    Post subject:
Reply with quote

I tested this and the elapsed time is much lessed when the JNF1 is having a file with lesser number of records.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Tue Nov 27, 2012 1:28 pm    Post subject: Reply to: JOINKEYS performance improvement
Reply with quote

Thanks for letting us know what works for you.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
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 Joinkeys operation when key1 and key2... Susanta DFSORT/ICETOOL 5 Wed Nov 02, 2016 5:35 pm
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm
No new posts Joinkeys operation betwen VB and FB file Susanta SYNCSORT 4 Sun Sep 25, 2016 9:49 pm


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