Modify When Rollup Processing and Baseline Calculations Are Performed

Using Data-Driven Web Services › Modify When Rollup Processing and Baseline Calculations Are Performed

Modify When Rollup Processing and Baseline Calculations Are Performed

Administrators can modify when rollup processing and baseline calculations are performed. Changing the time when these operations run allows administrators to schedule these Vertica-intensive operations to occur during off-hours. When these operations occur during off-hours, users who generate reports will not be impacted during business hours.

By default, rollup processing and baseline calculations are run at the bottom of the hour, every hour of the day.

Follow these steps:

Enter the following URL in a web browser:
http://hostname:port/rest/rollups/config

hostname:port

Specifies the Data Aggregator host name and the port number.

Default port: 8581
Take note of the ID that is assigned to the configuration item.
Open a REST client editor or HTTP tool that sends requests and gets responses. Enter the following criteria:
- URL: http://hostname:port/rest/rollups/config/ID
  
  hostname:port
  
  Specifies the Data Aggregator host name and the port number.
  
  Default port: 8581
  
  ID
  
  Is a unique identification number that is assigned to the configuration item. You noted this number in the previous step.
- HTTP method: PUT
- Enter the hour of the day when you want rollup processing to begin and end in the Body tab of the HTTP Request pane.
By default, the following results are returned:
```
<RollupsConfigurationList>
```
```
 <RollupsConfiguration version="1.0.0">
	  <ID>8</ID>
	  <StartHour>0</StartHour>
	  <EndHour>23</EndHour>
 </RollupsConfiguration>
```
```
</RollupsConfigurationList>
```
StartHour

Defines the hour of the day (in your local timezone) in 24-hour time format when rollup processing will begin.

EndHour

Defines the hour of the day (in your local timezone) in 24-hour time format when rollup processing should end. No new rollups will be kicked off after the end-hour, but any rollups that are in-progress will be allowed to complete.

Note: For more details on these attributes, see http://hostname:port/rest/rollups/config/documentation.

Example: In this example, you change the schedule so that rollup processing and baseline calculations run only from 20:00 to 7:00.

<RollupsConfigurationList>

 <RollupsConfiguration version="1.0.0">
	  <ID>8</ID>
	  <StartHour>20</StartHour>
	  <EndHour>6</EndHour>
 </RollupsConfiguration>

</RollupsConfigurationList>

The <EndHour> is inclusive. In this example, that means if you specify 6 as the EndHour, rollup processing and baseline calculations will be initated in at the bottom of the hour during the 06:00 hour, but they will not be initiated at the 07:00 hour. Any calculations that are in progress will be allowed to complete.

Important! Any modifications to the default schedule can result in a larger delay in data showing up in reports pertaining to the corresponding resolution. For example, if hourly rollups are delayed, then a reporting showing hourly resolution data will not be current until the hourly rollup has been performed.