Can I change the db password in the web UI for Jazz applications without restarting the server?
Accepted answer
Short answer is...no, the server does not need to be restarted.
Long answer....
Long answer....
When you change the database password on the advanced properties page, it triggers the connection pool service to restart. This causes all services that depend on it to also restart (which is practically all of them). So the server will practically restart anyway, and the UI will likely be unresponsive for a period of time while all the services restart.
Several bugs were fixed in 4.0.3 that caused deadlocks to occur when services were stopped and restarted. Therefore, if you're on 4.0.2 or earlier, the better option would be to restart the server.
One other answer
A late addition to maybe complement the right answer above:
The impact would be so brief, if SCM and DBA team up well to complete the implementation or the below procedure is adopted, to be worth a notification.
The following procedure we adopted would further minimize the risk and the weight of impact, and would as well remove the necessity of schedule sync between the two teams (SCM & DBA):
- At their convenience, DBA team creates a second set of bona fide ID/passwd, switchToID/switchToPasswd (assuming the same set used for all DB's) ahead of passwd-change D-day.
- SCM team changes the passwd (via thus created set of ID/passwd or another existing set of ID/to-be-used-newPasswd)
- Independently verify login, credentials, permissions ( by direct access to the DB's) rigorously (to avoid the brouhaha we got in due to permissions to the switchToID, and too shallow check: Jazz Forum Post 218742) of the switchToID
- Change the database DB/passwd on the Data Connection web page. Note that for each app (JTS, RTC, RRC, RQM) there are two sets of ID/passwd on the web page, one for the app DB, one for datawarehouse DB: Switch from switchFromID/switchFromPasswd to switchToID/switchToPasswd.
- Save the web page: Be patient, the save of the web page may take time to complete
- Verify access from the Jazz tools.
- Optionally verify the DB log(s).
- Again at their convenience, post passwd change completion, DBA team changes the switchFromPasswd, of the now idle ID switchFromID, to an agreed-to new passwd for the next passwd change.
On subsequent passwd change, the first step of creating a new set of ID/passwd will be skipped, the passwd change procedure will start with the SCM team performing the passwd change on the waiting set of ID/passwd.