Use the mqsireportdbparms command to list all parameters that are set for a specific integration node.
You can use the mqsireportdbparms command to identify if parameters are set on an integration node. If security credentials are set for the integration node, 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 integration nodes that use the following resources:
You can run the mqsireportdbparms command while the integration node is running. If you changed a property for a resource on an integration node that is currently running, then the latest value is reported by the command with a warning to confirm that the change will not be in effect until the integration node is next restarted.
All parameters that can be set by using the mqsisetdbparms command, see mqsisetdbparms command.
Ensure that the registry is appropriately secured to prevent unauthorized access.
mqsireportdbparms integrationNodeName -n *
The
command returns output similar to that shown in the following example:mqsireportdbparms TESTNODE_mysystem -n *
BIP8180I: The Resource name 'jdbc::JDBC' has userID 'dbaccess'
BIP8180I: The Resource name 'ldap::LDAP' has userID 'ldapaccess'
BIP8180I: The Resource name 'ldap::ldap.mydomain2.com' has userID 'ldapd2acc'
BIP8180I: The Resource name 'mq::othermq' has userID 'remmqacc'
BIP8180I: The Resource name 'mq::QMGR::MQMV8' has userID 'mq8acc'
BIP8180I: The Resource name 'mqtt::pubsubDefault' has userID 'mqttacc'
BIP8071I: Successful command completion.
mqsireportdbparms integrationNodeName -n mq::*
The
command returns output similar to that shown in the following example:BIP8180I: The Resource name 'mq::othermq' has userID 'remmqacc'
BIP8180I: The Resource name 'mq::QMGR::MQMV8' has userID 'mq8acc'
mqsireportdbparms integrationNodeName -n mq::QMGR::MQ8
The
command returns output similar to that shown in the following example:BIP8180I: The Resource name 'mq::QMGR::MQ8' has userID 'user001'
BIP8071I: Successful command completion
mqsireportdbparms integrationNodeName -n mq::QMGR::*
The
command returns output similar to that shown in the following example:BIP8180I: The Resource name 'mq::QMGR::MQ8' has userID 'user001'
BIP8071I: Successful command completion
mqsireportdbparms integrationNodeName -n ftp::server
The command returns any associated security credentials for the specified resource. If no credentials are set, then a warning is displayed.
mqsireportdbparms integrationNodeName -n ftp
The command returns if any of the resources of that type have associated security credentials. If no credentials are set, then a warning is displayed.
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 IBNODE -n SFTP::server -u user_id -i SSH_identity -r password
If
you are testing a connected data source (that is not SFTP):mqsireportdbparms IBNODE -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 integration node was last started.