How to cleanup unwanted hash files

venkat n · Post by **venkat n** » Thu Jul 21, 2005 5:01 am

How to cleanup unwanted hash files
I have hash fiels in the repostory and also in the differ path in the server itself
I want to remoove those hash files
please let me know how to do those.

ArndW · Post by **ArndW** » Thu Jul 21, 2005 5:04 am

Venkat,

files in the repository should be deleted from the TCL level using the command "DELETE.FILE {MyFileName}", this will remove the VOC pointer to that file as well as the physical files themselves - both the D_{MyFileName} and the {MyFileName} elements. Files in other locations that are created via DataStage jobs have no VOC pointers and can be deleted from UNIX.

kduke · Post by **kduke** » Thu Jul 21, 2005 7:28 am

This topic should be in the Server Forum.

kduke · Post by **kduke** » Thu Jul 21, 2005 7:52 am

There was some SQL posted which listed the hash file names. You need to do this in a program and see if a hash file is still being used.