Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
estimate datamart space
- Thread starter dbatlanta
- Start date
This is not really a INFA issue. The size of the datamart will be dictated by what you are going to store in terms of non-metadata.
Ideally the INFA box should be maintained seperately from the operational storage. The database that contains the INFA repository will be relatively small and will grow very slowly (just logfiles growing noticably).
Anyway , storage is hardly an issue anymore. What are your intentions with the datamart?
Ties Blom
Ideally the INFA box should be maintained seperately from the operational storage. The database that contains the INFA repository will be relatively small and will grow very slowly (just logfiles growing noticably).
Anyway , storage is hardly an issue anymore. What are your intentions with the datamart?
Ties Blom
- Thread starter
- #3
Blom,
I have to build the datamart. It only contains 8 tables. It's an Informix datamart. I have the tables ready and have loaded with data. But how do I do the sizing estimate for the whole datamart. Is there some kind of calculation or do I have to analyze on how my data is growing?
Thank you for your response.
I have to build the datamart. It only contains 8 tables. It's an Informix datamart. I have the tables ready and have loaded with data. But how do I do the sizing estimate for the whole datamart. Is there some kind of calculation or do I have to analyze on how my data is growing?
Thank you for your response.
Well,
This is a database issue. I have no knowledge of Informix, but with DB2 I would look for the following parameters:
1. Numbers records within a table
2. Check numbers of pages occupied by table (with DB2 standard page size is 4kb)
Alternatively:
Check size of tablespace that holds the tables.
Run statistics on all tables and read the size of them (pages,Mb's)
Usually the datatables will form the bulk of space occupied , with some space for system tables.
Now, for ORACLE I would tell a different story...
Informix forum will tell you how things are dealt with for that specific RDBMS..
Ties Blom
This is a database issue. I have no knowledge of Informix, but with DB2 I would look for the following parameters:
1. Numbers records within a table
2. Check numbers of pages occupied by table (with DB2 standard page size is 4kb)
Alternatively:
Check size of tablespace that holds the tables.
Run statistics on all tables and read the size of them (pages,Mb's)
Usually the datatables will form the bulk of space occupied , with some space for system tables.
Now, for ORACLE I would tell a different story...
Informix forum will tell you how things are dealt with for that specific RDBMS..
Ties Blom
- Status