Page 1 of 1
Regarding Hash file
Posted: Wed May 23, 2007 4:53 pm
by vijaykumar
Hi Gurus,
The default size of hash file is 2 Gb. Can we increase the default size. If so can anyone specify the steps the default size.
cheers;
Vijay
Posted: Wed May 23, 2007 4:59 pm
by narasimha
You need use a 64 bit hashed file to store more than 2 GB of data.
Either create a new 64 bit hashed file or resize the existing 32 bit to a 64 bit one.
If you do a search you will get a lot of examples on how to achieve this.
Posted: Wed May 23, 2007 5:35 pm
by ray.wurlod
It is very much better practice to question why you might need to go anywhere near this size. Only populate that hashed file (note, not "hash" file) with those columns that are absolutely necessary, and only populate the hashed file with those rows that are absolutely necessary.
If I may indulge in a small piece of pedantry, it's the default maximum size of a hashed file that is 2GB. The default size of a newly-created hashed file in DataStage is 6KB (which includes two headers and 2KB of available data storage).