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.
This can be specified in any valid username 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 WebSphere Message Broker is installed).
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 security requirements for the ServiceUserID are detailed in Security requirements for Windows platforms.
The user ID used to invoke this command must have Administrator authority on the local system and be part of the mqbrkrs group.