I have one sequential file with records like bank id and I want to search randomly with the records in VSAM file. So I declared in the file section access mode is random so how can I search the particular record in the VSAM file?
Joined: 14 Mar 2007 Posts: 8631 Location: Back in jolly old England
Even though access is random, it is always good practice to sort the control file by the VSAM key before getting the records as you may eliminate a number of I/O operations by reusing the index CI's in memory rather than skipping around the KSDS totaslly randonly, and at some stage in the future reloading the same CI into memory.
In one case many years ago, this took over 30 minutes off of the elapsed time of one job.
Also may be an idea to increase the number of index buffers allocated to your KSDS file, say 10.