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
Regarding Hash file
Moderators: chulett, rschirm, roy
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.
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.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
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.