Page 1 of 1

Remove hash

Posted: Tue May 03, 2011 8:25 pm
by RAI ROUSES
At the end of the job I would like to remove the hash file ? How can I do that ?

Cheers
8) Rai 8)

Posted: Tue May 03, 2011 8:27 pm
by ray.wurlod
Why did you post this in the parallel forum?

Posted: Tue May 03, 2011 8:44 pm
by RAI ROUSES
oops .....

Posted: Tue May 03, 2011 9:18 pm
by chulett
What you talk'n about Ray? :wink:

Posted: Tue May 03, 2011 9:21 pm
by chulett
I'm curious why you think you need to delete the hashed file when you are done? From both a lineage and trouble-shooting standpoint, you may be in trouble if that information is gone. Why not simply clear it (or drop and recreate it) at the start of the next run, an ability that's built into the stage?

Posted: Wed May 04, 2011 4:46 am
by ray.wurlod
You can delete the hashed file (note: it's not "hash" file) using an after-stage or after-job subroutine. The actual command to use will depend on whether you are using an account-based or directory-based ("pathed") hashed file.

Posted: Wed May 04, 2011 7:02 am
by chulett
As noted, it depends on how the hashed file was created. The log will show the command used, from which you can infer what you need to do to delete. So, pathed or in an account?

Posted: Wed May 04, 2011 7:15 am
by greggknight
I would use a parameter in the hashfile name so that each one is related to the run it was loaded in.

I agree with previous posts that they should not be removed.
1) for trouble shooting reasons.
2) disk space. What I mean by that is if the files maintain approx the same size each time they will hold the space they need for each run.
.......