Transferring Spectrum Report Manager (SRM) database from one host to another host
As hardware updates become available, there may be times you need to move your software products from an older system to a newer one.
In order to move the database a few items need to remain the same and disk space will be needed:
To backup the database:
This may take a while to complete based on the size of the database and system resources available. It is recommended the system do nothing else but the dump until it completes.
Once this completes you will have a file named <dump_log> (This is whatever you want to call it). This can be zipped up to make the transfer to the new system quicker, as it is just all text inside the file.
Once this file is copied to the new system with the exact version of Spectrum the old system had on it (including Spectrum patches), move it to the $SPECROOT/mysql/bin directory to make things easy.
Once there, follow these steps:
This will take time according to how much data you have since we are effectively rebuilding the entire database row by row. As above, it is recommended this system does nothing else but the import.
While on this topic, CA also recommends the following:
Anytime the Spectrum modeling database (SSdb) is backed up, the Archive Manager database (DDMDB) and Reporting databases should also be backed up to maintain the three databases synchronization. If an SSdb is reloaded, the other two databases should also be reloaded. This is not always possible because the reporting database takes up so much space, however it is recommended. If the SSdb is reloaded but the others are not you will have an SSdb that does not have certain data the Reporting database may have, like an outage or a newly created model. If you have any follow up questions regarding this process, please call CA Support.
A review should be done to see if the above migration process is the best thing for your business needs. For example, if you only leave 30 days worth of data in Spectrum Report Manager but leave 45 days worth in your Archive Manager DDMDB - moving the database is not recommended since Report Manager can process those 30 days from the DDM. Only if you keep more data than stored in the DDMDB's should you follow the above migration process.
If you do not copy the database over and want to setup Report Manager to process data from a migrated DDMDB follow this process on the SRM host:
This will remove all SRM data currently existing in the SRM database and start processing new data from the DDMDBs.
Any questions on this knowledge article please contact CA Support.