Maximo 7 db transfer

[webbp2]

Maximo 7. Websphere. SQL 2005

I have a Maximo 7 MAM runnning in a Dev environment. I also have a database
backup from a Production system from elsewhere. (Both on same release level)

As the majority of Maximo's properties are now held in the database, is there
anyway of restoring the PROD version into the DEV environment, then changing the
relevant properties so that Maximo will run?

There are a few perameters in the Maximo.Properties file that would need
changing (then re-encrypting) but what properties in the database would need
changing?

Thank you in advance

Regards

Paul

[amdisuk]

I'm no expert on Maximo 7 but we used to use a tool that allowed you to visually move records from one database to another. There aren't too many tables that converting but it is a time consuming job.

[mxes_installer]

Hi webbp2,

I have not so much experience with DB2, but we have the same problem with oracle like you. And we solved the problem.

We have only one parameter in the maximo.properties. The database value with port and owner. We checked / change this value to the right one and before we start the application we have change some parameters with a sql tool in the database. Search in the table MAXPROPVALUE after your old database ip and make a update.

mxes_installer

[srihari.varadarajan]

Even I am new to Maximo but my understanding is that we can use migration manager application of 7.1 for your requirement. The docs required to understand migration manager are available in IBM site. I

Does this answer your question?

[Ethen]

do u want to run prod and dev from same database instance or u want to copy prod database dump into dev (or dev to prod ) and run prod and dev with two  diff database instances..

[Razor007]

I guess the guy had already figured out, it is a very old post... But if some one is looking for some thing similar -  there is a post on maximokb.com and on IBM it is http://www-01.ibm.com/support/docview.wss?rs=3503&context=SS6HJK&dc=DB560&dc=DB520&uid=swg21382026&loc=en_US&cs=UTF-8&lang=en&rss=ct3503tivoli

[sckl]

we're using following sql command after transferring the productive environment into the test environment (sample)

update maxpropvalue set propvalue = 'http://maximourl/meaweb' where propname = 'mxe.int.webappurl';
update maxpropvalue set propvalue = 'InstanceName' where propname = 'Database.Oracle.InstanceName';
update maxpropvalue set propvalue = 'FQDN hostname' where propname = 'mxe.hostname';
update maxpropvalue set propvalue = 'FQDN hostname' where propname = 'WAS.DeploymentManagerHostName';
update maxpropvalue set propvalue = 'FQDN hostname' where propname = 'WAS.WebServerHostName';
update maxpropvalue set propvalue = 'FQDN hostname' where propname = 'Database.Oracle.ServerHostName';
update maxpropvalue set propvalue = 'jdbc:oracle:thin:@FQDN hostname:1521:InstanceName' where propname = 'mxe.db.url';
commit;

may it helps you

[webbp2]

Dear All,

Thanks for the replies.

After some investigation I found the following.
Using seperate Maximo instances on their own VM Machines, using the same Port numbers, passwords etc.

Properties that would require changing would be:-

From maxpropvalue.propname


Database.SQL.DatabaseName
Database.SQL.ServerHostName
mxe.adminmode.logoutmin
mxe.db.url
mxe.doclink.path01
WAS.DeploymentManagerHostName
WAS.WebServerHostName

Although we have also found you can do a straight backup and restore from one SQL db to another as long as you do not rebuild the EAR files!

[KiranK]

This is summed up pretty much well here.

https://www-304.ibm.com/support/docview.wss?uid=swg21392272

[Yesterday]

• Urgent requirement for Ma... by ravikorukonda [Yesterday at 04:26:29 pm]
• Tivoli Directory Integrat... by Eddie Hartman [Yesterday at 12:54:14 pm]
• Implementation by Aparna [Yesterday at 11:24:41 am]
• How to get list data whic... by Dileep Kumar [Yesterday at 05:47:49 am]
• How to change an email ad... by kvnaresh [February 08, 2012, 12:25:57 am]
• Difference between fixpac... by jithu1989 [February 07, 2012, 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]