HAMAXNUMCONNECTION

Sets the maximum number of connections per database that Analytic Services can keep active against the relational database.

Syntax

HAMAXNUMCONNECTION [appname [dbname]] n

 appname Optional parameter. If you supply an application name, the setting applies to all databases within the named application. If you do not supply an application name, the setting applies to all applications and databases on the Analytic Server.
 dbname Optional parameter. If you supply a database name and an application name, the setting applies only to the named database. If you do not also provide an application name, the database is ignored and the setting applies to all applications and databases on the Analytic Server.
n Specifies the number of connections per database that Analytic Services can keep connected to a relational database. The default is 25.

Description

This setting determines the maximum number of connections per database that Analytic Services can keep active against the relational database. This optimizes the overhead involved in opening a relational database connection for every Hybrid Analysis report.

Notes

You may need to set the value for the HAMAXNUMCONNECTION higher if, in Integration Services Console, you set the security mode to use the Analytic Services user ID to connect to the source database. Refer to Integration Services online help for more information on the security mode setting.

Example

HAMAXNUMCONNECTION 10

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com