The goal is to optimize the DDMDB on the SpectroSERVERs but the db_optimize.pl script terminates at random intervals.
The cause of this is likely an environmental in nature and likely could not be pinpointed.
The workaround to this issue is to utilize the out of the box MySQL Tools to optimize.
1. Navigate a bash shell to $SPECROOT/mysql/bin
Windows: ./mysqlcheck -uroot -proot -o ddmdb
Linux: ./mysqlcheck --defaults-file=../my-spectrum.cnf -uroot -proot -o ddmdb
This will take some time to complete depending on how large the DDMDB database is.
If you are concerned with the overall time it is taking, CA suggests utilizing our chat feature or Communities to engage a Support Engineer.