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 |
|
- DB2 for z/OS v8
- DB2 for z/OS v9
|
|
|
|
|
|
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 |
|
- DB2 for z/OS v8
- DB2 for z/OS v9
|
|
|
|
|
|