CONNECTIONIDLETIMEOUT

Essbase relies on SQL connectivity to external databases. To optimize connectivity when your organization has a high frequency of data updates, use the CONNECTIONIDLETIMEOUT configuration setting to add a time limit on the connections remaining open after last use.

Syntax

CONNECTIONIDLETIMEOUT [appname] n

n—Maximum time, in minutes, that a connection is kept open since last use. The default is 0, meaning there is no timeout.

Description

Open connections are returned to the pool after use, where they stay until the next use. If the connection is not used during defined amount of time after the last use, it will be closed and removed from the pool.

Example

CONNECTIONIDLETIMEOUT Sample 30

See Also

CONNECTIONPOOLSIZE