Method and apparatus for autonomic management of connection pools

1. An autonomic connection pool management method, comprising:

initializing a connection pool in accordance with a plurality of initial configuration settings;

automatically collecting autonomic configuration information, the autonomic configuration information comprising pool connection usage data for specified time intervals;

automatically generating autonomic override information from the usage data; and

automatically modifying the configuration settings using the autonomic override information.

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

3. The method of claim 1 , wherein the plurality of initial settings comprises a collection interval.

4. The method of claim 3 , wherein the plurality of initial settings comprises a collection duration.

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

6. The method of claim 1 , wherein the pool connection usage data comprises a maximum number of connection during the specified time intervals.

7. The method of claim 1 , further comprising:

automatically collecting additional usage data;

automatically generating additional autonomic override information from the additional usage data; and

automatically further modifying the connection pool using the additional autonomic override information.

8. The method of claim 1 , further comprising automatically modifying the connection pool using the configuration override information, comprising:

receiving a timer event;

in response to the timer event:

determining a current time;

determining a current number of connections; and

if the current number of connections greater than a specified maximum associated with the current time:

adding at least one new connections to the connection pool; and

initializing timeout values for all available connections in the connection pool.

9. The method of claim 1 , further comprising automatically modifying the connection pool using the configuration override information, comprising:

receiving a connection timer event;

in response to the connection timer event:

determining a current time;

determining a current number of connections;

if a current number of connections is greater than a specified maximum associated with the current time:

detecting one or more timed-out idle connection;

destroying the one or more timed-out idle connections; and

if a current number of connections is below a specified minimum associated with the current time:

resetting time-out values for all of the connections in the pool.

10. The method of claim 1 , further comprising automatically modifying the connection pool using the configuration override information, comprising:

receiving a connection event;

in response to receiving a request to connect:

detecting a current number of connections;

determining a current time of day; and

if the current number of connections is less than the modified maximum number of connections for the time period associated with the current time of day, creating a new connection.

11. The method of claim 1 , wherein automatically collecting autonomic configuration information comprises:

determining a maximum number of connections during a measurement interval;

comparing the measured maximum number of connections to corresponding configuration settings.

12. The method of claim 1 , further comprising:

in response to initializing the connection pool, operating the connection pool in accordance with the plurality of initial configuration settings; and

in response to automatically modifying the connection settings, operating connection pool in accordance with the modified configuration settings.

13. A computer-implemented method of managing a connection pool, 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;

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

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

automatically modifying the configuration settings to the set of optimal settings.

14. The method of claim 13 , further comprising:

automatically 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;

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

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

15. The method of claim 14 , wherein the connection pool comprises Java Database Connectivity connections.

16. The method of claim 14 , wherein the connection pool comprises Java 2 Connector connections.

17. 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 autonomically managing a connection pool comprising:

initializing a connection pool in accordance with a plurality of initial configuration settings;

automatically collecting autonomic configuration information, the autonomic configuration information comprising pool connection usage data for specified time intervals;

automatically generating autonomic override information from the usage data; and

automatically modifying the configuration settings using the autonomic override information.

18. The method of claim 17 , further comprising:

analyzing the computing system;

creating recommendations responsive to the analysis; and

generating computer readable code to implement portions of the recommendations.