Spectrum db_optimize script terminates

Products

• CA Spectrum

Issue/Introduction

Spectrum db_optimize script terminates

Environment

Release: Any
Component: SPCAEM

Cause

The cause of this is likely environmental in nature and likely could not be pinpointed.

Resolution

The workaround to this issue is to utilize the out of the box MySQL Tools to optimize.

1. Log into the SpectroSERVER system as the user that owns the Spectrum installation

2. If running Windows, start a bash shell by running "bash -login"

3. cd to the $SPECROOT/mysql/bin directory and enter the following command:

./mysqlcheck --defaults-file=../my-spectrum.cnf -uroot -proot -o ddmdb

This may take some time to complete depending on the size of the Archive Manager (ddmdb) database.

Additional Information

Please reference the "DDM Database Maintenance" section of the documentation for more information.