look up and write to same hashfile in same job
Posted: Sun Jan 31, 2010 12:49 am
I am following the below listed process, Please advice if it is not the best way.
1) read the hashfile with "Pre-Load file to memory=Enabled,Lock for updates"
2) writing to the hashfile with no cache.
In the above what kind of lock is applied to the file, is it lock on the entire file or a record level lock, is it okay to preload the file or "Disabled,Lock for updates" has to be used. As i am not aware of how the locking on hashfile works can anyone give me the reference as to which document explains this mechanism.
1) read the hashfile with "Pre-Load file to memory=Enabled,Lock for updates"
2) writing to the hashfile with no cache.
In the above what kind of lock is applied to the file, is it lock on the entire file or a record level lock, is it okay to preload the file or "Disabled,Lock for updates" has to be used. As i am not aware of how the locking on hashfile works can anyone give me the reference as to which document explains this mechanism.