Skip to main content
commvault.com commvault.com
Solved

DB2 user account.. How to change it on multiple servers/ instances?

  • February 4, 2022
  • 3 replies
  • 127 views
RubeckDK
Byte
Forum|alt.badge.img+10

Hi.. 

With MS SQL we can set the account used for connecting to SQL on a group level….. Any idea on how to do the same for DB2? This seems to involve some scripting which I suck at… (unless it starts with an @echo off) :-) 

Our DB2 team is considering creating a single DB2 user for all DB2 servers/ instances to be used by CLVT… This user will have its password changed on an often basis, but we do not want to traverse every single DB2 server /instance to change the password.. .(we’ve got quite a few)

 

Any idea/ solution would be highly appreciated :-) 

 

Thank you.. 

 

Kind regards

Rubeck

 

 

 

Best answer by Mike Struening RETIRED

Sharing the solution:

DB2 user account.. How to change it on multiple servers/ instances?

Solution:

The developer suggested the following:
Use the qcommands to list all the DB2 instances, and update the properties in loop by traversing the list obtained.

https://documentation.commvault.com/11.24/expert/15033_modifying_db2_database_instance_properties_using_commvault_command_line_interface.html


The customer will need to work with his local developer to write the tool.

View original
    Did this answer your question?
    If you have a question or comment, please create a topic

    3 replies

    M
    Vaulter
    Forum|alt.badge.img+5

    @RubeckDK,

    We don’t have any known/documented process to achieve your requirement.
    We may be able to get this done using qscripts or workflows.
    However, we need to check this internally with the development team. Can you create a ticket, and let me know the case number, please?
     

    RubeckDK
    Byte
    Forum|alt.badge.img+10
    • RubeckDK
    • Author
    • Byte
    • 67 replies
    • February 7, 2022

    Hi @Mahender Reddy 

    Thank you for your reply….. I’ve now created a ticket for this question..  SR: 220207-237 

     

    Kind regards

    Rubeck

    Mike Struening
    Vaulter
    Forum|alt.badge.img+23

    Sharing the solution:

    DB2 user account.. How to change it on multiple servers/ instances?

    Solution:

    The developer suggested the following:
    Use the qcommands to list all the DB2 instances, and update the properties in loop by traversing the list obtained.

    https://documentation.commvault.com/11.24/expert/15033_modifying_db2_database_instance_properties_using_commvault_command_line_interface.html


    The customer will need to work with his local developer to write the tool.

    https://www.linkedin.com/in/michael-struening

    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings