Messaging Solutions in a Linux Environment

Chapter 7. Implementing highly available brokers 229

message flow and, by implication, the message set to an execution group of

this new broker on Linux.

7.5 Creating databases and tables

DB2 UDB V8 is installed on the host was and on a Windows machine used for the

configuration manager.

7.5.1 Creating databases on the WebSphere Application Server

Logon to the WebSphere Application Server and switch to the user ID for the

database instance owner, for example db2inst1. Open a DB2 command session

by entering db2 at the command line.

1. To create the broker database, enter the following at the db2 command

prompt:

create database WBIBKDB

2. When the database is created, connect to it by entering:

connect to WBIBKD

3. Bind the DB2 CLI interface to this new database by using the command:

bind sqllib/bnd/@db2cli.lst grant public CLIPKG 5

4. End the DB2 command line environment by typing quit.

Tables and other database objects are added to this database during broker

creation.

We can now create the second database, which will be used to store the

generated messages and by the Web-based message retrieval application.

5. Open the DB2 command session and enter the commands shown in

Example 7-4. After creating the database, we connect to it and create three

tables.

Example 7-4 Creating RESDB and tables

create database RESDB

connect to RESDB

CREATE TABLE CPU(TIME TIMESTAMP NOT NULL, RESOURCE VARCHAR(3), USAGE INTEGER,

QMGR VARCHAR(20), CONSTRAINT PRIMARY KEY(TIME));

Note: The same database can be used by multiple brokers.