I would like to know if there is a way to determine which hash files are no longer being used by any job.
Is there a way to list the hash files in the account directory?
Thanks in advance,
Andrea
account hash files usage
Moderators: chulett, rschirm, roy
If metadata exists for the table/hash in the repository then you can simply use the manager to do a usage analysis. Right click on the object (table def) and choose usage analysis.
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
Andrea,
if you used table definitions from the MANAGER in your jobs then you can use usage-analysis to find out in which jobs a given table definition was used.
If not, then tracking down usage is a bit more involved. If you have a table name that you think isn't being used anymore, I would do a quick and dirty search using a full export of the project and then a text search to see if the table name pops up. Not 100% guaranteed to function, but should give you a good indication.
I might just use the date-time-last-modified information from UNIX as a viable indicator as well.
if you used table definitions from the MANAGER in your jobs then you can use usage-analysis to find out in which jobs a given table definition was used.
If not, then tracking down usage is a bit more involved. If you have a table name that you think isn't being used anymore, I would do a quick and dirty search using a full export of the project and then a text search to see if the table name pops up. Not 100% guaranteed to function, but should give you a good indication.
I might just use the date-time-last-modified information from UNIX as a viable indicator as well.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom