How to check data sync period from Spectrum to CABI

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

How to check data sync period from Spectrum to CABI

Data synchronization

Environment

Release : all

Component : Spectrum Reporting

Resolution

The SRM (Spectrum Report Manager) does not update the reporting database in real-time.

This is the Report Manager Architecture:

In Spectrum 10.4.1, 10.4.2.x, 10.4.3.x (20.2.x) we enhanced the SRM update interval. 

In the prior releases, SRM was collecting and sending inventory, alarms, events, services, and NCM data at 60 minutes of the interval from DX NetOps Spectrum and was publishing the report.
From the current release (10.4.1), a new parameter instant_event_poller_processing_interval is added to let you customize the polling interval. The parameter lets the SRM process only the model create/destroy events and alarm events at five minutes of the interval. However, you can configure the polling interval. All other events are processed at 60 minutes of the interval. The configuration helps you get the updated inventory and alarms data in the report based on the configured interval rather than the regular 60 minutes time frame.

In Spectrum 21.2.x we changed the Instant Handlers. We only run Inventory (Model create/destroy) handlers, the Alarm handler is not part of the Instant Handlers. We have moved the Alarm handler back to the Historical poller (which is hourly) and only Inventory is in the Instant Handler.

In the OneClick Administration - Report Manager - Spectrum Status you can see the last time the event synchronization occurred in the reporting database. The synchronization occurs every one hour.

In the OneClick Administration - Report Manager - Archive Expert you can see the Earliest and Latest Record time in the reporting database.

If you want the SRM to update the reporting database immediately you will need to uncheck (disable) the Monitor?  checkbox, save the change, and then check back (enable) the Monitor? checkbox and save the change.

Additional Information

1. Open a bash shell on the OneClick + SRM machine

2. Navigate to the $SPECROOT/mysql/bin/ directory

3. Run the following syntax to connect to the MySQL command line:

$ ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting -A (Linux)
$ ./mysql.exe -uroot -proot reporting (Windows)

MySQL query to show the landscape sync status:

mysql> select * from landscape\G

 

Note: Syntax for Spectrum 21.2.4 onwards:

$ ./mysql --defaults-file=../my-spectrum.cnf -uroot -pMySqlR00t reporting -A (Linux)
$ ./mysql.exe -uroot -pMySqlR00t reporting (Windows)