How do I initialize the Spectrum DDMdb database to start from scratch?
If you are trying to re-initialize the Spectrum DDM and start from fresh DDMdb tables, follow the steps.
1)Log into the SpectroSERVER system as the user that owns the Spectrum install.
2)On Windows, start a bash shell by running “bash –login”
3)cd to the $SPECROOT/SS-Tools directory
4)Enter the following command to find the current landscape handle
5)cd to the $SPECROOT/bin directory
6)Enter the following command to shut down the Archive Manager where <HOST> is the hostname of the SpectroSERVER system:
./cmdC <HOST> 2 ARCHMGR
7)cd to the $SPECROOT/SS/DDM directory and enter the following command to re-initialize the DDM database where <LH> is the landscape handle noted in step 4 above:
../ddm_load –i <LH>
8)Enter “y” when prompted “Are you sure you want to initialize the DDM Database [y/n]?”
9)cd to the $SPECROOT/bin directory
10)Enter the following command to start the Archive Manager:
NOTE: The above “startSS.pl” command will start both the SpectroSERVER and Archive Manager. The script checks to see if either is running. If already running, it will not start another.