Hi All,
We have a static hash file that we clear and re-create every month in our production cycle. I think the hash file limit is up to 2GB. I am wondering if we are close to the size of hash file or did we exceed already? What will happen if we exceed 2GB does the job fail or does it overwrite the existing data.
Below is the current file size we have.
1900496896 DATA.30
778000384 OVER.30
There are many jobs in our production that depend on this hash file. Any kind of help is appreciated.
Thanks,
Hash Size Limit
Moderators: chulett, rschirm, roy
Thanks for quick response. Are we already at 2.2GB or the limit of hash file is 2.2GB? Do you add the size of both files data and over to calculate the size? How much risk are we in now?chulett wrote:Closer to 2.2GB and writes will fail (and it may corrupt) when the limit is exceeded. Time to switch to -64BIT or investigate the "resize" command to convert an existing 32bit hashed file. ...
Can you please explain or point me to a post where I know more about resize command.
Appreciate all your help.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The limit is governed by the largest address (offest) within a file that can be addressed by a signed 32-bit integer. Hashed files use 32-bit pointers internally to link the records in each group. The RESIZE command can, among other things, change the size of those pointers to 64-bit. The largest address that can then be represented is approximately 19 million TB.
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.