HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
Showing results for 
Search instead for 
Did you mean: 

IM 5.1 Database management

Occasional Visitor

IM 5.1 Database management

I need to know how the databse clean itself the event coming from nodes ? More specifically, does somebody know how IM database clean itself event ? Does it after a period of time ? After a maximum number of event, or per serrver ? or anything else ?

Is it configurable ?

Thanks for your help

fred Passeron
Honored Contributor

Re: IM 5.1 Database management


By default the HP SIM database keeps everything. However, one can delete events manually in the web interface and one can create tasks to perform event deletion.

The HP SIM techmical reference guide provides infos on the matter:The doc can be found here :

Page 553 of 760:Deletion of events
Page 566 of 760:Creating a task to delete all cleared events
Page 567 of 760:Creating a task to delete events older than 30 days.

To sum up, you can configure HP SIM to delete events after a certain period of time.

db maintenance : to keep a good performance of your HP SIM server.
*Export (via reports) events and delete periodically
*Delete â noisyâ events daily or weekly â Link up/down; Device Unavailable/Available; Authentication events

Hope it helps

“Life is pleasant. Death is peaceful. It's the transition that's troublesome.” Isaac Asimov
Brandon Long

Re: IM 5.1 Database management

My Sim installation had a default task to automatically delete after 90 days. I found that once I passed about 100 servers being monitored (with about 40% ilo) configured I needed to turn this on. Of course we are still using msde SQL 2000 with sim 5.1 ..