Configuring a CEI database

You can configure a Common Event Infrastructure (CEI) database manually and use the CEI functionality for IBM® Business Monitor.

1. To create the data store for the CEI event service, run the appropriate command:
   • configEventServiceDB2DB command
   • configEventServiceDB2ZOSDB command
   • configEventServiceOracleDB command
   • configEventServiceSQLServerDB command
   Important: Do not create an event service data store for production environments because the performance of persisting events may be impacted.
2. After generating the database scripts, save your changes using $AdminConfig save. In addition to generating the database scripts, the commands create JDBC resources for the CEI event service to use.
3. Copy the scripts that you generated to the database server. The directory location for the scripts depends on the scope where the CEI is deployed. The default location for the scripts is one of the following directories, depending on the scope where the CEI is deployed:
   • profile_root/databases/event/<cluster_name>/dbscripts/<database_type>
   • profile_root/databases/event/<node_name>/<server_name>/dbscripts/<database_type>
   where
   • profile_root is the profile directory for the deployment manager profile
   • cluster_name is the cluster where the CEI is deployed
   • node_name is the node where the CEI is deployed
   • server_name is the server where the CEI is deployed
   • database_type is the directory for your database, for example db2 or oracle
4. Log into the database server as a user with read and write access on the database. Open a command prompt and initialize the command line interface for the database software. To create the event database, run the script for your database type (for example cr_event_db2 server <db2_user>).