Hash Size Limit

[New2DS]

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,

[chulett]

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.

[New2DS]

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. ...

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?

Can you please explain or point me to a post where I know more about resize command.

Appreciate all your help.

[ray.wurlod]

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.

[chulett]

The limit. And an exact search for "resize" should turn up quite a number of discussions on this topic.