WebSphere Message Brokers
File: ae03455_
Writer: Bill Oppenheimer

Task topic

This build: July 31, 2007 21:27:27

Modifying access to the broker database

When you created the broker, you set the user ID through which the broker accesses its database tables using the DataSourceUserID parameter on the mqsicreatebroker command. You cannot change this user ID using the mqsichangebroker command.

To change the user ID that the broker uses to access the tables in the broker database:

  1. Back up the database tables. The tables are listed in mqsicreatebroker command.
  2. Delete the broker. For more information, see Deleting a broker.
  3. Restore the database tables to the new location.
  4. Create a new broker, specifying the new user ID. For more information, see Creating a broker.
The new broker accesses the database tables using the new user ID.
Related concepts
Brokers
Databases overview
Related tasks
Configuring databases
Related reference
mqsistop command
mqsideletebroker command
mqsicreatebroker command
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:27:27

ae03455_ This topic's URL is: