Page 1 of 1
How to cleanup unwanted hash files
Posted: Thu Jul 21, 2005 5:01 am
by venkat n
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.
Posted: Thu Jul 21, 2005 5:04 am
by ArndW
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.
Posted: Thu Jul 21, 2005 7:28 am
by kduke
This topic should be in the Server Forum.
Posted: Thu Jul 21, 2005 7:52 am
by kduke
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.