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?
Average IADB size?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The rule of thumb (from a conversation at IOD 2009) is three to four times the volume of data to be profiled.
Last edited by ray.wurlod on Fri Sep 17, 2010 2:47 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.