SPECTRUM Archive Manager (DDM) database is full, what can we do to get it back and running?
Article ID: 23386
Updated On:
Products
Issue/Introduction
SPECTRUM Archive Manager (DDM) Database is full, what can we do to get it back and running?
Environment
DX NetOps Spectrum all releases
Resolution
We recommend running the db_optimize and db_maintenance scripts regularly as preventative maintenance on the DDMDB.
The db_optimize.pl script is located in the $SPECROOT/SS/DDM/scripts directory. It provides an easy way to optimize all of the tables in the DDM database.
Optimizing tables has two major benefits:
- The speed of queries that are sent to the DDM database is increased.
- Disk space that is available from purged records is recovered.
The db_maintenance.pl script, also located in the $SPECROOT/SS/DDM/scripts directory, removes all unreferenced records from the DDM database. Unreferenced records are typically created when models are deleted. Over time, their associated records are purged, leaving some unnecessary remnants in the database.
However, on occasion the DDM may fill up due to an increase in events.
If the partition on which DDMdb resides is full, bring Archive Manager to a halt, then you need to get DDM back up by effectively deleting older records. In this case, run the third script located in the $SPECROOT/SS/DDM/scripts directory called db_purge.pl. This utility removes event records from the Archive Manager database which occurred within a user specified date range and has the following arguments:
-b: beginning date (a date, formatted YYYY-MM-DD, or or '-' to specify the earliest date in the database)
-e: ending date (as -b, except a '-' will specify the most recent date in the database)
-t: only delete event data
-q: quiet mode - do not prompt before deleting records summary information -h: print this message
Additional Information
Please reference the "TechDocs : DX NetOps Spectrum 22.2 : Database Maintenance and Optimization" section of the documentation for more information.
Feedback
