Changing a database password without restarting the application server

When you implement a database password change, you can reduce downtime by performing a live refresh of the application server.

The following steps configure the application server to enable the live refresh functionality. The application server needs to be configured only once.

1. Create a directory that the application server can access. Copy the maximo.properties to that location. You can rename the copied file if you prefer.
2. In the application server, add the Dmxe.properties.overridepath JVM argument and set the value to the location of the properties file from step 1. For example, Dmxe.properties.overridepath=c:\properties\maximo.properties.
3. Restart the application server.

The following steps must be performed each time that you update the administrative database account password.

4. Update the maximo.properties file with new value for the mxe.db.password property and encrypt the file if necessary. If encrypting, use the –p argument to specify the current password, since the utility requires a current database connection.
5. Copy the maximo.properties file to the location specified in the mxe.properties.overridepath argument.
6. Enable Admin mode.
7. In the administrative console for the database, change the database password for the user or users.
8. In the Database Configuration application, run the Reload Database Connection action.
9. Once complete, turn off Admin Mode. For clustered environments, the update is pushed to the other nodes, which will take additional time. A node will not be able to come out of Admin mode if the refresh is incomplete.