Use the mqsicreatedb command to create a DB2® or a Derby database for a broker.
The mqsicreatedb command creates a database and makes it accessible to the broker. The command creates the database, creates an ODBC data source name, and if necessary, depending on the database type, creates and starts a Windows service. The command creates at most a single instance of the Windows service for each installation of a major product version.
This command supports only the installed DB2 and Derby database engines.
Specify this parameter in any valid user name syntax:
If you use the unqualified form for this user ID (username), the operating system searches for the user ID throughout its domain, starting with the local system. This search might take some time to complete.
The ServiceUserID specified must be a member of the local group mqbrkrs. The ID can be a direct or indirect member of the group. The ServiceUserID must also be authorized to access the home directory (where you have installed WebSphere® Message Broker).
This parameter is ignored if the database engine specified or defaulted for the command is DB2. A ServiceUserID is required for Derby, but only for the first invocation of this command. Subsequent invocations are associated with the existing Windows DatabaseInstanceMgr service that runs under the ServiceUserID specified on the earlier command
The user ID used to invoke this command must have Administrator authority on the local system and be a member of the mqbrkrs group.