Some useful information to consider after the alarm history data collection system is up and running includes implementing query time limits and how to stop and restart data collection:
It is possible to change the alarm history query limit values by modifying the /OperationsCenter_install_path/html/applet_params.xml file.
To change the alarm history query limit values:
Open the /OperationsCenter_install_path/html/applet_params.xml file.
In the <common> section of the file, modify any of the following parameters:
<param name="Alarm.HistoryLimitDefault" value="1000" /> <param name="Alarm.HistoryLimitMax" value="50000" /> <param name="Alarm.HistoryLimitPresets" value="500,1000,2500,5000,10000" />
In this example, the default limit is 1000, the maximum limit is 50000, and the values displayed in the submenu are 500, 1000, 2500, 5000, and 10000.
Operations Center allows database queries to run for up to 30 seconds before timing out.
To increase the query time limit, set a new SLA.WatchdogLimit value in the Formula.custom.properties file.
This property is set in milliseconds. The default value is 30000.
It is possible to manually stop and start the Data Warehouse Engine, which collects data for storage in the Service Warehouse. When the Data Warehouse Engine stops, all data collection for objects selected for data storage stops.
For example, if a system shuts down because of a problem, the Data Warehouse Engine stops collecting data for the objects selected for data storage. When the system is back up, it is necessary to use the Start Data Warehouse option to reactivate the Data Warehouse Engine and the SLM Engine.
To start or stop the Data Warehouse Engine:
In Explorer pane, right-click Data Warehouse, then select Stop Data Warehouse or Start Data Warehouse.
The property pages for the Database Warehouse element display the status of the database, database connections, and cache statistics.
To view status and statistics for the Data Warehouse:
In the Explorer pane, right-click the Data Warehouse root element, then select Properties.
The Status property page opens and displays information about Repository Status, Queue Size, and Repository Details.
To disable text wrapping for easier reading, right-click the Repository Details pane, then select Word Wrap.
In the left pane, click Data Warehouse to open its property page.
To view warehouse settings and service level settings, click the Data Warehouse, Backup Repository, System Settings, or Service Level Settings tabs.
To view caching statistics for primary keys, alarm metadata, profiles, and time series information, click the Cache Statistics page.
To disable text wrapping, right-click the Cache Statistics pane, then select Word Wrap.
The cache statistics include the following information:
Adapter Keys
Alarm CRC Hash
Alarm Meta Data
Alarm Value Types
Element Keys
Profiles
Root Cause Trees
Root Cause Reasons
Element Icons
Time Band Keys
Time Series Information
Warehouse Series Information