Maximo

 View Only

 IBM Maximo Asset Management 7.6 and IBM WebSphere 9.0.5.14 - Complete Backup and Test Restore Plan

Allan's profile image
Allan posted Tue September 23, 2025 06:31 PM

I have inherited a production environment that is using IBM Maximo Asset Management 7.6 and IBM WebSphere 9.0.5.14. These applications are residing on a Windows Server 2019 Standard server. The database of Maximo (maxdb76) is residing on Microsoft SQL Server 2019. That SQL server is also being hosted on a Windows Server 2019 Standard server, but a separate one from where the applications are hosted.

The management has tasked me to see how we can properly backup Maximo, related applications, database, and restore it on a completely separate test environment. The articles I found online through IBM do not appear to be talking about Maximo being hosted in a Windows and SQL environment. Are any of you able to offer any ideas or thoughts on this? Thanks.

Ritesh Ranjan's profile image
Ritesh Ranjan IBM Champion

The new separate test environment server would be also windows 2019 server? I am assuming that you will be using 2019 server.

You will need two windows 2019 server. One for Application and one for Database.

For application, Install websphere manually, setup cluster as per your requirement like having different JVM (UI, MEA, CRON, REPORT) clusters or just MXServer, since it is Test environment.

Setup queues configuration. Complete the WAS Setup. Now go inside SMP folder in prod, Update maximo.properties with tnew test db server string. Then build EAR file and deploy the same on new test application server.

For Database, Install Microsoft SQL Server 2019, then take the DB backup from Prod one and restore it on your new test server.

Change some system properties, since it is production db like smtp property, disabling integration. so it does not impact end-users.

Hope this helps.

Julio Perera's profile image
Julio Perera IBM Champion

Hi Allan:

See this IBM note regarding cloning the MAXIMO application files (not WebSphere or the DB): A limited way of cloning Maximo 7.6 

Hopefully it will save you some effort.

Also, WebSphere should be reinstalled on the new system and configured to work with Maximo as stated by Ritesh. 

The database refresh part, we typically run a script that takes care of modifying the cloned DB so it doesn't cause issues with the source DB once you duplicate it. We typically call it "post DB refresh script" and most Maximo consultants have some version of it that modifies things on the cloned DB like System Properties, Emails, Integration End Points, and potentially many other configurations depending on what is being used or desired (like Maps for Spatial, DOCLINKS locations, Company Contacts, etc.). 

Hope the above helps,

Thanks

Julio Perera