Use the table and schema creation matrices to determine
what database tables and schemas will be created automatically for
each database provider if Create Tables is
enabled.
Purpose
In
Resources > JDBC > Business
Integration Data Sources > Data Source,
you can select the check box for
Create Tables to
allow the component to create the tables the first time it accesses
the data source. If your site policy restricts table creation to a
database administrator, deselect the check box, locate the scripts
in the message box and give these scripts to your database administrator
to run. If
Create Tables is enabled, the following
tables show tables and schemas are created for the various deployment
environment functions for each database provider. An
"X" indicates
the table or schema is created.
Note: You configure Common database during profile
creation.
Note: The create table flag will be disabled for Common Event Infrastructure after the Common Event Infrastructure database has been
configured. The Common Event Infrastructure tables
can only be created when the Common Event Infrastructure server is being configured.
Table 1. Table creation based on database providerDatabase providers |
Messaging Engine |
Business Process Choreographer |
Business Process Choreographer reporting
|
Common Event Infrastructure |
Mediation Logger |
Derby Embedded |
X |
X |
X |
X |
|
Derby Network Server |
X |
X |
X |
X |
|
- DB2 Universal
- DB2 Universal Runtime Client
|
X |
X |
X |
X |
|
- DB2 UDB for iSeries (Native)
- DB2 UDB for iSeries (Toolbox)
- DB2 for i5/OS (Native)
- DB2 for i5/OS (Toolbox)
|
X |
X |
X |
X |
|
- DB2 for z/OS v8
- DB2 for z/OS v9
|
|
|
|
|
|
- Oracle 9i
- Oracle 10g
- Oracle 11g
|
X |
X |
X |
X |
|
- Microsoft SQL Server
(DataDirect)
- Microsoft SQL Server (Embedded)
- Microsoft SQL Server
(Microsoft) - Support for the Microsoft SQL Server JDBC Driver, version
1.2 was added in WebSphere Process Server, version 6.2.0.1
|
X |
X |
|
X |
|
Informix Dynamic Server |
X |
X |
|
X |
|
Note: If DB2® UDB
for
iSeries database
is not local,
Common Event Infrastructure does
not support schema creation. Database creation scripts are generated
and then used by
Common Event Infrastructure.
Table 2. Schema creation based on by database providerDatabase providers |
Messaging Engine |
Business Process Choreographer |
Business Process Choreographer Reporting |
Common Event Infrastructure |
Mediation Logger |
Derby Embedded |
X |
X |
X |
X |
|
Derby Network Server |
X |
X |
X |
X |
|
- DB2 Universal
- DB2 Universal Runtime Client
|
X |
X |
X |
X |
|
- DB2 UDB for iSeries (Native)
- DB2 UDB for iSeries (Toolbox)
- DB2 for i5/OS (Native)
- DB2 for i5/OS (Toolbox)
|
X |
X |
X |
X |
X |
- DB2 for z/OS v8
- DB2 for z/OS v9
|
|
|
|
|
|
- Oracle 9i
- Oracle 10g
- Oracle 11g
|
X |
X |
X |
X |
|
- Microsoft SQL Server (Embedded)
- Microsoft SQL Server
(DataDirect)
- Microsoft SQL Server
(Microsoft) - Support for the Microsoft SQL Server JDBC Driver, version
1.2 was added in WebSphere Process Server, version 6.2.0.1
|
|
|
|
|
|
Informix Dynamic Server |
|
|
|
|
|
Note: If DB2 UDB
for iSeries database
is not local, Common Event Infrastructure does
not support schema creation. Database creation scripts are generated
and then used by Common Event Infrastructure.