Connection Pooling

Connection pooling enables an application to use a connection from a pool of connections that do not need to be re-established for each use. You can use the Connection Pooling tab in the ODBC Administrator to alter the connection retry wait time and connection timeout period for any selected driver. You can also use it to enable and disable performance monitoring.

When the ODBC Driver Manager detects that a database server is unavailable, it waits for a certain amount of time before it attempts to connect again. You can adjust the waiting time by setting the Retry Wait Time value in seconds in the dialog box for a specific driver. You can set the connection timeout period in the same way.

For more information about connection pooling, see “Connection Pooling” in Chapter 6 of the ODBC Programmer’s Reference.

Performance Monitoring

Performance monitoring tracks connection performance by recording a variety of statistics. These statistics can be customized by the developer to include such items as:

• The number of connections made to data sources per second.
  
  
• The number of disconnections made from data sources per second.
  
  
• The number of connections to the pool per second.
  
  
• The number of disconnections from the pool per second.
  
  
• Connections currently active.
  
  
• The current number of connections being used by applications.
  
  
• Connections currently free.
  
  
• The current number of connections available for connection requests.

You must specify your own monitoring parameters. Samples for performance monitoring have been included with this version of ODBC.