Microsoft KB Archive/930393

= An update that lets you configure the connection pool properties in Host Integration Server 2004 OLE DB Provider for DB2 is available =

Article ID: 930393

Article Last Modified on 12/4/2007

-

APPLIES TO


 * Microsoft Host Integration Server 2004 Standard Edition
 * Microsoft Host Integration Server 2004 Enterprise Edition

-



INTRODUCTION
Microsoft OLE DB Provider for DB2 is included in Microsoft Host Integration Server 2004. You can configure OLE DB Provider for DB2 to support connection pooling when OLE DB Provider for DB2 connects to an IBM DB2 computer. However, you cannot configure the connection pool properties that OLE DB Provider for DB2 implements.

An update that lets you configure the connection pool properties in OLE DB Provider for DB2 is available.



Service pack information
This feature is available in the latest service pack for Host Integration Server 2004. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

940313 How to obtain the latest Host Integration Server 2004 service pack

Software update information
A supported feature that modifies the product's default behavior is now available from Microsoft. However, it is intended to modify only the behavior that this article describes. Apply it only to systems that specifically require it. This feature may receive additional testing. Therefore, if the system is not severely affected by the lack of this feature, we recommend that you wait for the next Host Integration Server 2004 service pack that contains this feature.

To obtain this feature immediately, contact Microsoft Customer Support Services. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

File information
The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.



Updated connection pool properties
After you apply this update, you can configure the following connection pool properties in OLE DB Provider for DB2:
 * The maximum number of connections in the connection pool
 * The time-out period for new connection requests when all the connections in the connection pool are being used

The Max Pool Size property
The Max Pool Size property is an optional OLE DB data source initialization property. You can use this property to specify the maximum number of connections that can exist in the connection pool when connection pooling is enabled for the data source.

By default, the value of the Max Pool Size property is 100. There is no upper limit for the Max Pool Size property. If you configure a value that is less than 0 for the Max Pool Size property, the default value of 100 is used.

The Connect Timeout property
The Connect Timeout property is an optional OLE DB data source initialization property. You can use this property to specify how long a new connection request waits when all the connections in the connection pool are being used. If a connection does not become available before the value of the Connect Timeout property expires, the new connection request fails, and a &quot;connection not available&quot; exception occurs.

By default, the value of the Connect Timeout property is 15 seconds. There is no upper limit for the Connect Timeout property. If you want an infinite time-out period, configure the Connect Timeout property by using the -1 value.

You can configure the Max Pool Size property and the Connect Timeout property in the following locations:   You can configure these properties in an OLE DB initialization string by using the following arguments. Max Pool Size= Connect Timeout= Note An OLE DB initialization string is also known as a connection string.

The following sample connection string implements these two properties. ; Everything after this line is an OLE DB initialization string Provider=DB2OLEDB;Password=;Persist Security Info=True;User ID=;Initial Catalog=;Defer Prepare=False;Network Transport Library=TCP;Host CCSID=1208;PC Code Page=1252;Max Pool Size=;Connect Timeout=;Network Address=;Network Port=446;Package Collection=NULLID;Default Schema=NULLID;Default Qualifier=NULLID;DBMS Platform=DB2/MVS;Process Binary as Character=False;Connection Pooling=True;Units of Work=RUW  You can configure these properties on the All tab in the Data Link Properties dialog box.</ul>

Considerations
The Max Pool Size property and the Connect Timeout property are only valid if the Connection Pooling property is set to the True value.

The Max Pool Size property and the Connect Timeout property are implemented for each Microsoft Windows process. If multiple Windows processes are running, each Windows process can open the specified number of connections in the connection pool.

<div class="references_section">