Can i use same hash file 3 jobs running parallel

parsi_cnu · Post by **parsi_cnu** » Mon Apr 04, 2005 1:18 pm

Hi,
My lookup is hashfile in all the 3 jobs. If i want to run parallel can i do if how should i do.

thanks
sri

kcbland · Post by **kcbland** » Mon Apr 04, 2005 2:19 pm

Sure, just don't be writing to the hash file at the same time other jobs are accessing it expecting to the find that data. If it's a static hash file, you can have as many jobs share it as you want.

roy · Post by **roy** » Wed Apr 06, 2005 6:37 am

Hi,
How about using the properties tab of the job and check the: enable hashed file chache sharing.
this should load the file to memory once instead of multiple times/
IHTH,

ray.wurlod · Post by **ray.wurlod** » Wed Apr 06, 2005 4:39 pm

Shared hashed files require a reconfiguration of DataStage. For details see dsdskche.pdf in the DataStage manuals.