Network Management / (OpenView-NNM) Practitioners Forum
cancel

Remove all events from NNMi

SOLVED
Go to solution
kimo
Absent Member.

Remove all events from NNMi

Hi,

I've NNMi 9.0 over linux redhat, i noticed that i have an alarm regarding NNM health with severity Major.

The alarms is "Number of snmp traps persisted in the database approaching the maximum allowed limit. Currently, only snmp traps utilized within Causal Engine analysis will be accepted by the event system, while all other snmp traps will be dropped."

i selected some events and choosed "Delete" however it takes ages to process them from the GUI, is there a way to remove all events from the DB from the command prompt, or to remove alarms older than one month for example?

Thanks in advance.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
AlexanderH
Absent Member.
Solution

Re: Remove all events from NNMi

Hi,

does nnmtrimincidents.ovpl perhaps do the work?
You may use the cmd to delete incidents e. g. depending on their age.

From the manual:
[QUOTE]
nnmtrimincidents.ovpl is used to delete incidents from the incident table.
-age age
Specifies the age of incidents to trim. You should use this option in conjunction with the incr option.
If specified, the value for age must be greater than 0.
-incr increment
Specifies the increment for age option. Supported increments include days, weeks, and months.
-date date
Specifies the date from which older incidents are trimmed.
[/QUOTE]

HTH Alexander
6 REPLIES
dharm123
Absent Member.

Re: Remove all events from NNMi

Hi Kimo,

Do you want to delete all snmp traps at one go?

Regards,
Dharmesh Shah.
kimo
Absent Member.

Re: Remove all events from NNMi

Hi,

yes that's what I need to do

Thanks
Highlighted
AlexanderH
Absent Member.
Solution

Re: Remove all events from NNMi

Hi,

does nnmtrimincidents.ovpl perhaps do the work?
You may use the cmd to delete incidents e. g. depending on their age.

From the manual:
[QUOTE]
nnmtrimincidents.ovpl is used to delete incidents from the incident table.
-age age
Specifies the age of incidents to trim. You should use this option in conjunction with the incr option.
If specified, the value for age must be greater than 0.
-incr increment
Specifies the increment for age option. Supported increments include days, weeks, and months.
-date date
Specifies the date from which older incidents are trimmed.
[/QUOTE]

HTH Alexander
ARUNPRAKASH
Absent Member.

Re: Remove all events from NNMi

Dear kimo,
Use nnmtrimincidents.ovpl for deleting or you can archive it into somewhere.

No need to delete incidents and all. Just use nnmtrapdump.ovpl for trap configuration.


Cheers..!
kimo
Absent Member.

Re: Remove all events from NNMi

Thanks a lot AlexanderH and ARUNPRAKASH

This worked fine and i got the below:

[root@nnm bin]# nnmtrimincidents.ovpl -age 2 -incr days -path "\kareem\saveIncidents.gz"
Number of incidents selected for operation: 23,092.
Reference date from which older incidents will be selected for operation: 5/16/11 3:12 PM.
Percentage of the database selected for operation: 22.69%.
Do you wish to continue (y/n)?
y
Archiving selected incidents...
Number of incidents archived: 23,149. Archive file: \kareem\saveIncidents.gz.
Trimming selected incidents...
Number of incidents successfully trimmed: 1,000.
Number of incidents successfully trimmed: 1,000.
Number of incidents successfully trimmed: 1,000.
Number of incidents successfully trimmed: 553.
Number of incidents successfully trimmed: 10.
Done


Thanks a lot for your Help
kimo
Absent Member.

Re: Remove all events from NNMi

Closed.