WebSphere Enterprise Service Bus for z/OS, Version 6.2.0 Operating Systems: z/OS


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

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.zseries.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).