SNMP Trap: Database Maintenance¶
A trap is generated when the database maintenance schedules are not set up.
Severity Messages:
ERROR: Database maintenance not scheduled
Example hourly notifications generated by the data/Alert instance in the Database
Notification message from (1, 3, 6, 1, 6, 1, 1):('10.120.1.203', 60578):
Var-binds:
1.3.6.1.2.1.1.3.0 = 16128700
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 = Database Maintenance
1.3.6.1.2.1.88.2.1.3.0 = ID: TRANSACTION_DATABASE_MAINTENANCE-VOSS-UN-1, Code: -1, Occurences: 27, Latest Occurence: 2019-08-23T10:06:35.405Z
1.3.6.1.2.1.88.2.1.5.0 = 1
1.3.6.1.2.1.1.5.0 = VOSS-UN-1
Example warnings raised once through platform monitoring
TRANSACTION DATABASE MAINTENANCE NOT SCHEDULED
Notification message from (1, 3, 6, 1, 6, 1, 1):('10.120.1.203', 5194):
Var-binds:
1.3.6.1.2.1.1.3.0 = 16128774
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 = ERROR: Database maintenance not scheduled
1.3.6.1.2.1.88.2.1.3.0 = TRANSACTION DATABASE MAINTENANCE NOT SCHEDULED - SETUP SCHEDULE FOR REGULAR MAINTENANCE
1.3.6.1.2.1.88.2.1.5.0 = 1
1.3.6.1.2.1.1.5.0 = VOSS-UN-1
Resolution
Create schedule and time:
With for example a schedule name dbtxn:
schedule add dbtxn voss transaction archive or schedule add dbtxn voss transaction delete
schedule time dbtxn weekly 0