View previous topic :: View next topic |
Author |
Message |
anjan Beginner
Joined: 27 Jul 2006 Posts: 1 Topics: 1
|
Posted: Thu Jul 27, 2006 5:31 am Post subject: How to reduce the loadtime while loading file to VSAM File. |
|
|
Hi,
i have a Flat file which is containing nearly 16 Million Records. My Client requires to store in a Single VSAM File.I did that but againg they are asking to reduce the loading time. That should take 5 hrs where my method of loading is taking 9.5 Hrs.
In this Scenario i have concatinaed all the flat file and alloted a large VOL Of MSBPOOL and Loaded. I have Tried In a Lot of ways to reduce the time Period but still I am not able to find the way. Could anyone tell me how to reduce the loading time to VSAM using any techniques of Performance Tuning of VSAM. I have Used BUFND & BUFNI also on the time of Loading but notable to come out.
Please send me the valluable Suggestion.
Thanks. |
|
Back to top |
|
 |
warp5 Intermediate

Joined: 02 Dec 2002 Posts: 429 Topics: 18 Location: Germany
|
Posted: Fri Jul 28, 2006 4:07 am Post subject: |
|
|
What kind of VSAM file? If it is KSDS is the flat file sorted according to the key? Are you using freespace? |
|
Back to top |
|
 |
|
|