Truesight Middleware and Transaction Management: How to change database credentials?

Version 4
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    TrueSight Middleware Transaction Monitor


    BMC Middleware Management - Transaction Monitoring Truesight Middleware and Transaction Monitoring Truesight Middleware Management



    Database credentials (database type, database schema owner, database name, database password) have changed. How to reconfigure the product so it reflects these changes?

    Applies to

    BMC Middleware Management - Performance and Availability
    BMC Middleware Management - Transaction Monitoring
    BMC Middleware and Transaction Management
    BMC Application Transaction Tracing
    BMC TrueSight Middleware and Transaction Monitor







    Legacy ID:KA357159


    You can watch a how-to video by clicking the link below:



    Perform these steps to change the db_name, db_password, db_user or db_type

    From the command line

    • Stop all services except the Application Service (qpas).    This  step is fine for version until 7.0.
    • Stop all services,  start from a different command line Application Service (qpas) in Jetty only mode, with qpas -j  . This step is required with version 8.x and higher.
    • Open Windows command line or a UNIX shell and navigate to the installation directory.
    • Run the mqsusertool ( Windows ) or ( Unix / Linux )
      mqsusertool --database -db_name <db_connection_name> -db_user <db_connection_user> -db_password <db_connection_password> -db_type <db_vendor_and_version> -target LDAP -logon_user <SA> -logon_password <your_SA_password>
    • Stop Application Service (qpas).
    • Start all services.

    From the Management Console

    • On the Security tab, highlight the "database_login" group.
    • Make sure that the group is not read-only  (click on the "Toggle Read-Only State" icon in the toolbar if it is).
    • Click on the "Edit Advanced Properties" icon in the toolbar.
    • Select the appropriate database type from the dropdown list.
    • Confirm the chage by clicking OK.
    • Highlight the "database_login" group.
    • Set it to read-only again.
    • Save the changes.
    • Quit the Management Console.
    • Stop and start the services.
    Additional information

    Not all db_* parameters need to be specified. If, for example, only the database type ("db_type") needs to be changed, the other db_* parameters can be omitted. 


    Example database types from different versions, please be aware that not every type is support in every product version

    "DB2 9.2"              use  DB2
    "DB2 9.5"              use  DB2
    "DB2 9.7"              use  DB2
    "DB2 10.5"           use DB2
    "Oracle 9.2"           or ORACLE_92
    "Oracle 10.1"          or ORACLE_101
    "Oracle 10.2"          or ORACLE_102
    "Oracle 11.1"          or ORACLE_111
    "Oracle 11.2"          or ORACLE_112
    "Oracle 12.1"          or ORACLE_121
    "Microsoft SQL Server" or MSSQL


    Note that Oracle 12.2 and 18 should use database type Oracle 12.1

    Running mqsusertool in version 7.x  without command line parameters will show the full command line help


    Running mqsusertool in version 8.x  with -h command line parameters will show the full command line help

    KEYWORDS: database, password, change, expired, login failed


    Article Number:


    Article Type:


      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles