New Connections

When the engine is asked to create a new external connection, the pool first looks for a candidate in the “idle” list.The search, which is case-sensitive, involves four parameters:

connection string
username
password
role

If a suitable connection is found, it is tested to check that it is still alive.

If it fails the check, it is deleted, and the search is repeated, without reporting any error to the client
Otherwise, the live connection is moved from the “idle” list to the “active” list and returned to the caller
If there are multiple suitable connections, the most recently used one is chosen
If there is no suitable connection, a new one is created and added to the “active” list.

Who Can Alter the External Connections Pool

The ALTER EXTERNAL CONNECTIONS POOL statement can be executed by:

Administrators
Users with the MODIFY_EXT_CONN_POOL privilege