Database partitioning

Database partitioning includes the production database that stores and records data.

Use of partitioned database tables is an extra database configuration option for IBM® Control Center. IBM Control Center supports daily partitioned database tables. Partitioned database tables allow archiving of production data without interfering with IBM Control Center normal operations. Entire data partitions (along with their indexes) are removed when the data meets its aging requirement, removing the requirement for periodic rebuilding of indexes.

Partitioned database tables are not apparent to IBM Control Center. The data on all active partitions is available to both reports and queries. IBM Control Center implements database partitioning in so that there is a separate partition for each day’s data. To provide for monitoring servers whose clock is not set properly, IBM Control Center ensures that partitions are defined to hold data up to 30 days in the future from the clock. As data is collected from the monitored servers, the database automatically puts the data into the appropriate partition based on the date/time of the event. When data is older than the value specified in System Settings, entire data partitions, including their indexes, are removed, rather than deleted row by row.

Using partitioned database tables allows IBM Control Center to support larger monitoring environments, to collect more data efficiently, and to provide for 24x7 operations with no requirement for database maintenance.