Configuring Monitoring
You can configure the monitoring Model Repository Service at the domain level. After you configure the Monitoring Configuration parameters, the Monitor tab displays the statistics and reports about the objects in the domain. Statistics and reports appear in the History view on the Manage tab and in the Summary Statistics and Execution Statistics views on the Monitor tab.
The monitoring Model Repository Service stores statistics and reports for the Data Integration Service jobs. The statistics include historical information about objects that the multiple Data Integration Services run. The reports show key metrics about integration objects.
If you do not configure monitoring, then some views on the Manage and Monitor tabs do not have content. The workflow graph is also empty, and notifications disappear when you refresh the page.
To view monitoring statistics and reports, perform the following tasks:
- 1. Configure monitoring settings. Configure a Model repository as a monitoring Model repository to store run-time statistics for objects that the multiple Data Integration Services runs.
- 2. Configure reports and statistics views. Choose which statistics appear in the Statistics and Reports views.
Note: In a domain that uses Kerberos authentication, users must have the Administrator role for the monitoring Model Repository Service that stores statistics. If users do not have Administrator role, some statistics might not appear.
Step 1. Configure Monitoring Settings
Configure monitoring settings for the domain when you want to view historical information about the domain. When you configure monitoring settings, you specify a Model repository as the monitoring Model repository to store run-time statistics for Data Integration Service jobs.
Create the monitoring Model repository content before you configure the monitoring settings. If you create the content after you configure the monitoring settings, you must recycle the monitoring Model Repository Service after the content is created.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the domain.
3. In the Domain section, click the Monitoring Configuration view.
The current monitoring configuration appears.
4. Click Edit to change the monitoring configuration.
5. Edit the following options:
Option | Description |
|---|
Model Repository Service | Name of the Model repository that stores the historical information. The Model repository must not be integrated with a version control system. |
Username | User name to access the Model Repository Service. Does not appear in domains that use Kerberos authentication. |
Password | Password of the user name to access the Model Repository Service. Does not appear in domains that use Kerberos authentication. |
Modify Password | Modify the Model Repository Service password. |
Security Domain | Name of the security domain that the Model repository user belongs to. |
Preserve Summary Historical Data | Number of days that the Model repository saves averaged data. If purging is disabled, then the Model repository saves the data indefinitely. Default is 180. Minimum is 0. Maximum is 366. |
Preserve Detailed Historical Data | Number of days that the Model repository saves per-minute data. If purging is disabled, then the Model repository saves the data indefinitely. Default is 14. Minimum is 1. Maximum is 14. |
Purge Statistics Every | Interval, in days, at which the Model Repository Service purges data that is older than the values configured in the Preserve Historical Data option. Default is 1 day. |
Days At | Time of day when the Model Repository Service purges statistics. Default is 1:00 a.m. |
Maximum Number of Sortable Records | Maximum number of records that can be sorted in the Monitor tab. If the number of records on the Monitor tab is greater than this value, then you can only sort by Start Time and End Time. Default is 3,000. |
Maximum Delay for Update Notifications | Maximum time, in seconds, that the Data Integration Service buffers statistics before it stores them in the Model repository and displays them in the Monitor tab. If the Data Integration Service shuts down unexpectedly before it stores the statistics in the Model repository, then the statistics are lost. Default is 10. |
Show Milliseconds in Date Time Field | Include milliseconds for date and time fields in the Monitor tab. |
6. Click OK.
To apply the settings, you must restart all of the Data Integration Services.
Step 2. Configure Reports and Statistics Views
By default, the Statistics and Reports views on the Execution Statistics view are empty. To view statistics and reports, you must configure the Report and Statistic settings in the domain. These settings apply to all Data Integration Services in the domain.
Before you configure statistics and reports, you must specify a monitoring Model Repository Service in the Monitoring Configuration tab and enable the monitoring Model Repository Service.
1. In the Administrator tool, click the Monitor > Execution Statistics tab.
2. Click Actions > Report and Statistic Settings.
3. In the Report and Statistic Settings dialog box, click the Statistics tab.
4. Configure the time ranges that you want to use for statistics, and select the frequency at which the statistics assigned to each time range should be updated.
5. In the Default Time Range list, select a default time range to appear for all statistics.
6. Click the Reports tab.
7. Enable the time ranges that you want to use for reports, and select the frequency at which the reports assigned to each time range should be updated.
8. In the Default Time Range list, select a default time range to appear for all reports.
9. Click Select Reports.
10. In the Select Reports dialog box, add the reports that you want to run to the Selected Reports box.
11. Organize the reports in the order in which you want to view them on the Monitor tab.
12. Click OK to close the Select Reports dialog box.
13. Click OK in the Report and Statistic Settings dialog box.