DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
GMre
Participant



Joined: 29 Sep 2006
Posts: 1
Location: Canada
Points: 11

Post Posted: Tue Aug 17, 2010 7:45 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Windows
We are trying to determine how much space that Information Analysis will use.
We are going to run IA Column Analysis (plus other analysis) in production, using a DB2 Data Warehouse as the source.

What does IA permanently store when it runs column analysis?

Does it copy and permanently store exact copies of the tables that it analyzes plus other information, or does it read the input tables and extract/creates and stores only the information that it needs?

How can we estimate the space requirements for IA before we run column analysis in production?

Thank you.
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54621
Location: Sydney, Australia
Points: 296179

Post Posted: Tue Aug 17, 2010 4:19 pm Reply with quote    Back to top    

Welcome aboard. The rule of thumb is that the IADB needs to be three to four times the size of the volume of data being profiled. While this is all "permanently" stored you can clean it out once no longer required.

Analysis results are stored in the common metadata repository (XMETA). In comparison the space required for results is negligible.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours