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

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.

Environment

Release: Spectrum 10.2 and greater
Component: SPCCSS

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.