WebSphere Enterprise Service Bus, Version 6.2.0 Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows


Table and schema creation matrices

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 provider
Database 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 provider
Database 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.

reference Reference topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.doc/doc/rpln_crt_table_matrix.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).