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

Question

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

icon

Best answer by Mike Struening RETIRED 10 March 2022, 19:07

View original

Mike Struening RETIRED · Accepted Answer

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.htmlThe customer will need to work with his local developer to write the tool.

Mahender Reddy · Answer

@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?

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded