SPECTRUM Archive Manager (DDM) database is full, what can we do to get it back and running?

Document ID : KB000023386
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

SPECTRUM Archive Manager (DDM) Database is full, what can we do to get it back and running?

Environment:  

CA Spectrum

Answer: 

First, CA suggests running the db_optimize and db_maintenance scripts regularly as preventative maintenance on the DDMDB. These scripts are located in the $SPECROOT/SS/DDM directory. 

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 is located in the $SPECROOT/SS/DDM/scripts directory, this script 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 you are in a pinch and need to get your DDM back up - please 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"

 -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:

For more information on Archive Manager Database maintenance please check out the documentation at:

https://docops.ca.com/ca-spectrum/10-1/en/administrating/database-management/ddm-database-maintenance/database-maintenance-and-optimization