Common Event Infrastructure database specifications

In order to monitor WebSphere Process Server events, you can capture events as they occur in a database. The Common Event Infrastructure database is used for this purpose.

The WebSphere Process Server Common Event Infrastructure database is created for a stand-alone profile and for each instance of a Common Event Infrastructure server in a network deployment environment. The Common Event Infrastructure database is an internal device and you do not interact directly with it. All interactions with the Common Event Infrastructure database must be performed using the supported Common Event Infrastructure APIs.

See Configuring the event database for more information.

Supported database types

The following databases are supported for use as the Common Event Infrastructure database:
  • Cloudscape™ V5.1
  • DB2 Universal Database™ V8.1
  • DB2 Universal Database V8.2
  • DB2 Universal Database for z/OS and OS/390 V7.1
  • DB2 Universal Database for z/OS V8.1
  • Oracle V9.1
  • Oracle V10.1

Database Management Service (DBMS) instances

The Common Event Infrastructure database is only created for a stand-alone server profile so there is one instance of the DBMS for each server.

Configuration actions during profile creation

Configuration of the Common Event Infrastructure database is done by the profile template ANT script configCei.ant invoking the Common Event Infrastructure API with a response file containing all the necessary properties for the desired configuration.

SQL scripts

Database configuration is accomplished by creating a response file invoking the Common Event Infrastructure API with it as a parameter. As Common Event Infrastructure processes this response file and creates scripts, they are placed under the following location: profilePath/event/dbscripts/dbtype

JDBC provider

The scripts that are used for creating the JDBC provider for the Common Event Infrastructure database are stored in the following location: install_root/profiles/profilename/event/dsscripts/dbtype

The JNDI names of the components are:

jndiName="jdbc/cei"

jndiName="jdbc/eventcatalog"

Tables

Many tables are created. Look under the generated scripts to see which tables are generated for the given database product.

Exported scripts

Shell scripts are created in the following directory to be used to run the generated SQL scripts.
install_root/profiles/profilename/event/dbscripts/dbtype 

User ID privileges

The user credentials that you provide in the Profile wizard must have sufficient permissions to be able to create tablespaces, tables, indexes, and stored procedures. For the Create new (local) database option, the user identity must have the necessary privileges to create a new database.

Additional information

More information about configuring the Common Event Infrastructure can be found in Configuring the event database.


Last updated: Wed 01 Nov 2006 07:47:12

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)