Creating the broker databases

Before you can create a broker, you must create a database in which the broker can store its internal data; multiple brokers can store their tables in a single database.

For information about which databases you can use, see Supported databases.

z/OS platform For information about setting up databases on z/OS®, see DB2 planning on z/OS and Customizing the z/OS environment.

To create the databases on distributed systems:

  1. If you are creating Oracle databases on UNIX® systems, run the mqsi_setupdatabase command before you create a database. For details, see the mqsi_setupdatabase command. Do not complete this step for any other database manager, or for Oracle databases on Linux or Windows®.
  2. Create the databases that you require. Choose a unique name for each broker database, for example WBRKBKDB, and keep a note of it for when you create the broker.
  3. If you are creating Sybase databases on AIX®, run the Sybase profile before you run mqsiprofile. For more information about using mqsiprofile to initialize command environments on Linux and UNIX platforms, see Command environment: Linux and UNIX systems.
You have now created a database for your broker.
Next: If you have been following the instructions in Configuring broker databases, the next task is Authorizing access to broker databases.
Related reference
Supported databases
Database locations
mqsicreatedb command
mqsideletedb command
mqsichangedbimgr command
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009. All Rights Reserved.
Last updated : 2009-01-07 15:40:28

ah14430_