Hash file as a global reference
Posted: Tue Apr 05, 2005 8:19 am
Hi there,
I have a requirement where I need to use a hash file as global reference in several jobs out those jobs I have to parallel atleast two or more.
So two or more jobs using the the same hash file as a reference(lookup) as well as I need to insert new records into that hash file in order to keep it current. How good this approach will work and is performence an issue?
Will hash file work based on some file lock protocol for reference vs update with different processes running at the same time?
If this approach is not the right one, what would be the best way to go when I have to use the same dataset as a global reference in several jobs where I also need to update the hashfile.
Thanks in advance.
Paddu
I have a requirement where I need to use a hash file as global reference in several jobs out those jobs I have to parallel atleast two or more.
So two or more jobs using the the same hash file as a reference(lookup) as well as I need to insert new records into that hash file in order to keep it current. How good this approach will work and is performence an issue?
Will hash file work based on some file lock protocol for reference vs update with different processes running at the same time?
If this approach is not the right one, what would be the best way to go when I have to use the same dataset as a global reference in several jobs where I also need to update the hashfile.
Thanks in advance.
Paddu