|
View previous topic :: View next topic
|
| Author |
Message |
Vinodc
New User
Joined: 01 Dec 2005
Posts: 33
Location: Prague
|
|
|
|
Hi,
My shop have a VSAM KSDS Master File containing about a million records. There is a transaction file generated daily containing few hundred records. Date and Time are part of the key of the KSDS, so never issue of duplicates.
Daily we need to merge the transaction file into the master file. My query is what will be the most efficient way in terms of processing time to do this merge. Currently we are doing it through SORT. Can somebody please guide me with the different options, and the most time efficient of them in their views.
Thanks a lot.
Vinod Chawda |
|
| Back to top |
|
 |
hariavinash
New User
Joined: 04 Jan 2006
Posts: 64
|
|
|
|
use IDCAMS. Thats the best for VSAM datasets
Even if you have duplicates, the job will give a non zero RC (8) and continue copying all the non-duplicates.
cheers |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| use IDCAMS. Thats the best for VSAM datasets |
Not necessarily. A DFSORT merge may be more efficient. The only way to know for sure for a particular situation is to try it both ways and check the processing time. |
|
| Back to top |
|
|
|
|
