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
 

 

Doubts regarding Merging

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

New User


Joined: 24 Jun 2006
Posts: 50

PostPosted: Wed Apr 27, 2011 4:41 pm    Post subject: Doubts regarding Merging
Reply with quote

Hi,

Will there be any perfomance issue if I merge 10 files having length 10000 bytes and 10 files having length as 1000 bytes.

The files with different length have the same number of records and the actual data length is less than 1000 bytes in both type of files.
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Wed Apr 27, 2011 4:45 pm    Post subject: Reply to: Doubts regarding Merging
Reply with quote

Personally, I seriously doubt that any difference will be all that noticible.
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 962
Location: Richmond, Virginia

PostPosted: Wed Apr 27, 2011 5:04 pm    Post subject:
Reply with quote

I would suggest testing, but I'm tired of suggesting that, so don't test it.
Back to top
View user's profile Send private message
Rahul_kumar
Warnings : 2

New User


Joined: 24 Jun 2006
Posts: 50

PostPosted: Wed Apr 27, 2011 5:18 pm    Post subject:
Reply with quote

I have tested and the performance is good in case of the less record length files.Want to know the reason?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8057
Location: East Dubuque, Illinois, USA

PostPosted: Wed Apr 27, 2011 5:23 pm    Post subject:
Reply with quote

Because block size matters -- LRECL does not. LRECL is merely a way of dividing up the physical block stored on the device. If the block isze is 8000, you can use LRECL 80 and get 100 records from the block, or use LRECL 100 and get 80 records from the block. Which one to use? Unless you want to see some funny-looking data, use the LRECL that the file was built with. However, do not expect LRECL to have a performance impact -- it is a logical construct, not a physical construct.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Wed Apr 27, 2011 5:36 pm    Post subject: Reply to: Doubts regarding Merging
Reply with quote

why not do a bit of arithmetic Yourself .....

let' forget for a while about space/optimization and real device parameters

assume 1000000 records

case 1 LRECL 1000 BLKSIZE 100000 ==> 100 record x block ==> 10000 block to be read
1000000 * 1000 bytes to transfered

case 2 LRECL 10000 BLKSIZE 100000 ==> 10 records x blok ==> 100000 blocks to be read
1000000 * 10000 bytes to be transfered

the data to be transfered and data transfer time is going to be 10 times

do a bit of arithmetics and meditate on Your own
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 Merging of two files siva102 DFSORT/ICETOOL 3 Fri Feb 19, 2016 12:36 pm
No new posts Merging records skgupta81 DFSORT/ICETOOL 11 Thu Sep 10, 2015 3:19 am
No new posts Merging file data using ICETOOL kishpra JCL & VSAM 3 Tue Aug 04, 2015 2:15 pm
No new posts Merging two records using JCL rahul sijoriya DFSORT/ICETOOL 4 Wed Dec 18, 2013 7:26 am
No new posts Merging multiple records onto single ... vinu78 JCL & VSAM 27 Tue Jul 09, 2013 1:35 am


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