Hash file in account/directory path

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
saprebv
Participant
Posts: 11
Joined: Wed Aug 25, 2004 1:37 am

Hash file in account/directory path

Post by saprebv »

Is there any disadvantages/advantage of creating hash file in account over creating hash file in account?

Thank you,
Regards,
Balkrishna Sapre
saprebv
Participant
Posts: 11
Joined: Wed Aug 25, 2004 1:37 am

Post by saprebv »

sorry .
read question as

Is there any disadvantages/advantage of creating hash file in account over creating hash file in directory path?
jeredleo
Participant
Posts: 74
Joined: Thu Jun 19, 2003 8:49 am

Post by jeredleo »

Wouldn't mind knowing this info myself. We use the directory path mainly due to the lack of Universe commands to maintain the hash files through the administrator. This way we can copy and move our hash files to where-ever we need them to be.

JB
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

JB is correct. You can move files around because the VOC in the account is not updated. You can still move them if you know Universe but you may have to switch to a file path. Having a VOC entry allows you to LIST or SQL SELECT against your hash file file. It is also easier to run HASH.HELP or ANALYZE.FILE. This can be overcome as well with SETFILE.

I have no personal preference. I think both are fairly easy to use. I think directory paths are a little more maintenence. If you create one big filesystem with all your accounts in it then it is easier to use account. If you have lots of large files on several filesystems then use path. The larger the files the more likely you will need to use paths and learn to administor Universe.
Mamu Kim
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I also have no great preference. In my projects I generally arrange for the hashed files to be in a directory (or sometimes more than one, functionally grouped). This means that the project directory itself doesn't grow out of control!

However, I also arrange for VOC pointers to exist so that UniVerse adminstration tools can be used. This can be done with SETFILE or by creating the hashed files with CREATE TABLE with its DATA and DICT extensions (search forum for more on this).

If the hashed file or directory is ever moved, this approach adds the miniscule overhead of needing to update the VOC pointer (using SETFILE with the OVERWRITING keyword).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply