Hello.
We would like to delete all not-used hash-files. Please advise how we can get a list of all these files and how we can delete them.
Delete of not-used hash-files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Define "not used". This may be trickier than you imagine. For example you may have one or two hashed files used only in end of year processing.
Once you have identified them, deleting them is straightforward, but you must use the correct method depending on how they were created.
Once you have identified them, deleting them is straightforward, but you must use the correct method depending on how they were created.
- If they were created with a hashed file stage in an account or with a CREATE.FILE command, the correct deletion method is a DELETE.FILE command at TCL.
If they were created with a hashed file stage in a directory or with the mkdbfile command, the correct deletion method is two rm (UNIX) or del (DOS) commands, one for the data portion and one for the dictionary portion.
If they were created with a UniVerse stage or a CREATE TABLE statement, the correct command is DROP TABLE executed at TCL.
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.
Check out this post for one way to do this.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
There is an indexing program called SMART-TS, Datastage version that will consume a DSX file and would be able to show where specific instances of a hashed file are used.
You can find more information at http://www.strategies4data.com/products ... oducts.htm
Ray Daignault
You can find more information at http://www.strategies4data.com/products ... oducts.htm
Ray Daignault
As would Chuck Smith's 'list all files and tables' tool, especially if you stage up the results in a database table.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do any of these tools find hashed files whose name is a job parameter?
Another utility (on Windows only) is uvwalk with the -uvfile option; it can recursively traverse a directory structure reporting which files are hashed files and which are not.
usage: uvwalk [path] {-name filename} {-recurse} {-all} {-ntfs} {-uvfile}
[path] directory to start walking
{-name filename} filename to locate
{-recurse} recurse subdirectories
{-relative} display relative paths
{-prefix text} display located files prefixed with text
{-all} walk all logical drives
{-ntfs} NTFS partitions only
{-uvfile} execute UVfile -s to identify hashed files
Another utility (on Windows only) is uvwalk with the -uvfile option; it can recursively traverse a directory structure reporting which files are hashed files and which are not.
usage: uvwalk [path] {-name filename} {-recurse} {-all} {-ntfs} {-uvfile}
[path] directory to start walking
{-name filename} filename to locate
{-recurse} recurse subdirectories
{-relative} display relative paths
{-prefix text} display located files prefixed with text
{-all} walk all logical drives
{-ntfs} NTFS partitions only
{-uvfile} execute UVfile -s to identify hashed files
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: