How do I initialize the Spectrum DDMdb database to start from scratch?

Document ID : KB000039317
Last Modified Date : 01/06/2018
Show Technical Document Details
Introduction:

Question:

         How do I initialize the Spectrum DDMdb database to start from scratch?

Answer: 

         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 directory

4)Enter the following command to find the current landscape handle

 

../SS-Tools/lh_set

 

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:

 

./startSS.pl

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.

Additional Information:

https://docops.ca.com/ca-spectrum/9-4-3/en/administrating/database-management/ddm-database-maintenance/database-restoration/ddm_load

 

Instructions:
Please Update This Required Field