How to re-initialize the SpectroSERVER database to start from scratch with no models
book
Article ID: 102875
calendar_today
Updated On:
Products
CA Spectrum
Issue/Introduction
How to re-initialize the SpectroSERVER database to start from scratch with no models
Environment
Release: Spectrum 10.2 and greater Component: SPCCSS
Cause
In previous database versions, the $SPECROOT/SS/legacy.SSdb database was a catalog only database that contained no models.
Starting in Spectrum 10.2, the legacy database contains the models at the time of the last upgrade.
Resolution
To re-initialize the SpectroSERVER database to start from scratch with no models:
1. Log into the SpectroSERVER system as the user that owns the Spectrum installation
2. Shutdown the SpectroSERVER process
3. If on Windows, start a bash shell by running "bash -login"
4. cd to the $SPECROOT/SS directory and enter the following command:
../SS-Tools/SSdbload -ic legacy.SSdb
NOTE: The "-ic" tells the SSdblaod command to initialize to the catalog only.
After re-initializing the SpectroSERVER database, you will need to re-initialize the Archive Manager (DDM) database. To re-initialize the DDM database:
1. Log into the SpectroSERVER system as the user that owns the Spectrum installation
2. Shutdown the Archive Manager process
3. If on Windows, start a bash shell by running "bash -login"
5. cd to the $SPECROOT/SS/DDM directory and enter the following command where <LH> is the landscape handle for this Spectrum installation:
a. If on Spectrum 10.2.3 or below and reply "y" when prompted:
./ddm_load -i <LH>
b. If on Spectrum 10.3 or greater and reply "y" when prompted:
./ddm_load.pl -i -l <LH>
Additional Information
Please reference the "SSdbload" section of the documentation for more information.
After running the SSdbload command to re-initialize the SpectroSERVER database from scratch with no models, you can also use the "lh_set" command to change the landscape handle by doing the following before starting the SpectroSERVER process:
1. Log into the SpectroSERVER system as the user that owns the Spectrum installation
2. If on Windows, start a bash shell by running "bash -login"
3. cd to the $SPECROOT/SS directory and enter the following command where <LH> is the new landscape handle:
../SS-Tools/lh_set <LH>
4. Then, re-initialize the DDM using the same LH.
NOTE: if using legacy landscape handles, the LH must be in multiples of 4. If using huge landscape handles, the LH must be in multiples of 64.