ItmWarehouse: Is Big Data Keeping You Up at Night? Warehouse Projection Spreadsheet
themp 100000MJSQ Comment (1) Visits (6724)
Big Data as described in Wikipedia is the future but right now for Tivoli Data Warehousing(TDW) the task is to understand the amount of data being collected and warehoused by the Tivoli agents in your ITM infrastructure. This analysis can be simplified using the Tivoli Warehouse Projection Spreadsheet that is located here: Warehouse Projection Spreadsheet and has been uploaded to this blog entry.
The ITM 6.2.3 Installation and Setup Guide contains information on estimating the disk space requirements for the Tivoli Data Warehouse. To follow the steps required to produce an estimate, the user is required to look in the User’s Guide for each agent type to be used in the configuration to gather attribute group row lengths and information on estimating the number of rows that will be generated at each data collection interval.
The ITM 6.2.3 Warehouse Load Projections spreadsheet was created to simplify the task of producing a disk space estimate for the Tivoli Data Warehouse. This spreadsheet includes the attribute group information for more than 100 different agent types, and allows the user to perform “what-if” exercises to see the effect of different historical data collection configuration options. The spreadsheet includes four predefined charts showing the contribution of each agent type to the total TDW estimate. Because it is implemented in a standard spreadsheet format, other charts can be generated easily.