DX NetOps

 View Only
  • 1.  Tech Tip: Correct Usage of RpmgrInitializeLandscape command

    Posted Jan 15, 2015 06:15 AM

    Description:


    Correct Usage of RpmgrInitializeLandscape command explaining how command is working and correct usage of arguments along with explanation of interaction between Archive Manager database and SRM.

     

    Solution:


    This document is valid for all versions of Spectrum from 8.1 up to current version at time of writing 9.2 H02.

     

    When using this command it is always necessary to stop Spectrum Report Manager (SRM) first.

     

    This is in order to prevent db contention which though seen less in versions of Spectrum 9.0 and later was more prevalent in versions 7.1 & 8.1 of Spectrum which were using an earlier version of MySQL.

     

    Once SRM is stopped it is used with the following syntax:

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

    To better explain how this is working here is an example:

    ./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 and all data removed from it 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 this argument is not used it will clear all data and attempt to import 1 day's worth of past events from ddmdb.

      In order to complete the process and ensure the data is imported back it is then required to restart SRM.


  • 2.  Re: Tech Tip: Correct Usage of RpmgrInitializeLandscape command

    Broadcom Employee
    Posted Jan 15, 2015 07:11 AM

    Hi Declan, good description ... allow me to add some notes:

     

    - CA Spectrum Processd service needs to run - as this controls the localhost "Spectrum mysql service" too. The mysql-service is required to be active when running the RpmgrInitializeLandscape tool.

    - Once the RpmgrInitializeLandscape was done - and had finished - the localhost "Spectrum OneClick-server" could be started(restarted) again.

    - When using the -initHist parameter covering high number of history days - AND - the SpectroSERVER/Landscape ArchiveManager holds very high number of event data for that range - this could cause a processing workload for the OneClick-Server. At this point the user should NOT recycle the OneClick-Server as they may not see "current reporting data". Please wait (at least for one night) to allow Spectrum OneClick(+SRM)-Server to retrieve all newly requested historical data.

    - using the OneClick-Server weblogon / Administration / Report Manager pages - especially the ArchiveExpert and the Spectrum Status will help to see if OC/SRM-sync to the Landscape is running - and/or - completed. 



  • 3.  Re: Tech Tip: Correct Usage of RpmgrInitializeLandscape command

    Posted Jan 15, 2015 07:44 AM

    Few more on the process:

     

    Reinitializing Reporting Database:

     

    1.  Stop Tomcat (service stop) on Oneclick server

    2.  Keep MYSQL running

    3.  Go to  bash -login -> $SPECROOT/bin ->

     

    ./RpMgrInitializeLandscape.bat root root  -initHist 45 –all

       RpmgrInitializeLandscape

      Usage:

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

     

    Kalyan



  • 4.  Re: Tech Tip: Correct Usage of RpmgrInitializeLandscape command

    Posted Jul 07, 2017 02:14 PM

    Thanks!
    I restart a SS poller and now the events, outages, are missing in srmdbapi, is it posible just RpmgrInitializeLandscape a single landscape without broke anything
    thanks

    diego    



  • 5.  Re: Tech Tip: Correct Usage of RpmgrInitializeLandscape command

    Posted Jul 10, 2017 05:24 AM

    Hello Diego,

    You can specify RpmgrInitializeLandscape per landscape(s):

     

    Usage:

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

     

    Regards

     

    Declan