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
Hash Files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.