Distributed Transaction Processing User Guide > Distributed Transaction Processing User Guide > Troubleshooting and Tuning Ingres DTP Applications > Performance Tuning > Session Cache Limit
Was this helpful?
Session Cache Limit
An application server maintains several free sessions in order to minimize connection time when an application requires a connection. By default, Ingres DTP accumulates sessions to a maximum of 32. To change the maximum number of free sessions, set the II_XA_SESSION_CACHE_LIMIT variable. The value you specify for II_XA_SESSION_CACHE_LIMIT cannot exceed the session limit.
To calculate the maximum number of connections your application server will require, use the following formula:
(# of RMI's per AS) * (# of concurrent transactions)
Last modified date: 01/30/2023