IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solutions > Plan considerations for the Tivoli Data Warehouse
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Estimate the required size of your database
One of the factors to consider when planning the size of database that you need is the amount and type of information you will collect for agent history data collection. Each of the agent user's guides provide capacity planning information to help you calculate the amount of disk space required by data for each attribute group.
Use the information in this section to complete the calculations for determining how large your data warehouse database needs to be.
Use the worksheets in Installation worksheets to record the values from these calculations. To print these, go to the IBM Tivoli Monitoring information center: IBM Tivoli Monitoring Information Center .
You might use the Warehouse Load Projection tool available in the IBM Tivoli Integrated Service Management Library. (Search on "Warehouse Load Projects at the following site: IBM Integrated Service Management Library.) The tool does all the calculations for you and includes data for nearly all of the IBM Tivoli Monitoring V6.x-based monitoring agents.
- Step 1: Determine the number of detailed records per day for each attribute group
Determine the number of detailed records per day for each attribute group that you want to collect data for.
- Step 2: Determine the hard disk drive footprint for each attribute group
Determine the hard disk drive footprint for each attribute group. The result generated by this formula gives an estimate of the amount of disk space used for this attribute group for 24 hours worth of data for a single agent.
- Step 3: Determine the amount of detailed data for each attribute group
Determine the amount of detailed data in the warehouse database for each attribute group.
- Step 4: Calculate the amount of aggregate data for each attribute group
Determine the amount of aggregate data in the warehouse for each attribute group.
- Step 5: Determine the estimated size of your database
First, determine the total space required for each attribute group. Add the amount of detailed data and the amount of aggregate data for the attribute group.
Parent topic:
Plan considerations for the Tivoli Data Warehouse