Hash Files

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
medakiran
Participant
Posts: 19
Joined: Thu May 12, 2005 10:08 pm

Hash Files

Post by medakiran »

Hi All,

Can anyone tell me where the tuning information of an hash file is stored after the hash file is tuned. Is it stored in the Dictionary? or anywhere else? Our requirement is to delete hash files and at the same time not loose their tuning information.

thanks,
meda
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

There is no tuning information stored anywhere. The current hashed file type, modulo and other attributes are stored in the physical file itself in binary form. The DICTionary only describes the format of the data in the file, not the file's format.
You can get a hashed file's information display using ANALYZE.FILE or HASH.HELP (there are other commands that will do this as well). You can also use the DS/BASIC subroutine call to FILEINFO to get a lot of internal information about a file's layout.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

... and it's hashed file, not hash file.

If you delete the hashed file all information associated with it is lost. You must make your own arrangements if you need separate storage of these tuning parameters.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Hash Files

Post by chulett »

medakiran wrote:Our requirement is to delete hash files and at the same time not loose their tuning information.
Then perhaps you should just clear them rather than delete them?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply