Setting the Encyclopedia engine connection pool reap interval
The connection pool reap interval specifies the time, in seconds, between runs of the maintenance thread. When the maintenance thread runs, it discards any connections that have not been used since the last time the maintenance thread ran.
1 Stop the BIRT iHub cluster. For information on stopping the cluster, see "Taking the cluster offline," in Chapter 3, "Configuring BIRT iHub to use an alternative database on a Windows platform," or Chapter 4, "Configuring BIRT iHub to use an alternative database on a Linux platform," in the BIRT iHub System Administration Guide.
2 Navigate to the shared configuration directory. For example, if the system administrator created a folder for the shared configuration directory named config_cluster, then in a default BIRT iHub installation on Windows, where BIRT iHub was installed as an individual module, the path to the shared configuration directory is:
C:\Actuate3\BIRTiHubVisualization\modules\BIRTiHub\iHub\shared
\config_cluster
3 As a best practice, create a backup copy of acserverconfig.xml. Then, open acserverconfig.xml using a text editor.
4 Find a <Template> element in which you want to define the connection pool reap interval. Within that <Template> element, find the <ViewingService> subelement. The following example shows the <ViewingService> subelement of the small <Template> element in the acserverconfig.xml file that installs with BIRT iHub:
<ViewingService
ViewingWeight="100"
FileCacheTimeout="86400"
...
PersistentArchiveFileCacheTimeout="7200"
BIRTReportDesignCacheTotalNumberOfEntries="50"/>
5 Add the DefaultConnectionPoolReapInterval property to the list of <ViewingService> attributes. Specify the value as the number of seconds between each time the maintenance thread runs. The default value is 600. The permissible range of values is 0 through 86400. The following example shows the <ViewingService> element with the DefaultConnectionPoolReapInterval attribute added to the list of attributes:
<ViewingService
ViewingWeight="100"
FileCacheTimeout="86400"
...
PersistentArchiveFileCacheTimeout="7200"
BIRTReportDesignCacheTotalNumberOfEntries="50"
DefaultConnectionPoolReapInterval="600"/>
6 Perform steps 4 and 5 for each template in which you want to specify the connection pool reap interval. Save and exit the file.
7 Start the BIRT iHub cluster. For information on performing this task, see "How to start the cluster," in Chapter 3, “Configuring BIRT iHub to use an alternative database on a Windows platform," or Chapter 4, "Configuring BIRT iHub to use an alternative database on a Linux platform," in the BIRT iHub System Administration Guide.