Average IADB size?

cppwiz · Post by **cppwiz** » Thu Sep 16, 2010 7:36 am

The documentation for Information Analyzer states that 1 GB is the minimum size for IADB.

http://www-01.ibm.com/support/docview.w ... space_unix

However in our first column analysis job, we found that we need more than 10 GB to analyze 160 tables and the job failed because of a lack of space.

Is there a way to calculate what the size of IADB should be? What is a good starting size for IADB since the 1 GB minimum is a totally bogus minimum size?

ray.wurlod · Post by **ray.wurlod** » Thu Sep 16, 2010 4:22 pm

The rule of thumb (from a conversation at IOD 2009) is three to four times the volume of data to be profiled.

cppwiz · Post by **cppwiz** » Fri Sep 17, 2010 8:57 am

Thanks Ray! Our jobs finished yesterday and it looks like your rule of thumb is accurate. It took 16 GB of space in IADB to store a column analysis on a 6.7 GB database.