Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
VSAM I/O time

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Amit Manas Dubey
Currently Banned

New User


Joined: 15 Dec 2006
Posts: 22
Location: Mumbai

PostPosted: Mon Feb 18, 2008 11:38 pm    Post subject: VSAM I/O time
Reply with quote

Hi All,

I have a VSAM file LRECL = 6500, Key length = 22, No of records in the file = 1064949.

I need to know what impact would it have on I/O (Random read) for 1 single record, if we increase the Record length by 600 bytes ?

Will it have any difference at all, and if yes, approx how much ?

Best regards,
Amit.
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Mon Feb 18, 2008 11:57 pm    Post subject:
Reply with quote

Of course there is some impact. However, it is probably somewhere between unmeasurable and minimal.
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: Tue Feb 19, 2008 12:51 am    Post subject:
Reply with quote

Hello,

Quote:
it is probably somewhere between unmeasurable and minimal
Yup, i'd go with this. . . icon_wink.gif

Given that the index structure has not changed and that the number of index entries has not changed, the time to locate the specific index entry should stay the same as it is now. Reading one 6.5k record versus one 7k record should be "between unmeasurable and minimal".
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2504
Location: Atlanta, Georgia, USA

PostPosted: Tue Feb 19, 2008 1:57 am    Post subject: VSAM I/O time
Reply with quote

An optimal CISIZE, for both Data and Index will also have a significant affect on performance as well as the AMORG parameters utilized and BLSR.

If you're truly issuing RANDOM Reads, then ensure that your program specifies ACCESS IS RANDOM as opposed to ACCESS IS DYNAMIC.

HTH....

Regards,

Bill
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
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Regarding time parameter shanthi gude JCL & VSAM 7 Mon Sep 04, 2017 2:31 pm
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us