Change database, password and server names in Maximo 7

On the off chance that someday you may need to change your database, password or server names, this guide will be helpful in knowing what to change.  I actually had a need to change my database from an older server to a new one a while ago and wish this was around to help me.

All installation properties are stored in the Maximo database and the maximo.properties files. These are required for fixpack installations, and other product installations. Over time passwords may change, hostnames/ip-addresses or database names may change. To change these values, follow these steps:

  1. Update the maximo.properties file on the Admin Workstation to change the IP-Address/Hostname for the database server, or to update the password.
  2. Delete the file named maximo.properties
  3. Rename the file named maximo.properties_orig to maximo.properties (this is an unencrypted file).
  4. Edit the maximo.properties file and update the hostname/IP-address for the database server.
  5. If necessary, update the password for the user to access the database.
  6. Save the file.
    Note: The file will be automatically re-encrypted when you install a fixpack or other product. If this is not an immediate activity, you can run encryptproperties.bat file located in C:\ibm\smp\maximo\tools\maximo directory against the file to encrypt it.
  7. Update the values in the maximo database to change the IP-Address/Hostname for a variety of servers, or to update passwords.
  8. Connect to the maximo database using your favorite SQL editor utility.
  9. Query the maxpropvalue table, and find the key you need to edit. For example, WAS.DeploymentManagerHostName is the key for the hostname or IP address of the WebSphere machine.
  10. Create a query to update that value to the new value, and run the query.
  11. Repeat for any passwords, ip addresses etc that need to be updated.
  12. Rebuild and redeploy the EAR files.

Did You Know...

As Maximo Experts, we have developed Maximo adds on products to make Maximo work assignment simple, reporting easy, and facilitating service requests seamless. Check out our additional products EZPlanner, EZInsight, and EZRequest.

Find Out More

One thought on “Change database, password and server names in Maximo 7

  1. Hi, i am new in maximo. i would like to know how to connect maximo database. Is there a way to connect via webspehere? or do we have to install SQL server 2008 and then connect. Kindly explain.

Leave a Reply

Your email address will not be published. Required fields are marked *