Spectrum db_optimize script terminates

book

Article ID: 111056

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

Spectrum db_optimize script terminates

Cause

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

Environment

Release: Any
Component: SPCAEM

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.