Databases
Databases refer to traditional relational databases such as IBM® DB2®, Oracle, or Microsoft SQL Server. Event processors (EPs) that connect to and have access to a common database are part of the same cluster. IBM Control Center typically uses a production database and a reports database to record, store, and report information.
Production database
IBM Control Center records the information that is gathered from the monitored servers for historical purposes in the production database. For example, data that is obtained from monitored servers and is used in user reports is stored in the production database. As information is received from manually defined servers, events are generated and passed through the rule, metadata, and SLC services as they are written to the events table of the database. For dynamically discovered servers, events are first written to the unprocessed event table. After events are processed, they are written to the events table.
The database server should be used by IBM Control Center only and should not be shared with other applications.
Reports database
To generate IBM Control Center reports, the Cognos® Business Intelligence server is used with the production and reports databases to access and report information about monitored servers.
Staging database
If you have a staging database and are upgrading to IBM Control Center V6.1, you can continue to use the staging database. However, the staging database is no longer efficient for reading, writing, storing, and maintaining. If you are using both a production and staging database, you should move your data to the partitioned database.
Database partitioning
IBM Control Center can be set up to use database partitioning. This process allows the data in the production database to be partitioned by date. Database partitioning can improve database performance. For more information, see Database partitioning.