Creating the event runtime database

Decision Server Events requires a database for the event runtime. This event runtime is the shared, secured location that contains assets such as data connections, business objects, events, and actions.

Before you begin

The configuration tasks in this topic refer to configuring the event runtime database for distributed platforms.

If you want to use the Apache Derby database that is embedded in WebSphere® Application Server as the event runtime database, the database (called event runtime) and tables are created and configured for you during the installation process. If you want to use another supported database manager (including another installation of Apache Derby), you must create the event runtime database before you start the installer.

Apache Derby is not supported in a production environment.

If you want to use a remote DB2® database as the database for the event runtime, you must install the supplied DB2 Client Support.

  1. Start the DB2 installer wizard.
  2. Select Custom Installation
  3. Select the Client support feature and clear all the other features.
  4. Complete the installation.

About this task

The full list of supported database managers is available on the web at System requirements.

Procedure

When you create the event runtime database, record the following information:
  • Event runtime database name of your choice
  • Host name of the server where the database is located
  • Port used to access the database
  • Database user ID to be used to access the database
  • Password associated with the database user ID

This information is used when configuring the event runtime database. See Event runtime database settings.

Note:
  • To install, you must have full administrative privileges for the event runtime database. For example, for DB2, you must be authorized to CONNECT, CREATETAB, and so on. For Oracle you must have authority to ALTER DATABASE, CREATE ANY TABLE, and so on. These full administrative privileges are only required to install Decision Server Events, not to use it. If you do not have full administrative privileges, you can still install if your Database Administrator (DBA) creates the event runtime tables in the database by using the manual instructions before you run the installer. After installation, you only need read, write, and delete access as a user.
  • For all database managers except embedded Apache Derby: the database manager must be running before the installation starts and you must have available the JDBC .jar file for the database manager.
Parent topic: Configuring the event runtime database for Decision Server Events