Hi,
NPM TrapVarBinds table in my NPM hits 32 GB size.
Please, how could I remove all data from this table ?
I don´t want delete this table, only your data.
In my environment we need SNMPtraps enabled.
thanks.
Use a truncate table function on your database manager:
truncate table trapvarbinds
Without the trapvarbinds data, all snmp events will have no data.
They don't convert the trap to text and store it in one string, they store it in the way one should for a relational database by using indexes and multiple tables. If you truncate the varbinds, you should truncate the main trap table.
Check out this and this. You should setup some drops for unneeded traps, something is probably being very verbose and you don't need all the traps it is sending. This one is about syslogs, but the principles byrona talked about apply to rules for traps too.
