Specifying the tablespace size for IBM Spectrum Control
This section provides information on the size of the tablespace to specify when you install IBM Spectrum® Control
When you install IBM Spectrum Control, you can specify the tablespace size of the repository database or accept the default values. The space needed for the IBM Spectrum Control database schema varies significantly with storage network configuration, data collection, data retention period, and other factors.
The following table provides space estimates for a storage configuration containing 5000 volumes with some general assumptions.
| Tablespace | Description of tablespace usage | Recommended size for a 5000 volume configuration | Assumptions |
|---|---|---|---|
| KEY | This tablespace is used for configuration data which is constantly used. For example, the key entity and relationships data (T_RES_STORAGE_ SUBSYSTEM, T_RES_STORAGE_VOLUME, and the normalization tables, and so forth) | 500 MB | |
| NORMAL | This tablespace is used for snapshots and miscellaneous data | 500 MB | A table that uses significant space is T_RES_STORAGE_VOLUME_ SNAPSHOT. This table uses about 2500 bytes for each record. The number of snapshots depends on the data collection activities. |
| BIG | This tablespace is used for performance statistics | 2 to 3 GB or 400® MB per day of performance data | The data collected for performance data for storage volumes can use a significant amount of space (about 200 bytes for each record). For 5000 volumes, if performance data is collected every 5 minutes, the data for one day would be 300 MB. If the data is kept for 7 days, the data collected would take about 2 to 3 GBs. If the data is kept longer, the storage must be scaled up accordingly. |
| TEMP | This tablespace is used for temporary data for query processing and other temporary tables | 1GB |