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

See: Enable Database Scheduling.