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 Sterling Control Center Monitor typically uses a production database to record, store, and report information.
Production database
IBM Sterling Control Center Monitor 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 Sterling Control Center Monitor only and should not be shared with other applications.
To generate IBM Sterling Control Center Monitor reports, the Jasper Reports Library is used with the production database to access and report information about monitored servers.
Database partitioning
IBM Sterling Control Center Monitor 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.