Troubleshooting: PEGA0026 alerts indicate connection pool settings too low
Many instances of the critical alert PEGA0026 occur in the PegaRULES Alert log and in the PegaRULES Log.
PEGA0026 Time to connect to database exceeds limit
This alert often indicates that the connection pool settings for the PegaRULES database require adjustment to improve performance.
The instructions below are for Oracle products. Details for adjusting the connection pool settings differ by platform
Example: WebLogic 10 with Oracle 10g database
The application server is Oracle BEA WebLogic Version 10 running on Solaris with two WebLogic JVMs clustered. You have specified a connection pool to connect to the PegaRULES database using Oracle 10g. The database connection pool has an initial size of 70 connections with the maximum connections set to 125 for a total of 310 users.
Initial Connection Pool settings might look like this example:
JNDI Name: jdbc/PegaRULES
Row Prefetch Enabled false
Row Prefetch Size: 48
Stream Chunk Size: 256
URL - jdbc:oracle:thin:@your_database_URL_used_to_create_the_connections_ in_this_Connection_Pool
Driver Class Name: oracle.jdbc.OracleDriver
Properties: oracle.jdbc.V8Compatible=true user
Initial Capacity: 70
Maximum Capacity: 125
Capacity Increment: 10
Statement Cache Type: LRU
Statement Cache Size: 10
Test Connections On Reserve: true
Test Frequency: 120
Test Table Name: SQL SELECT 1 FROM DUAL
Seconds to Trust an Idle Pool Connection: 10
Shrink Frequency: 900
Connection Creation Retry Frequency:0
Login Delay: 0
Inactive Connection Timeout: 120
Maximum Waiting for Connection: 2147483647
Connection Reserve Timeout: 10
Statement Timeout: -1
Ignore In-Use Connections: true
Remove Infected Connections Enabled: true
To reduce or eliminate the number of PEGA0026 alerts, take the following actions:
Set the initial connection pool size to match the total number of connections created during the performance test. In the example above, the setting for Initial Capacity should be 125 to match the Maximum Capacity.
This ensures that all the required connections are obtained up front when the WebLogic application server starts.
- After you have adjusted and tested the connection pool settings, turn on the setting Test Connection on Reserve to ensure that the connection is not destroyed or lost when the connection is idle in the pool.
- By properly configuring connection pools in your WebLogic Server domain, you can improve application and system performance. Refer to the Oracle/BEA WebLogic Server Administration Console Help topics on tuning data source connection pool options that are cited as references below.