mqsisetdbparms command

Supported platforms

  • Windows
  • Linux and UNIX systems

Purpose

Use the mqsisetdbparms command to associate a specific userid and password with each data source name (DSN) used in the following nodes:
  • Compute
  • Database
  • Filter
  • DataInsert
  • DataDelete
  • DataUpdate
  • Mapping
  • Warehouse
Where the same DSN is used in multiple nodes (referring to the same database instance), the same user Id and password combination is used.

The user ID/password pair is created in the DSN folder under the broker's registry folder.

Note: The mqsisetdbparms command does not apply to the configuration repository or broker databases.

The mqsisetdbparms command allows you to create, alter, or delete the user Id and password pairs.

Syntax

Create

Alter

Delete

Parameters

brokername
(Required) The name of the broker for which settings are to be created, altered, or deleted.
-n DataSourceName
(Required) The data source for which the user Id and password pair are to be modified.
-u DataSourceUserId
(Required for Create; Optional for Alter) The user Id to be associated with this data source.
-p DataSourcePassword
(Required for Create and Alter) The password to be associated with this data source.
-d
(Required for Delete) Delete the user Id and password pair for this data source from the registry.

Authorization

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

On UNIX systems, the user ID used to invoke this command must be root. It must also be a member of the mqbrkrs group.

Examples

mqsisetdbparms WBRK_BROKER -n MQBroker1 -u MQUserId -p password
mqsisetdbparms WBRK_BROKER -n MQBroker1 -d