How to initialize the DDMdb when the event table is corrupted

Document ID : KB000031996
Last Modified Date : 29/04/2019
Show Technical Document Details
Introduction:

How to initialize the Archive Manager (DDM) database when the event table is corrupted and cannot be repaired

 

Instructions:

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

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

3. Stop the MySQL Server:
    a. cd to the $SPECROOT/bin directory
    b. Enter the following command where <HOSTNAME> is the hostname of the SpectroSERVER system:

./cmdC <HOSTNAME> 2 MYSQL

4. cd to the $SPECROOT/mysql/data/ddmdb directory and remove the event.MYI and event.MYD files and replace them with 0 size files. Be sure to use exactly the same filenames. 

5. Start MySQL database server: 
    a. cd to the $SPECROOT/bin directory
    b. Enter the following command where <HOSTNAME> is the hostname of the SpectroSERVER system:

./launchinstdbapp <HOSTNAME> MYSQL y MYSQL.OUT 

6. Repair the talbe
    a. cd to the $SPECROOT/mysql/bin directory
    b. Enter the following command to log into mysql:


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

    c. Enter the following command at the mysql prompt:

repair table event USE_FRM; 

    d. Enter "exit" at the mysql prompt to exist mysql

7. Reinitialize the DDM database:
    a. cd to the $SPECROOT/SS/DDM directory
    b. Enter the following command where <LH> is the landscape handle of the SpectroSERVER database:

./ddm_load -i <LH>

8. Start the Archive Manager