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
 

 

KSDS V/S Internal Array

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

New User


Joined: 11 May 2007
Posts: 20
Location: Canada

PostPosted: Wed Jul 30, 2008 1:26 am    Post subject: KSDS V/S Internal Array
Reply with quote

Hi ,

Could anyone let me know whether accessing a record stored in KSDS file by passing a Key is better or Storing a data in sequential file and loading it into an internal array in the program and then accesing it is better from the performance perspective.
Back to top
View user's profile Send private message

Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Wed Jul 30, 2008 2:30 am    Post subject:
Reply with quote

It depends on several factors: Number of records in the VSAM file, total number of VSAM reads vs. table searches will be done on the average, how often the VSAM file is updated, total amount of memory an internal table will use (usually not a problem these days). You need to provide more detail to get a good answer.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Wed Jul 30, 2008 2:32 am    Post subject:
Reply with quote

Since I cannot edit my posts, I wanted to add that memory searches will outperform I/O almost always, but there are other considerations, too.
Back to top
View user's profile Send private message
Sowmya Ramachandra

New User


Joined: 11 May 2007
Posts: 20
Location: Canada

PostPosted: Wed Jul 30, 2008 3:28 am    Post subject: Reply to: KSDS V/S Internal Array
Reply with quote

The no. of the records in the file is supposed to me low volume say abt 50-100 records.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Wed Jul 30, 2008 3:37 am    Post subject:
Reply with quote

And what about the other factors I mentioned? They all play a part.
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: Wed Jul 30, 2008 6:39 am    Post subject:
Reply with quote

Hello,

How many records are in the "real" file (rather than this reference data?

Can the real file be put in sequence by the value that is used to search the array/vsam data?

As Terry mentioned, the other info requested could help us help 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 Dynamic array request/response contai... Suja.Sai CICS 2 Tue Jan 24, 2017 11:37 am
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Unstring list of values into an array. Roshnii COBOL Programming 8 Mon Jun 27, 2016 6:25 pm
No new posts Getting soc4 on internal table in cobol abdulrafi COBOL Programming 13 Fri May 06, 2016 3:39 pm
No new posts Empty KSDS Files Jeenu Bajaj JCL & VSAM 6 Fri Aug 21, 2015 2:44 pm


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