Page 1 of 1
Hashed files greater than 2Gb
Posted: Thu May 18, 2006 10:46 am
by tiagogen
Anyone knows if there's a problem if my hashed file is greater than 2GB?
I hear something about it... Is it true? Or i can create hashed of any length...
Posted: Thu May 18, 2006 10:55 am
by DSguru2B
No. There is a limitation in DS for hashed files. That limit is 2.2 GB.
That is because the Hashed file is created by a 32 bit pointer. You can change that to a 64 bit pointer to remove the 2.2 GB barrier.
Look at
this post for a start.
Posted: Thu May 18, 2006 10:55 am
by Bryceson
By default DataStage Hashed File are 32BIT and House data up 2.2GB. If your data is more than 2.2GB you will need to create a 64BIT Hash.
Bryceson
Posted: Thu May 18, 2006 10:59 am
by tiagogen
Thanks!
Posted: Thu May 18, 2006 11:23 am
by kris007
You can also check this post too.
viewtopic.php?t=92644
Kris.