Hi All,
When data is getting copied from table to hashfile its exceeding more than 2GB capacity because of which ds job is failing.
Can you please let me know how to increase 2GB size.
Thanks in Advance,
Hash File size exceeding 2GB
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
2GB is the limit imposed by 32-bit operating system. If your server is 64 bit, you can convert it to 64 bit hashed file for more space.
Just out of curiosity, can't you restrict number of columns i.e. row length to fit it in 2GB?
Just out of curiosity, can't you restrict number of columns i.e. row length to fit it in 2GB?
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
No need for a 64bit server, 64BIT hashed files are supported on any platform as the limit is the addressing used internal to the hashed file itself. An exact search here for -64BIT will turn up quite a number of conversations on this topic.
Note that your O/S may very well limit files of any kind to 2GB or less, but that really isn't the norm any more.
Note that your O/S may very well limit files of any kind to 2GB or less, but that really isn't the norm any more.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI