Is it possible change the database passwords for these systems without creating Application downtime (CLM)?
Arun K Sriramaiah (3.2k●2●36●77)
| asked Feb 19 '14, 12:34 p.m.
edited Feb 20 '14, 1:39 p.m. by Paul Slauenwhite (8.4k●1●2)
Hi,
Is it possible change the database passwords for these systems without creating Application downtime (CLM)?
what is the impact on the current database transactions ?
Other ETL jobs transactions ( it uses the functional user id ) ?
Impact on the active services ?
Are there any scripts or API-calls which support this action to perform this task on many RTC systems failsafe and efficient?
Regards,
Arun.
|
One answer
RTC is DB dependant, and any action that causes communication to fail between RTC and the DB can trigger an interuption to service. To minimize the service interuption I would suggest the following:
1. Wait until the load in the server is light 2. Change the password for each application by going to the webUI -> application -> server -> advanced properties page 3. Locate the DB Id and update the password and save NOTE: 1. I am not certain, but do not think a server restart would be needed for this approach Scripting the DB passworrd change 1. I do not think there is an API to update the password. 2. A script can be created to update the DB password directly in the teamserver.properties files, but the issue with this approach is a) may require a server restart and b) The password will not be encrypted |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
I see the answers below but not sure, what difference does it make with two different db2 user accounts.
Please let me know if you have any comments on my requirement