Tech Tip: How to initialize the Spectrum Report Manager (SRM) database.
CA Spectrum Tech Tip by Bill Wolforth, Senior Support Engineer for 9/21/2016
How to initialize the Spectrum Report Manager (SRM) database
This technical document will walk you step by step through initializing the Report Manager database for CA Spectrum.
If the disk that Report Manager is installed on runs out of disk space and no further disk space can be added to allow an optimization of the database, it may be necessary to initialize the Report Manager database.
CA Spectrum 9.x, 10.x
The command to initialize the Report Manager database is RpmgrInitializeLandscape and it can be found in the $SPECROOT/bin directory on the OneClick/Report Manager server. The syntax for the command is as follows:
RpmgrInitializeLandscape <username> <password> [-skipInitialHistory] [-initHist <# of days>] [-all] [<landscape1> <landscape2> ...]
To better explain how this is working here is an example using root as <username> and <password>:
./RpmgrInitializeLandscape.sh root root -initHist 50 as00901 as00910
Once initiated this command will do the following:
First the database is initialized with all data removed for specified landscapes (in above example as00901 and as00910). No data is retained in the landscape at all.
Lastly, the steps to run the Report Manager initialize is as follows:
Stop the Spectrum Tomcat process.
(This will stop collection and prevent writing to the report manager database while it is being initialized)
Please change directory to $SPECROOT/bin
(The $SPECROOT/bin is the home of the RpmgrInitializeLandscape command)
Then run: RpmgrInitializeLandscape root root –initHist 45 –all
(This will initialize the Report Manager database. And pull back 45 days of data (ddmdb default) from the Archive Manager (ddm) database on all of the SpectroSERVER landscapes.
Once it completes please restart the Spectrum Tomcat process.
(This will restart the collection process for Report Manager)
The collection process will take some time depending on how much data is in the Archive Manager database. You can monitor the most recent event time collected by going here:
OneClick Administration Page -> Administration -> Report Manager -> Spectrum Status
When the last event record time is within an hour of the current time, then event collection has caught up.
For more information on Report Manager Database management please see the documentation at: