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

book

Article ID: 39317

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction



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

Environment

Release:
Component:

Resolution

Use the following steps to initialize the Spectrum DDM database to start from scratch



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 and note the 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. Bring up mysql prompt by running:


cd $SPECROOT/MySql/bin
mysql --defaults-file=../my-spectrum.cnf -uroot -proot


8. At the mysql prompt, run commands to DROP and CREATE the ddmdb database:


drop database ddmdb;

create database ddmdb;

exit




9. 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

Please reference the  section of the documentation for more information.

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4/administrating/database-management/ddm-database-maintenance/database-restoration/ddm-load.html