Administrator

Mobiliser Database Connection Pool Properties

Connection pools allow SAP Mobile Platform Server to reuse established connections to the database. Mobiliser uses its own connection pool. If you have enabled Mobiliser features, you can adjust the minimum and maximum number of connections for each connection pool partition.

Configuring the Mobiliser Database Connection Pools

Mobiliser connection pools support partitioning. Depending on the transaction being performed, SAP Mobile Platform Server requires multiple calls to the database to complete the transaction. A large number of connections are required for high volumes of concurrent transactions. The total number of database connections is the product of the number of partitions and the connections per partition. If there are no operating system or database restrictions, running a higher number of database connections than recommended does not negatively impact performance. The same is also true for the number of partitions.

The Mobiliser database connection properties are located in <SMP_HOME>\Server\config_master\com.sybase365.mobiliser.framework.persistence.jdbc.bonecp.pool\pool.properties.
Setting Name Default Value Modified Value
maxConnectionsPerPartition 10 16 * CPU cores
minConnectionsPerPartition 1 16 * CPU cores
partitionCount 2 N/A (default is recommended)

Restart the server after making any changes to database connection properties.

Configuring Connections for the Database

If the database runs out of available connections, it causes SAP Mobile Platform Server stability problems. The database must be configured with adequate connections to support the maximum number of connections required by SAP Mobile Platform Server. In a clustered SAP Mobile Platform Server environment, the database must be configured to support the maximum number of connections from each node.

If you have enabled Mobiliser features for SAP Mobile Platform Server, calculate the total maximum number of connections required by adding together the maximum number of main connections and the maximum number of Mobiliser connections, then multiplying the result by the number of nodes in the cluster:
(<max main connections> + <max Mobiliser connections>) * <number of nodes>
It is recommended that you configure your database to support far more than the total maximum number of connections. You need additional connections for activities such as SAP Mobile Platform Server administration and for situations such as when database connections become stale due to losing network connectivity between SAP Mobile Platform Server and the database.

Please refer to the database documentation for the type of database that is used for SAP Mobile Platform Server.