Configuring database connections – maximum and minimum (scalability)

At server startup time, the MSCM server initializes 10 connections to the database. If necessary, it will create an additional 10 connections for a total of 20 open connections to the database. For most needs this will be sufficient.

If the message "No Managed Connections Available" begins to appear in the server.log files, this indicates that the maximum database connection poolsize is insufficient. An increase to the maximum poolsize by ten should be sufficient to address the No Managed Connections Available problem.

Note: 

Consult with your database administrator to inform him or her of the changes you are making.

To change the setting for database connections

  1. Consider user workloads, and identify an appropriate time to stop the server.
  2. Stop the server.
  3. Locate the configuration file called mscm.filter.properties
  4. Locate the following section and increase the maximum poolsize by 10. 
    ##################
    ## db pool size ## 
    ##################
    min.pool.size=10
    max.pool.size=20
  5. Deploy the changes by following the configuration change deployment procedure. See the Mobile Supply Chain Management Installation Guide.