Changing maximo.properties to point to a new database.

Question

How do I point Maximo to a new or different database?

Answer

1. First you must change the maximo.properties file to include the location and name of the new database.
The line that you must change will depend on the database product you are using. For our example here we will use Oracle.
In the section titled "Database Related Properties" you should see a line that looks like this:

mxe.db.url=jdbc:oracle:thin:@localhost:1521:mx6

This line is set to the currently used database for Maximo. You will need to modify this line in order to point to a new database. The syntax is as follows:

e.g Oracle thin mxe.db.url=jdbc:oracle:thin:@<HOST>:<PORT>:<SID>

The syntax for SQL Server:

// e.g. SqlServer 6.5 i-net opta 2000 driver mxe.db.url=jdbc:inetdae6:hostname:port?database=dbname&language=us_english&nowarnings=true

// e.g. SqlServer 7.0 or higher i-net opta 2000 driver
mxe.db.url=jdbc:inetdae7a:9.32.230.183:1433?database=MAX627&language=us_english&nowarnings=true&mars=false

The Syntax for DB2:
mxe.db.url=jdbc:db2://localhost:50000/dbalias

2. In Maximo 7 the maximo.properties files is encrypted. Please see the following link for modifying the maximo.properties file in release 7.
http://www-01.ibm.com/support/docview.wss?uid=swg21314942

IBM Support