Analyzing directory Hash Files
Moderators: chulett, rschirm, roy
Analyzing directory Hash Files
Most of our hash files are directory and not project account hash files. I would like to run some UniVerse utilities like HASH-TEST and HASH.AID against some of these hash files to tune them for performance. I think I can do this if I define the hash file to the VOC. Is this true and if so, how?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Be aware that hashed files are created as dynamic hashed files by default. So the utilities you mentioned are not appropriate. The only inspection tools for dynamic hashed files are ANALYZE.FILE (which, you will see from its VOC entry, invokes the file.stat executable with a mode of ANALYZE) and fixtool, which replaces uvfixfile though the latter can still be used for hashed files with 32-bit internal addressing.
I disagree with Kim on this; SETFILE is a perfectly adequate tool, and has the added benefit of checking and reporting when the file pointed to does not exist. Much more appropriate for newbies!
I disagree with Kim on this; SETFILE is a perfectly adequate tool, and has the added benefit of checking and reporting when the file pointed to does not exist. Much more appropriate for newbies!
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.
I am trying to run hash.help on a directory based hash file. I am running the following command from the datastage executable directory and getting the following error -
Am I missing something? I would want to avoid using SETFILE to create a pointer.
Code: Select all
/opt/ascential/Ascential/DataStage/DSEngine/bin> hash.help /files/cdo/ua/batch/shared/hash/HashLookup_POSN_1
Unable to open VOC file.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I believe that most of the static hashed file utilities (HASH.HELP, FILE.STAT, HASH.AID, GROUP.STAT, etc.) require the VOC pointer. You could always remove it afterwards.
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.