Size limit in DataStage?

saikrishna · Post by **saikrishna** » Wed Nov 19, 2008 12:37 am

Hi

Is there any size limit in Datastage to load data?

Earlier in some 7.5 version, we faced a problem of 2GB size limit above which datastage couldnt load.

But recently we have 7.5.2 and we are able to load 2.7GB size data.

Can you please let us know is this size limit is no where present?

Thanks
Sai

ray.wurlod · Post by **ray.wurlod** » Wed Nov 19, 2008 12:47 am

There are no limits in DataStage - never have been. The only limits are those in the operating system. The only exception is hashed files, which do have a limit: 2GB unless created/resized to use 64-bit addressing, in which case the limit is theoretically approximately 19 million TB (assuming you have a single file system large enough).

saikrishna · Post by **saikrishna** » Wed Nov 19, 2008 8:05 am

Thanks ray

kduke · Post by **kduke** » Wed Nov 19, 2008 8:46 am

You need to set your ulimit to unlimited.