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
Summary:
This technical document will walk you step by step through initializing the Report Manager database for CA Spectrum.
Background:
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.
Environment:
CA Spectrum 9.x, 10.x
Instructions:
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.
- skipInitialHistory - If used Report Manager does not retrieve or store events during event processing that have occurred before the utility is run. This flag overrides -initHist <# of days> if it is also included in the command line.
- initHist - After the database is initialized, SRM then imports events from the Archive Manager database (ddmdb) up to the number of days specified with ? initHist in this case 50 days.
Please Note: It can only import events from the landscape that still exist in the ddmdb.
So if there are only 45 days of data in the ddmdb then only 45 days can be imported not 50 as specified above-45 days being the default retention period for the Archive Manager database set in the $SPECROOT/SS/DDM/.configrc file. - initHist - If no number of days is specified SRM will clear all data and attempt to import 1 days’ worth of past events from ddmdb.
- all – Instead of specifying the SpectroSERVER(s) host name the –all option can be used to include all SpectroSERVER landscapes in this command.
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.
Additional Information:
For more information on Report Manager Database management please see the documentation at:
https://docops.ca.com/ca-spectrum/10-1/en/installing-and-upgrading/install-report-manager/maintenance-and-troubleshooting/reporting-database-management