How to accelerate initializing the Spectrum Reporting database (SRMdb)?

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

The $SPECROOT/bin/RpmgrInitializeLandscape.bat utility can be used to reinitialize (remove all data) for one or more or all landscapes from the reporting database. But the large size of SRMdb may limit the hard disk free space, so running this utility may fail or take a long time. The solution shows how to accelerate the process by replacing SRMdb data files with 0 size files.

Environment

DX NetOps Spectrum all Releases

Resolution

Normally, data files that are large or the largest in the SRM db are the event.MYI and event.MYD files. In this case, to accelerate the SRMdb reinitializing process, you can replace the data files with 0 size files and repair the database.

To accelerate the SRMdb reinitializing process

1. Stop OneClick server and MySQL database server:
   
   To stop OneClick server on Solaris/Linux, run the script: $SPECROOT/tomcat/bin/stopTomcat.sh
   
   On Windows, stop SpectrumTomcat service from Windows Services panel.
   
   To stop MySQL database server, run the following $SPECROOT/bin/cmdC command on bash shell:
   
   ./cmdC <HOSTNAME> 2 MYSQL
   
   Note : If OneClick server is running on the same computer with SpectroSERVER, shutting down MySQL database server will shutdown Archive Manager.
   
   
2. Remove the event.MYI and event.MYD files and replace them with 0 size files with the same names and extension. Be sure to use exactly the same filenames.
   
   
3. Start MySQL database server:
   
   To start MySQL database server, run the $SPECROOT/bin/launchinstdbapp command on bash shell.
   
   ./launchinstdbapp <hostname> MYSQL y MYSQL.OUT
   
   
4. Log in to MySQL and repair the event table:
   
   cd $SPECROOT/mysql/bin
./mysql -uroot -proot reporting
   
   At the mysql prompt, run the following: repair table event USE_FRM;
   
   
5. Run $SPECROOT/bin/RpmgrInitializeLandscape.bat to reinitialize SRMdb. For example:
   
   cd $SPECROOT/bin/
./RpmgrInitializeLandscape.bat root root -initHist 45 -all

6. Restart the OneClick server when finished