Method and apparatus for autonomic management of connection pools

• US 20060095572A1
• Filed: 10/08/2004
• Published: 05/04/2006
• Est. Priority Date: 10/08/2004
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Burke, Michael Robert, Silber, George
• Granted Patent: US 8,244,865 B2
• Time in Patent Office: Days
• US Class Current: 709/227
• CPC Class Codes: H04L 67/14 Session management for real-time applications in data packet communications networks H04L65/1066

Abstract

A method and apparatus for autonomic management of a connection pool. One embodiment comprises initializing a connection pool with a set of initial settings, wherein the set of initial settings include a collection interval and a collection duration; collecting autonomic configuration data for the collection duration, the autonomic configuration data including a maximum number of connections observed during the collection interval; determining an set of optimal settings using the autonomic configuration data; and modifying the connection pool according to the set of optimal settings.

Claims

1. An autonomic connection pool management method, comprising:

initializing a connection pool;

collecting autonomic configuration information; and

modifying the connection pool using the autonomic configuration information.

2. The method of claim 1, wherein the connection pool is initialized using a plurality of initial settings.

3. The method of claim 2, wherein the plurality of initial settings comprises a collection management mode

4. The method of claim 2, wherein the plurality of initial settings comprises a collection interval.

5. The method of claim 2, wherein the plurality of initial settings comprises a collection duration.

6. The method of claim 2, wherein the plurality of initial settings comprises a collection run characteristic

7. The method of claim 1, wherein the autonomic configuration information comprises a maximum number of connection during a collection interval.

8. The method of claim 1, further comprising:

collecting additional autonomic configuration information;

further modifying the connection pool using the additional autonomic configuration information.

9. A method of operating a server, comprising:

initializing a connection pool with a set of initial settings, wherein the set of initial settings include a collection interval and a collection duration;

collecting autonomic configuration data for the collection duration, the autonomic configuration data including a maximum number of connections observed during the collection interval;

determining an set of optimal settings using the autonomic configuration data; and

modifying the connection pool according to the set of optimal settings.

10. The method of claim 9, further comprising:

collecting additional autonomic configuration data for a second collection duration, the additional autonomic configuration data including a maximum number of connections observed during the second collection interval;

adjusting the set of optimal settings using the additional autonomic configuration data; and

modifying the connection pool according to the adjusted set of optimal settings.

11. The method of claim 10, wherein the connection pool comprises Java Database Connectivity connections.

12. The method of claim 10, wherein the connection pool comprises Java 2 Connector connections.

13. A computer program product, comprising:

(a) a program configured to perform an autonomic connection pool management method, comprising;

initializing the connection pool;

collecting autonomic configuration information; and

modifying the connection pool using the autonomic configuration information; and

(b) a signal bearing media bearing the program.

14. The computer program product of claim 13, wherein the program comprises an application server.

15. The computer program product of claim 13, wherein the signal bearing media is chosen from the group consisting of:

information permanently stored on non-writable storage media;

alterable information stored on writable storage media; and

information conveyed to a computer by a communications medium.

16. A method of deploying computing infrastructure, comprising:

integrating computer readable code into a computing system, wherein the code in combination with the computing system is capable of performing a method of managing a connection pool comprising;

initializing a connection pool;

collecting autonomic configuration information; and

modifying the connection pool using the autonomic configuration information.

17. The method of claim 16, further comprising:

analyzing the computing system;

creating recommendations responsive to the analysis; and

generating computer readable code to implement portions of the recommendations.