Question
JP Morgan Chase
IN
Last activity: 19 Dec 2016 1:23 EST
Optimum DB connections for PegaRULES DB as a JNDI
I have an V5.5 application which has a total of 42 JVM's (36 User Nodes and 6 Agents Nodes). A total of 50 Agents run in the Application (including Pega default Agents).
The frequency of most of the Agents is every 30sec, but some have a frequency of every 4 hrs or per day as well.
Most of the work objects gets created via Batch Processes (i.e Agents). A total of around 45k work objects gets created on a daily basis.
The total number of users in the Application are around 1800~, which maximum number of concurrent users being around 400-500~.
I have an V5.5 application which has a total of 42 JVM's (36 User Nodes and 6 Agents Nodes). A total of 50 Agents run in the Application (including Pega default Agents).
The frequency of most of the Agents is every 30sec, but some have a frequency of every 4 hrs or per day as well.
Most of the work objects gets created via Batch Processes (i.e Agents). A total of around 45k work objects gets created on a daily basis.
The total number of users in the Application are around 1800~, which maximum number of concurrent users being around 400-500~.
Questions:
1. Right now, the PegaRULES connection is in prconfig.xml, which no mention of max connections. Does it assume unlimited connection pools available.
2. We plan to shift the PegaRULES connection setting as a JNDI on Websphere, what should be the number of max connections which should be given in Data Source Connection Pool properties for PegaRULES.
3. Should PegaRULES data source be configured at a Cell Level/Node Level on Websphere? What should be the number of connections, if it is defined at a cell level (Number of connections*number of of JVM's in that cell?)
4. How do Connection pools get used or created, whether it is a User logging in or a Agent processing something.
Pegasystems Inc.
IN
Hi,
1. Right now, the PegaRULES connection is in prconfig.xml, which no mention of max connections. Does it assume unlimited connection pools available.
Default is 10 connections
2. We plan to shift the PegaRULES connection setting as a JNDI on Websphere, what should be the number of max connections which should be given in Data Source Connection Pool properties for PegaRULES.
Set the maximum connections value to 50 or higher based on your environment.
3. Should PegaRULES data source be configured at a Cell Level/Node Level on Websphere? What should be the number of connections, if it is defined at a cell level (Number of connections*number of of JVM's in that cell?)
This is based on your requirement. Here is the scope of each level.
Hi,
1. Right now, the PegaRULES connection is in prconfig.xml, which no mention of max connections. Does it assume unlimited connection pools available.
Default is 10 connections
2. We plan to shift the PegaRULES connection setting as a JNDI on Websphere, what should be the number of max connections which should be given in Data Source Connection Pool properties for PegaRULES.
Set the maximum connections value to 50 or higher based on your environment.
3. Should PegaRULES data source be configured at a Cell Level/Node Level on Websphere? What should be the number of connections, if it is defined at a cell level (Number of connections*number of of JVM's in that cell?)
This is based on your requirement. Here is the scope of each level.
- Cell
- The most general scope. Resources defined at the Cell scope are visible from all Nodes and servers, unless they are overridden. To view resources defined in the cell scope, do not specify a server or a node name in the scope selection form.
- Node
- The default scope for most resource types. Resources defined at the Node scope override any duplicates defined at the Cell scope and are visible to all servers on the same node, unless they are overridden at a server scope on that node. To view resources defined in a node scope, do not specify a server, but select a node name in the scope selection form.
- Server
- The most specific scope for defining resources. Resources defined at the Server scope override any duplicate resource definitions defined at the Cell scope or parent Node scope and are visible only to a specific server. To view resources defined in a server scope, specify a server name as well as a node name in the scope selection form.
4. How do Connection pools get used or created, whether it is a User logging in or a Agent processing something.
Connection pools get used when get connection called from application.