Skip to main content
NetApp Knowledge Base

How To: set the maximum number of available data source connections in Cognos

Views:
460
Visibility:
Public
Votes:
3
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

Applies to

DWH Cognos

Description

You can set the maximum number of available data source connections, the duration for retaining connections, and how data source connections are reused.
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 connections are added. This results in a request failure.
PoolSize
Specifies the maximum number of data source connections available to the report server.
Timeout
Specifies the time duration for retaining connections. Connections are examined once per minute and any connection that has been inactive longer than the timeout value is removed.
Default: 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.

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.