See information about the latest product version
mqsireportdbparms command
Use the mqsireportdbparms command to list all parameters that are set for a specific broker.
Supported platforms
- Windows
- Linux and UNIX systems
- z/OS®. Run this command by customizing and submitting BIPSDBP.
Purpose
You can use the mqsireportdbparms command to identify if parameters are set on a broker. If security credentials are set for the broker, you can check that a password that is associated with a user ID is what you expect by entering a password. The command returns if the input password is correct or not.
mqsireportdbparms can list the set parameters for brokers that use the following resources:
- A CICSConnection configurable service
- A data source name (DSN) that is accessed from a message flow
- An EmailServer configurable service
- An FtpServer configurable service
- An IMSConnect configurable service
- A JDBCProvider configurable service
- A JMS or JNDI resource, for example a JMSProviders configurable service
- Kerberos Key Distribution Center (KDC) client credentials for SOAPRequest nodes with a WS-Security policy set and bindings that specify Kerberos
- Lightweight Directory Access Protocol (LDAP) bind credentials for the broker's security manager
- An SMTP configurable service
- The broker keystore password
- An account name, with a user name and password, for the WebSphere® Adapters
- A WebSphere Service Registry and Repository (WSRR) configurable service
- A WXSServer configurable service
- SOAPRequest nodes
You can also return what security credentials are set on a broker, and identify if you have the correct password; see Checking the security credentials that are used by an broker.
Syntax
Parameters
All parameters that can be set by using the mqsisetdbparms command, see mqsisetdbparms command.
Authorization
- Security requirements for Linux and UNIX platforms
- Security requirements for Windows systems
- Security requirements for z/OS
Ensure that the registry is appropriately secured to prevent unauthorized access.
Examples
Checking whether there are security credentials associated with resources
mqsireportdbparms broker_name -n ftp::server
The command returns any associated security credentials for the specified resource. If there are no credentials that are set, then a warning is displayed.
mqsireportdbparms broker_name -n ftp
The command returns if any of the resources of that type have associated security credentials. If there are no credentials that are set, then a warning is displayed.
Testing if a password for a resource is associated with a specific broker.
The following examples show the use of the command to test if a password is associated with a specific resource.
If you are testing a connected SFTP resource:
mqsireportdbparms MB8BROKER -n SFTP::server -u user_id -i SSH_identity -r password
If you are testing a connected data source (that is not SFTP):mqsireportdbparms MB8BROKER -n userdb -u user_id -p password
where userdb represents the connected resource, user_id represents the user ID and password represents the password that is being tested for the resource:
The command returns if the password is correct or incorrect, and if the password was changed since the broker was last started.