IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solutions > Plan considerations for the Tivoli Data Warehouse > Estimate the required size of your database

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

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.

First, calculate the number of aggregate records per agent. Use the following equation:

where:

#hourly

The number of hourly records for the attribute group. For example, if you have hourly records for 60 days, the number of hourly records is 1440 (60 multiplied by 24 hours per day).

#daily

The number of daily records for the attribute group. For example, if you have daily records for 12 months, the number of daily records is 365.

#weekly

The number of weekly records for the attribute group. For example, if you have weekly records for a 2-year period, the number of weekly records is 104 (2 multiplied by 52 weeks per year).

#monthly

The number of monthly records for the attribute group. For example, if you have monthly records for a 2-year period, the number of monthly records is 24.

#quarterly

The number of quarterly records for the attribute group. For example, if you have quarterly records for a 2-year period, the number of quarterly records is 8 (2 years multiplied by 4 quarters in a year).

#yearly

The number of yearly records for the attribute group. For example, if you have yearly reports for a 10-year period, the number of yearly records is 10.

# instances at each interval

The number of instances recorded at each interval. See the agent user's guide for this value.

Next, use the following equation to calculate the amount of attribute data in the warehouse for the attribute group:

where:

# aggregate records per agent

The number of aggregate records per agent for the attribute group.

attribute group aggregate record size

The size of the attribute group aggregate group. See the agent user's guide for this value.

# agents

The number of agents of the same agent type in your environment.

1048576

Represents 1 MB and causes the equation to generate a megabyte number.


Parent topic:

Estimate the required size of your database

+

Search Tips   |   Advanced Search