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
How to increase default 2gb for Hashed files.
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.