1. Administrator's Guide
  2. Setting Up Database Connections
  3. Configure Maximum Connections

Configure Maximum Connections

By default, the maximum number of database connections defined for the Application Module is 250.

You can use the following formula to determine what to set the value to. It:

  • Allows 4 connections per concurrent user to support each user having 3 data entry windows.
  • Provides an additional buffer because when a user opens data entry the system requires about 5 connections. It then releases 4 of them.

The formula is:

p + n * 3.5

where p is the Application Module pool size and n is the number or concurrent users you expect.

For example, if you expect 10 concurrent user connections and the Application Module pool size is 250, then the formula is 250 + 10 * 3.5, which means that your application can support up to 385 concurrent connections.

am_max_available_size: The default value is 250. Increase or decrease this according to the expected concurrent users. You may also need to change the parameter am_recycle_threshold accordingly. Restart the OpaServer for the changes to take effect.

am_recycle_threshold: The default value is 200. Set this equal to or at least 80% of the value of parameter am_max_available_size. Restart the OpaServer for the changes to take effect.

The value for the Maximum Capacity parameter for the data source should be equal to or greater than the number of concurrent users you expect for TMS Reports (OPA data source).

To change this value:

  1. Log in to the WebLogic Server Administration Console at: 
    http://host:7101/console
  2. Select Data Sources, then select the data source whose setting you want to modify: for example, DS_1_rdc for RDC or DS_1_ops for OPA (TMS reports).
  3. Click the Connection Pool tab.
  4. Scroll down to find the parameter Maximum Capacity.
  5. Enter a value and save.
  6. Restart the OPA server to apply your changes.
    See Restarting the OPA Server for instructions.

Note:

When you create a new data source, create it for a particular application, such as RDC, or TMS, and ensure that it will only be used for that application.

Parent topic: Setting Up Database Connections