Additional database configuration information for Common Event Infrastructure panel

If you selected any database other than Cloudscape V5.1 from the Common Event Infrastructure configuration panel in the Profile wizard, a follow-up panel asks you for database-specific information. This panel, called the Additional database configuration information for Common Event Infrastructure panel, contains slightly different fields and default values, depending on the database product you selected.

On the Common Event Infrastructure configuration panel, if you selected:
Important: If you selected Cloudscape V5.1, no additional database configuration is necessary.

The profile creation or augmentation process always creates the data source.

DB2 Universal V8.1 or DB2 Universal V8.2

If you selected either DB2 Universal V8.1 or DB2 Universal V8.2 on the Common Event Infrastructure configuration panel, do the following on the next panel:
  • Select the radio button beside either:
    • Create new database – Creates the event and eventcat databases, creates the required tables within each database, and generates the scripts to do so during the profile creation or augmentation process.
    • Generate scripts to create new database – Generates the scripts to create the event and eventcat databases and the required tables within each database. These scripts must be run after the profile creation or augmentation process to have a working Common Event Infrastructure component.
  • Enter values for:
    • Database name (or accept the default value of event -- the database name must be eight characters or less in length).
    • User ID to authenticate with the database.
    • Password (the password for database authentication).
    • Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.
When you select Next, another panel is displayed, on which you must do the following:
  • For the field Location (directory) of JDBC driver classpath files, either accept the default value of install_root/universalDriver_wbi/lib on Linux and UNIX platforms or install_root\universalDriver_wbi\lib on Windows platforms, or enter a different location. This value must point to the directory holding the following files:
    • db2jcc.jar
    • db2jcc_license_cisuz.jar or db2jcc_license_cu.jar
  • Choose either JDBC Driver Type 2 or 4 (which is the default value).
    • If you select JDBC driver type 2, values for the Database server name and Server port fields are not needed. However, you must enter a value for the Database node name, if DB2 server remote field if your DB2 server is located remotely.
    • If you accept the default selection of JDBC driver type 4, you must enter values for the Database server name and Server port fields (or accept the default values of localhost and 50000, respectively). You must enter a value for the Database node name, if DB2 server remote field if your DB2 server is located remotely.

Select Next. The Business Process Choreographer configuration panel is displayed. At this point, return to step 9 in Configuring a stand-alone server profile.

Oracle V9.1 or Oracle V10.1

If you selected either Oracle V9.1 or Oracle V10.1 on the Common Event Infrastructure configuration panel, do the following on the next panel:
  • Select the radio button beside either:
    • Create new database objects on an existing instance (OCI) – Creates the event and eventcat database objects, creates the required tables within each database object, and generates the scripts to do so during the profile creation or augmentation process. In this case, the scripts are for reference only.
    • Generate scripts to create new database – Generates the scripts to create the event and eventcat database objects and the required tables within each database. These scripts must be run after the profile creation or augmentation process to have a working Common Event Infrastructure database.
  • Enter values for:
    • Database instance name (sid) (the database instance name must be eight characters or less in length).
    • User ID to create in the database.
    • Password (the password for the created user id).
    • Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.
When you select Next, one of the following panels is displayed, depending on the radio button you selected:
  • If you selected Create new database objects on an existing instance (OCI), a panel is displayed on which you must enter values for:
    • User ID with SYSDBA authority.
    • Password (for User Id with SYSDBA authority).
    • Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.
    • Location (directory) of JDBC driver classpath files.

    Because you are creating new database objects, the JDBC driver type can only be OCI, the Database server name will always be localhost, and the Server port will always be 1521. Therefore, you are not prompted to enter those parameters. Select Next. The Business Process Choreographer configuration panel is displayed.

    At this point, return to step 9 in the topic Configuring a stand-alone server profile.

  • If you selected Generate scripts to create new database, a panel is displayed on which you must enter values for:
    • User ID with SYSDBA authority.
    • Password (for User Id with SYSDBA authority).
    • Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.
    • Location (directory) of JDBC driver classpath files.

    You must also select the radio button beside either JDBC Driver Type OCI (which is the default value) or thin, and enter values for the Database server name and Server port fields (or accept the default values of localhost and 1521, respectively). Select Next. The Business Process Choreographer configuration panel is displayed.

    At this point, return to step 9 in the topic Configuring a stand-alone server profile.

DB2 UDB for z/OS and OS/390 V7 or DB2 UDB for z/OS V8

If you selected either DB2 UDB for z/OS and OS/390 V7 or DB2 UDB for z/OS V8 on the Common Event Infrastructure configuration panel, do the following on the next panel:
  • Select the radio button beside either:
    • Generate DB2 definitions only – Generates scripts to create required tables in the event and eventcat databases, which can be run after the profile creation or augmentation process.
    • Generate DB2 definitions and execute – Generates scripts and creates required tables in the event and eventcat databases during the profile creation or augmentation process.
    Important: If you select Generate DB2 definitions only, you or your database administrator (DBA) must create the event and eventcat databases and correct storage groups on the remote server, and run the generated scripts manually against them. If you select Generate DB2 definitions and execute, the event and eventcat databases must already exist on the remote server before profile creation or augmentation.
    To create the databases and storage groups, you or your DBA can use your site's standard database definition tools and procedures to edit and run the default script provided in the following directory:
    • Icon indicating Linux platforms Icon indicating UNIX platforms On Linux and UNIX platforms: install_root/dbscripts/CEI/DB2/createCeiDb2Zos.sql.
    • Icon indicating Windows platforms On Windows platforms: install_root\dbscripts\CEI\DB2\createCeiDb2Zos.sql.
    The script that will be generated by the Profile wizard and that must be run against the databases, is found in the following directory:
    • Icon indicating Linux platforms Icon indicating UNIX platforms On Linux and UNIX platforms: install_root/profiles/profile_name/logs/ceidef.ddl.
    • Icon indicating Windows platforms On Windows platforms: install_root\profiles\profile_name\logs\ceidef.ddl
  • Enter values for:
    • User ID to authenticate with the database.
    • Password (the password for database authentication).
    • Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.
    You must accept the default value of event for the Database name.
When you select Next, another panel is displayed, on which you must do the following:
  • For the field Location (directory) of JDBC driver classpath files, either accept the default value of install_root/universalDriver_wbi/lib on Linux and UNIX platforms or install_root\universalDriver_wbi\lib on Windows platforms, or enter a different location. This value must point to the directory holding the following files:
    • db2jcc.jar
    • db2jcc_license_cisuz.jar
  • Enter values for the Database server name and Location name of the database server.
  • Enter values for the Server port and Database storage group name, (or accept the default values of 446 and EVTSTO, respectively).

Select Next. The Business Process Choreographer configuration panel is displayed. At this point, return to step 9 in the topic Configuring a stand-alone server profile.


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)