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


Creating the messaging engine data stores

If the messaging engine data store has not already been created, use the sibDDLGenerator command to generate the DDL statements that the database administrator will use to create the tables for the messaging engine data store.

Before you begin

Before you create and run the SQL scripts:

About this task

You must create and populate a messaging engine data source for each of the following components that you configure: You can create all the database objects in a single database, in an existing database, or in one or more new databases.
Procedure
For each data source required, follow the instructions in the WebSphere® Application Server information center to create and run the SQL scripts: Enabling your database administrator to create the data store tables. For example, to create an SIB data source for SCA, using a new database called S2SIBSCA use the following command::
sibDDLGenerator.sh -system db2 -version 8.1 -platform zos -schema
 S2CELLS -user wsadmin -create -database S2SIBSCA -storagegroup
 S2SIBSTO -buffer pool BP3 -statementend ";" > /u/hssd/SIBSCA.ddl
You can us the -buffer pool option (-buffer pool BP3 in the example) to set a non-default buffer pool when you are creating the DDL.

Results

The messaging engine data stores are created.

What to do next

Next, configure SCA and Common Event Infrastructure, as required:

task Task 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/tins_zos_sibddlgenerator.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).