SNMP Trap: Database Usage ------------------------- A trap is generated when the transaction and cache collections exceed usage thresholds. Identification * The originating IP / hostname is used to identify the system generating the traps * The NMS is responsible for associating traps with each managed system, along with clearing of alarms and escalation to the relevant system operator * The trap OID is generic for various SNMP events monitored by the |VOSS Automate| system * The SNMP system name is included as part of the variable binding to assist identification: :: .iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone Trap OID .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotifications.mteTriggerFired Severity Messages: * Info : WARN: Database transaction count returned to normal, INFO: Database transaction size returned to normal, INFO: Database cache size returned to normal * Critical : WARN: Database cache size exceeded threshold, WARN: Database transaction size exceeded threshold, WARN: Database transaction count exceeded threshold Variable Bindings - DB cache size ................................. WARN * .iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065) * snmpTrapOID = mteTriggerFired * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = 'WARN: Database cache size exceeded threshold' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = 'size: 14960011111' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 1 * .iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone INFO * .iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065) * snmpTrapOID = mteTriggerFired * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = 'INFO: Database cache size returned to normal' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = 'The cache size returned to normal' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 0 * .iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone Variable Bindings - DB transaction size ....................................... WARN * .iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065) * snmpTrapOID = mteTriggerFired * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = 'WARN: Database transaction size exceeded threshold' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = 'size: 23353681111' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 1 * .iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone INFO: * .iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065) * snmpTrapOID = mteTriggerFired * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = 'INFO: Database transaction size returned to normal' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = 'The transaction size returned to normal' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 0 * .iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone Variable Bindings - DB transaction count ........................................ WARN * .iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065) * snmpTrapOID = mteTriggerFired * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = 'WARN: Database transaction count exceeded threshold' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = 'count: 500001' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 1 * .iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone INFO * .iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065) * snmpTrapOID = mteTriggerFired * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = 'WARN: Database transaction count returned to normal' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = 'The transaction count returned to normal' * .iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 0 * .iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone .. index:: voss;voss transaction delete .. index:: voss;voss transaction archive Example: WARN: Database transaction size exceeded threshold ........................................................... :: Notification message from (1, 3, 6, 1, 6, 1, 1):('192.29.22.122', 11776): Var-binds: 1.3.6.1.2.1.1.3.0 = 27396043 1.3.6.1.6.3.1.1.4.1.0 = 1.3.6.1.2.1.88.2.0.1 1.3.6.1.2.1.88.2.1.1.0 = WARN: Database transaction size exceeded threshold 1.3.6.1.2.1.88.2.1.3.0 = size: 22574836480 1.3.6.1.2.1.88.2.1.5.0 = 1 1.3.6.1.2.1.1.5.0 = UN1-192.29.22.122 Resolution: The following commands can be used to resolve this: * **voss transaction delete [limit ]** * **voss transaction archive ** .. |VOSS Automate| replace:: VOSS Automate .. |Unified CM| replace:: Unified CM