How do I Initialize the Reporting Database for Specific Landscapes?

Document ID : KB000023199
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

The document explains how to initialize the Reporting Database for Specific Landscapes, to remove all data from the reporting database and pull event data data from the Archive Manager.

 

Instructions:

Navigate to the /spectrum/bin directory and run the following script:

RpmgrInitializeLandscape

Usage:

     RpmgrInitializeLandscape <username> <password> [-skipInitialHistory] [-initHist <# of days>] [-all] [<landscape1> <landscape2> ...]

 

       -skipInitialHistory   

The Report Manager does not retrieve or store events during event processing that has occurred before the utility has run. This flag overrides -initHist <# of days> if it is also included in the command line.

     -initHist <# of days>

The Report Manager imports existing historical events from the Archive Manager, for the number of days specified.  The number should be less than or equal to the number of days worth of event data stored in the Archive Manager (the default is 45 days).  This can be verified from the "MAX_EVENT_DAYS" field in the file <$SPECROOT>/SS/DDM/.configrc

      -all

The Report Manager removes data for all landscapes in the reporting database.

       <landscape1> <landscape N > Report Manager removes data for each landscape specified.

The following sample command would remove the reporting data for all landscapes and import 50 days of events from the Archive manager.

       RpmgrInitializeLandscape.sh root root -initHist 50 -all

 

** The script runs to completion quite quickly, removing all the specified reporting data, however the Spectrum Tomcat service will need to be restarted afterwards to begin the import of events from the Archive manager.  This can take a long time, depending on the number and size of landscapes events being imported.  

 

Additional Information:

https://docops.ca.com/ca-spectrum/10-1/en/installing-and-upgrading/install-report-manager/maintenance-and-troubleshooting/reporting-database-management