An application server maintains a number of 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: