Issuing database commands on Windows

On Windows®, use special commands to create and delete databases for use by a broker.

Only DB2® and Derby databases are supported with the supplied commands:

The mqsilist command lists the databases that have been created by the mqsicreatedb command. Only databases created by the mqsicreatedb command can be deleted by the mqsideletedb command.

The Default Configuration wizard and the Prepare Samples wizard use the mqsicreatedb command to create the databases for the broker and the samples, using the default database engine. Therefore, you can list these databases by using the mqsilist command and specifying the parameter DatabaseInstanceMgr.

Supported database engines

If DB2 version 8.1 Fix Pack 7 or later is installed, both DB2 and Derby databases can be created and used. If DB2 Run-time Client Version 8.2 is installed, only Derby databases are supported. If an earlier version of DB2 is installed, only DB2 databases can be created.

Start of changeThe mqsicreatedb command has an option to select the database engine to use (either DB2 or Derby). The default for this option is DB2 unless only DB2 Run-time Client Version 8.2 is installed, in which case a Derby database is created.End of change

Database Instance manager

The databases that are created by mqsicreatedb are managed by a component called the Database Instance manager. This component exists only on Windows. The component stores a list of all the databases created and which database engine is used for each database. No process or Windows service is required for the Database Instance manager component, and if you start the component it is not recognized.

The first time a Derby database is created, a Windows service called IBM MQSeries® Broker DatabaseInstanceMgr6 is created and started. This service is required in order to access Derby databases. This service can be started or stopped by the mqsistart and mqsistop commands, and automatically starts when Windows is started, if necessary. The service is deleted when the last Derby database is deleted. At most one Database Instance manager Windows service exists, even if you install WebSphere® Event Broker more than once on your Windows computer (multiple installed instances).

The database commands affect all the databases created in any installed instance on your Windows computer, regardless of the instance under which they are created. For example, the command mqsilist DatabaseInstanceMgr6 lists all the databases that have been created by the mqsicreatedb command on this Windows computer. Use the mqsichangedbimgr command to change the user name and password under which the Database Instance manager service runs. Run this command only if passwords change, or if user names are updated after the initial installation and configuration. For more information, see Using Derby databases on Windows.

Creating and deleting databases

Use the mqsicreatedb command to create databases for broker use. The Prepare Samples wizard and the Default Configuration wizard, for example, use the mqsicreatedb command to create their databases on Windows. When the database is created (in either DB2 or Derby), the ODBC data source name (DSN) is also created (with the same name).

Because the data source names and the Database Instance manager component are system wide, you cannot create two databases with the same name, on the same Windows computer, even if they are for brokers on different installed instances of WebSphere Event Broker. The mqsicreatedb command warns you if you try to do so. A database created by the mqsicreatedb command can be deleted by the mqsideletedb command, even if that database is in use by a broker. See the command descriptions for more information.

Related concepts
Using Derby databases on Windows
Related reference
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:38

ah35005_