mqsimigratetables command

Supported platforms

  • Windows 2000, Windows XP
  • UNIX platforms
  • z/OS through the BIP$DBM1 and BIP$DBM2 utilities; see z/OS utility jobs

Purpose

Use the mqsimigratetables command to migrate the database tables for brokers or the Configuration Manager.
Note: If two or more brokers share the same set of database tables, you only have to migrate the database tables once.

Syntax

Parameters for the broker option

brokername
(Required) The name of the target broker used to migrate the database tables.

On Windows and UNIX platforms, if the target broker is found in an Event Broker registry path, that path is migrated to the WebSphere MQ Event Broker registry.

Parameters for the Configuration manager option

ConfigMgr
(Required) ConfigMgr
Note: This must be entered as ConfigMgr without quotation marks.

The command creates all the necessary database tables for Version 5.0 that were not there in Version 2.1. Note that any tables already existing remain.

-d
(Optional) Delete the message flows that have been checked in, but not deployed. The default is to add new tables and data but not to delete anything.

Parameters for both options

-i ServiceUserID
(Optional) The user ID under which the broker runs.
This can be in any valid username syntax. On Windows platforms, these are:
  • domain\username
  • \\server\username
  • .\username
  • username

On UNIX systems, only the last format, username, is valid.

The ServiceUserID specified must be a member of the local group mqbrkrs. On Windows platforms, it can be an indirect or direct member of the group. The ServiceUserID must also be authorized to access the home directory (where WebSphere Business Integration Event Broker has been installed), and the working directory. This ID must also be a member (either direct or indirect) of the local group mqm.

The security requirements for the ServiceUserID are detailed in Security requirements for Windows platforms for Windows platforms and in Security requirements for UNIX platforms for UNIX. platforms

-a ServicePassword
(Optional) The password for the ServiceUserID. On UNIX platforms, -a is required for Windows platforms compatibility but it is not used in relation to ServiceUserID.

Authorization

On Windows platforms, the user ID used to invoke this command must have Administrator authority on the local system.

On UNIX platforms, the user ID used to invoke this command must either be root or must be the same as that specified in the -i parameter. It must also be a member of the mqbrkrs group.

Examples

mqsimigratetables broker1
mqsimigratetables ConfigMgr -d
Related concepts
Migration
Related tasks
Migrating
Related reference
Syntax preference