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.

Get Messaging Solutions in a Linux Environment now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.