Database connection failures

When InterChange Server Express needs a database connection for one of its services but finds that the maximum number of connections are already in use, the server tries to free a connection that is idle. If the server is unsuccessful, the connection attempt fails and InterChange Server Express logs error 5010: Unable to find an available connection in the cache. The maximum number of connections max-connections-value has been reached.

If you set a constraint on the number of InterChange Server Express connections by setting the MAX_CONNECTIONS parameter, you should monitor error 5010 messages because a connection failure can have undesirable consequences. For example, when InterChange Server Express cannot obtain a connection for its event management service, it stops running. By default, this constraint is set to an unlimited number of connections.

Connection failures indicate that the maximum number of allocated connections is insufficient to meet the run-time work load. If you cannot allocate more connections to InterChange Server Express in the current database, consider partitioning its workload across multiple databases.

Copyright IBM Corp. 2004