Hash Files

srinagesh · Post by **srinagesh** » Tue Aug 02, 2005 9:25 am

Hi

It may look like a stupid question, but my Manager has asked me to see if the Hash Files created in the load process can be cleared at the end of the load cycle everyday and recreated the next day.

Is it ok to delete Hash files at the end of each load cycle and create new ones the next day, during next load cycle.

Any suggestions ?

-Nagesh

kduke · Post by **kduke** » Tue Aug 02, 2005 9:36 am

Sure. It is built into the job. The job can clear hash files before loading them or DELETE and CREATE. This is very effective. You can even size the hash file properly which will speed up loading the hash file.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 02, 2005 5:01 pm

Clearing a hashed file at the end of the run does not gain anything because hashed files, by default, hang onto any disk space that has been allocated to them. You would need either to delete the hashed file at the end of the run, or to create a paragraph to clear then resize the hashed file. Either way there is the overhead on the next run to re-build, so why not just clear/re-create the file as part of that?