topic Re: HP SIM database extension in Server Management - Systems Insight Manager

HP SIM database extension

Kim Tran_4 — Mon, 05 Nov 2007 17:19:14 GMT

I would like to create a table in HP SIM database. Please help me with a step by step process, or pointers to any HP SIM related documents. Thanks

Re: HP SIM database extension

Rob Buxton — Tue, 06 Nov 2007 15:56:49 GMT

You don't typically add tables to the HPSIM Database.
What are you trying to do?

Re: HP SIM database extension

fred Passeron — Wed, 07 Nov 2007 04:47:40 GMT

Hi

You are on your way to loose support for HP SIM by adding tables to the DB. If anything goes wrong, you won't be able to call support on this...

within the user guide of HP SIM 5.1, one can find the db SCHEMA : http://h10018.www1.hp.com/wwsolutions/misc/hpsim-helpfiles/hpsim_userguide_51.pdf

In chapter 17, reference information / Database tables.

Unfortunately there is no step by step description of the process since it is an unsupported one.

hope it helps

fred

Re: HP SIM database extension

Kim Tran_4 — Wed, 07 Nov 2007 12:02:21 GMT

Thank you for all the help. I hope that this feature will be supported in the near future

Re: HP SIM database extension

David Claypool — Wed, 07 Nov 2007 12:22:45 GMT

Kim:

We only recommend opening the HP SIM database in Read-Only fashion. Any mucking about in the data can cause severe problems and really confuse HP SIM.

You can do what you want by creating your own database and then open the HP SIM database read only so you can use data from it and its keys for things you need to reference in your database. Fred already has provided info about where the HP SIM schema is published.