Waht is the size of Dataset and SAS Dataset in Version 8

siva4joy · Post by **siva4joy** » Wed Oct 01, 2008 10:33 am

Hi,

Can anybody tell me what is the Maximum size of data can be placed in a Dataset and SAS Dataset in Datastage Version 8?

Thanks for your help.

Thanks and Regards,
Sivasankar.Z

ArndW · Post by **ArndW** » Wed Oct 01, 2008 11:06 am

I'm not sure that there is a limit that you can reach, as DataSets use multiple physical files to store data.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 01, 2008 3:17 pm

You don't have that much disk space.

The limit is approximately (max_file_size * 10000 * partition_count).

So, if the maximum file size on your operating system is 2GB and your Data Set is five partitions, that's 100000GB. Most operating systems these size have a larger allowable maximum file size than 2GB.