DSXchange

Hi,

our record length is 930 bytes. we need to store it in a hashed file.The default size is 2gb for hashed file.Till recently we didnt have any problem.recently volume of data increased and the hash file stage is failing..how can we increase the limit of 2gb.

i checked ulimit for my id and its unlimited.

How can i increase. we are using aix with server edition

You'll have to manually create the file as 64BIT because the GUI does not allow you to specify 32BIT or 64BIT, it's 32BIT by default. Search the forum, there's a lot of history on this.

Provided that the hashed file is undamaged, you can RESIZE it to use 64-bit pointers without needing to re-create (and therefore re-populate) it.

It's best practice to have a USING clause with a RESIZE when the file is large, so that you can make use of two separate disks.