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:
- DB2 Universal V8.1 or DB2 Universal V8.2,
you can choose to either create a new database during profile creation or
augmentation or just have the profile creation or augmentation process generate
the scripts to create the database. See DB2 Universal V8.1 or DB2 Universal V8.2 for more information.
- Oracle V9.1 or Oracle V10.1, you can
choose to either create new database objects on an existing instance during
profile creation or augmentation or just have the profile creation or augmentation
process generate the scripts to create the database objects. See Oracle V9.1 or Oracle V10.1 for more information.
- DB2 UDB for z/OS and OS/390 V7 or DB2 UDB for
z/OS V8, you can choose to generate DB2 definitions or generate and
execute them as well on an existing remote z/OS machine. See DB2 UDB for z/OS and OS/390 V7 or DB2 UDB for z/OS V8 for
more information.
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.
- 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)