WebSphere WebSphere Enterprise Service Bus, Version 6.0.1 Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Configuring the event database (Linux, UNIX, and Windows systems)

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

  1. 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.)
  2. 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
  3. 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.
  4. 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.

Task topic

Terms of Use | Rate this page

Timestamp iconLast updated: 13 Dec 2005
http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/index.jsp?topic=/com.ibm.websphere.wesb.doc\doc\tcei_install_configureDbLUW.html

(C) Copyright IBM Corporation 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)