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:
- SCA (System and Application Buses)
- Common Event Infrastructure
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: