HP SIM 5.01 - Move Remote Database and Reconfigure

[Bob Banister]

I am unable to find any documentation on how to reconfig SIM to see a remote database after it has been moved to another server. Can you point me in the right direction?
Also, is there a set way to move the database besides backing up the files and restoring them to the new server?
Thanks,
Bob

[Rob Buxton]

ftp://ftp.compaq.com/pub/products/servers/management/hpsim/hpsim-52-migratingNewSystem.pdf

Might provide the guidelines.
For documentation on HPSIM, go to www.hp.com/go/hpsim and follow the link to the reference library.

How you copy a database depends more on the database than it does HPSIM. You'd need to look at the tools for the database being used.

[Scott Massari]

I am in the same boat. Can't find ANY proper documentation. I have SIM installed on a Windows CMS with an Oracle remote database. The database must be moved but it seems there is no documentation on how to reconfig the CMS.

[Ervinck Kevin]

I know how to do this in SQL Server, not sure about Oracle but it must be almost the same.

this is the procedure for SQL server:
1) Stop HPSIM
2) Detach your database
3) copy it to the new server
4) attach the database on the new server


5) check the database.props file, you can find it in:

C:\Program Files\HP\Systems Insight Manager\config\

Look at the following parameters and change them depending on the server/instance name. This file might be slightly different for Oracle, certainly the port number will be different.

hp.Database.databaseName=Insight_v50_0_15629608
hp.Database.dsn=Insight_v50_0
hp.Database.hostName=HPSIM
hp.Database.instance=HPSIM\\
hp.Database.jdbcDriver=net.sourceforge.jtds.jdbc.Driver
hp.Database.jdbcUrlPrefix=jdbc\:jtds\:sqlserver
hp.Database.portNumber=1433


6) Start HPSIM again.

[Aelus]

I try the same, but my SIM don't want to start any more. I also changed the ODBC-Connection - but without success.

I've also read the hpsim_5_migrationNewSystem.pdf, but therein I cannot find my solution.

Any suggestions?

[Bob Banister]

See thread for helpful hints

[wassim krouna_1]

I think that this link is able a give you help

http://www.hp.com/wwsolutions/misc/hpsim-helpfiles/mxhelp/mxportal/en/admin_ref_dbBackup_windows.html

Regards,