Microsoft KB Archive/930393

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.

MORE INFORMATION

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:

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.

File name File version File size Date Time Platform
Convertprimex.dll 6.0.2080.0 75,264 27-Mar-2007 20:05 x86
Db2oledb.dll 6.0.2080.0 500,064 27-Mar-2007 20:57 x86
Db2oledb.h Not Applicable 24,660 27-Mar-2007 20:06 Not Applicable
Ddmstr.dll 6.0.2080.0 53,592 27-Mar-2007 20:57 x86
Dpl1.dll 6.0.2080.0 20,480 27-Mar-2007 20:06 x86
Drdaresync.exe 6.0.2080.0 346,976 27-Mar-2007 20:57 x86
Microsoft.hostintegration.dataaccesslibrary.dll 6.0.2080.0 95,656 27-Mar-2007 20:54 x86
Microsoft.hostintegration.dataaccesstool.exe 6.0.2080.0 2,712,992 27-Mar-2007 20:54 x86
Microsoft.hostintegration.msdb2client.dll 6.0.2080.0 124,312 27-Mar-2007 20:54 x86
Mseidb2c.dll 6.0.2080.0 81,248 27-Mar-2007 20:57 x86
Mseidb2d.dll 6.0.2080.0 444,768 27-Mar-2007 20:57 x86
Mseidrda.dll 6.0.2080.0 708,448 27-Mar-2007 20:57 x86
Snanls.dll 6.0.2080.0 77,312 27-Mar-2007 20:02 x86
Sysctblj.exe 6.0.2080.0 30,720 27-Mar-2007 20:02 x86
Sysctblk.exe 6.0.2080.0 29,696 27-Mar-2007 20:02 x86
Sysctbls.exe 6.0.2080.0 29,696 27-Mar-2007 20:02 x86
Sysctblt.exe 6.0.2080.0 29,696 27-Mar-2007 20:02 x86
Tranlu62.dll 6.0.2080.0 54,272 27-Mar-2007 20:06 x86
Trantcp.dll 6.0.2080.0 104,960 27-Mar-2007 20:06 x86
Trnsdt.dll 6.0.2080.0 10,752 27-Mar-2007 20:02 x86
Trnsdtj.dll 6.0.2080.0 7,680 27-Mar-2007 20:02 x86
Trnsdtk.dll 6.0.2080.0 6,656 27-Mar-2007 20:02 x86
Trnsdts.dll 6.0.2080.0 6,144 27-Mar-2007 20:02 x86
Trnsdtt.dll 6.0.2080.0 6,656 27-Mar-2007 20:02 x86


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.

REFERENCES

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates


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.

Keywords: kbfix kbqfe kbpubtypekc kbhotfixserver KB930393