Issuing database commands on Windows

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

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.

Use the mqsisetdbparms command to manage the access security for user databases only. It has no effect on Derby databases, which have no access security protection, nor on broker databases in general, which are governed by the access security settings in the broker itself. The rest of this topic applies only to the mqsicreatedb, mqsideletedb, and mqsichangedbimgr commands.

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® Message 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 or for application 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 Message 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.
Last updated : 2009-01-07 15:22:13

ah35005_