This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

trapvarbinds table

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.