Manage Data Source Connections

Each instance of the report server has an established pool of database connections. The connections are reused for new requests that match the database, user, and password. Entries remain in the pool until they are idle for a timeout period and then are closed. Once a pool is full, no further connection are added. This results in a request failure.

PoolSize

Set the maximum number of data source connections available to the report server by modifying the PoolSize variable.

Timeout

Set the duration for retaining connections by modifying the Timeout variable. Connections are examined once per minute and any connection that has been inactive longer than the timeout value is removed. The default timeout value is 900 seconds.

Reusable Data Connections

Data source connections are reusable only when the database credentials of the connection match those of the new request. Inactive data source connections can be claimed by a new request. This occurs when the maximum number of connections has been reached and none of the inactive connections can be used by the new request. In this case, the oldest inactive connection is terminated and a new connection is created.

When the maximum number of connections is reached, and all are active, then additional requests fail. The server must be configured to ensure that the concurrent report requests do not exceed the request pool size.

For more information about report service requests, see Set the Maximum Number of Processes and Connections.

Steps

1. On each computer where IBM Cognos 8 is installed, open the c8_location/configuration/CQEConfig.xml.sample file in a text editor.

   Ensure that your editor supports saving files in UTF-8 format.

2. Find the Timeout and PoolSize parameter and edit them as follows:

   <?xml version="1.0" encoding="UTF-8"?>
   <configuration company="Cognos" version="#.#"
   rendition="###">
     <component name="CQE">
       <section name="DBConnectionPool">
         <!-- Description: Database connection timeout.
          Default is 900 seconds (15minutes) --> 
         <entry name="Timeout" value="number_of_seconds"/>
         <!-- -->
         <!-- Description: Database connection pool size. -->
         <!-- Maximum number of connections managed by the report
              server. Default=50 -->
         <entry name="PoolSize" value="number_of_connections"/>
       </section>
     </component>
   </configuration>

3. Save the file as CQEConfig.xml to the c8_location/configuration directory.

4. Using IBM Cognos Configuration, stop and then restart the services.

   For information about stopping services, see the IBM Cognos 8 Installation and Configuration Guide.