Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

HP SIM 5.01 - Move Remote Database and Reconfigure

Bob Banister
Occasional Advisor

HP SIM 5.01 - Move Remote Database and Reconfigure

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
6 REPLIES
Rob Buxton
Honored Contributor

Re: HP SIM 5.01 - Move Remote Database and Reconfigure

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.

Re: HP SIM 5.01 - Move Remote Database and Reconfigure

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
Valued Contributor

Re: HP SIM 5.01 - Move Remote Database and Reconfigure

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
Advisor

Re: HP SIM 5.01 - Move Remote Database and Reconfigure

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
Occasional Advisor

Re: HP SIM 5.01 - Move Remote Database and Reconfigure

See thread for helpful hints
wassim krouna_1
Occasional Advisor

Re: HP SIM 5.01 - Move Remote Database and Reconfigure