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', 10860):
Var-binds:
1.3.6.1.2.1.1.3.0 = 16127943
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: CACHE_DATABASE_MAINTENANCE-VOSS-UN-1, Code: -1, Occurences: 27, Latest Occurence: 2019-08-23T10:06:27.821Z
1.3.6.1.2.1.88.2.1.5.0 = 1
1.3.6.1.2.1.1.5.0 = VOSS-UN-1
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
