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

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.

Notes

• An update that lets you configure the connection pool properties in OLE DB Provider for DB2 is available.
• This issua also occurs in Microsoft Host Integration Server 2006

Service pack information for Host Integration Server 2004

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:

Service pack information for Host Integration Server 2006

To resolve this problem, obtain the latest service pack for Host Integration Server 2006. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

Software update information

A supported feature that modifies the default behavior of the product is available from Microsoft. However, this feature is intended to modify only the behavior that this article describes. Apply this feature only to systems that specifically require it. This feature might 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 software update that contains this feature.

If the feature is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the feature.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific feature. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the feature is available. If you do not see your language, it is because the feature is not available for that language.

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 "connection not available" 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=<Value>
  Connect Timeout=<Value>

  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=<Password>;Persist Security Info=True;User ID=<UserName>;Initial Catalog=<InitialCatalogName>;Defer Prepare=False;Network Transport Library=TCP;Host CCSID=1208;PC Code Page=1252;Max Pool Size=<Value>;Connect Timeout=<Value>;Network Address=<IPAddress>;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.

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.

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.