You can configure an event database on a Linux, UNIX, or Windows
system using Cloudscape, DB2, or Oracle database software.
Why and when to perform this task
To configure the event database:
Steps for this task
- Go to the profile_path/event/dbconfig directory
for the profile defining the WebSphere ESB run-time environment
where you want to configure the database. (Replace profile_path with
the path to the directory containing the WebSphere ESB profile.)
- Using an ASCII text editor, open one of the provided sample database
response files. Select the sample response file for the database
software you are using:
Database |
Sample response file |
Cloudscape |
CloudscapeResponseFile.txt |
DB2 Universal Database for Linux, UNIX, and Windows |
DB2ResponseFile.txt |
Oracle Database |
OracleResponseFile.txt |
- Modify the database response file with the correct information
for your environment. (See the comments in the sample response file for more
information about the parameters, including complete syntax information.)
If you are using a DB2 database on a Linux, UNIX, or Windows system,
specify the following parameter values:
- JDBC_CLASSPATH
- The path to the DB2 JDBC driver.
- UNIVERSAL_JDBC_CLASSPATH
- The path to the Universal JDBC driver.
If you are using a DB2 database on a z/OS system, specify
the following parameter values:
- DB_NAME
- The name of the z/OS database you created for the event database.
- JDBC_CLASSPATH
- The path to the DB2 JDBC driver.
- UNIVERSAL_JDBC_DRIVER_NATIVEPATH
- The path to the Universal JDBC native library path.
- UNIVERSAL_JDBC_CLASSPATH
- The path to the Universal JDBC driver.
If you are using an Oracle database, specify the following
parameter values:
- ORACLE_HOME
- The path to the Oracle home directory.
- JDBC_CLASSPATH
- The JDBC driver class path.
- Run the database configuration script for your operating system,
specifying the name of the database response file as a parameter. Use
one of the following commands:
- Windows systems
- config_event_database.bat response_file
- Linux and UNIX systems
- config_event_database.sh response_file
For example, the following command would
configure a DB2 event database on a Windows system: config_event_database.bat
DB2ResponseFile.txt
Result
The script configures the event database and creates two JDBC data
sources: one for the event database and one for the event catalog. A message
is displayed when database configuration is complete.
Note: If your database
response file specifies EXECUTE_SCRIPTS=false, you must complete
the database configuration by manually running the generated scripts. The
default value in the sample database response file is EXECUTE_SCRIPTS=true.
What to do next
After you configure the event database, you must restart the application
server.