Net.IBM.Data.Db2 10.0.0.400

About

This package provides IBM Data Server connectivity for .NET 8.0 and later.

Key Features

Support for Microsoft ADO.NET specifications as well as IBM Data Server features.

How to use

Use package manager to add package to the project, build it and deploy it as any other .NET NuGet package based deployment.
In cases where Db2Connect license is needed, the license file needs to be copied to clidriver/license folder as detailed here:
https://community.ibm.com/community/user/blogs/vishwa-hs1/2020/07/12/db2-net-packages-download-and-configure

Main Types

All ADO.NET specification types.

Additional Documentation

IBM Information center for class level documentation  
    https://www.ibm.com/docs/en/db2/11.1?topic=namespaces-ibmdatadb2

What's New

v10.0.0.400
    - Package compatibility:
        � The Windows `Net.IBM.Data.Db2` package now targets .NET Standard 2.1 and .NET 10. Use the .NET Standard 2.1 target with .NET 8 or later, or another runtime that supports .NET Standard 2.1; use the .NET 10 target for .NET 10 applications.
        � Non-Windows packages (`-lnx`, `-osx`, `-zlnx`, and `-ppc`) continue to target .NET 10 only.
        � The `TestConn` utility is included in the `tools/` folder and requires the .NET 10 or later runtime.
    - Fixes:
        � KI DT496502 : Fixed an issue where stored procedures using array input parameters could insert fewer rows than expected with Db2 .NET 8 and later provider versions.
        � Fixed an issue that could cause concurrent stored procedure executions to return corrupted output parameter values. This issue affected `Net.IBM.Data.Db2` package versions later than 8.0.0.200.
    - Improvements and component updates:
        � Improved data-length handling for parameters and query results.
        � Updated the bundled CLI libraries. Windows packages now include `db2clio.dll`; non-Windows packages include the platform-specific `libdb2o` library. Diagnostic messages may refer to these names instead of `db2app64` or `libdb2`.
        � Updated the CLI driver to version 12.1.5.0 CSB 94858.

 v10.0.0.300
    � CLI driver upgrade to 12.1.5.0 CSB 89304.

v10.0.0.200
    � CLI driver upgrade to 12.1.4.0.

v10.0.0.100
    � Added support for .NET 10.0.
    � The ReleaseObjectPool() method is deprecated and should no longer be used. Use of this method may result in memory corruption in some cases.

v9.0.0.400
    � CLI driver upgrade to 12.1.2.0 Special Build 67327 
    � The Support of LockTimeout keyword : The LockTimeout keyword setting specifies the number of seconds, that an application or a statement will wait to acquire a lock on a resource before the waiting operation is canceled and an error is returned. It mainly prevents applications from waiting indefinitely for a locked resource, which could lead to application hangs or deadlocks if not handled. 
        The LockTimeout can be set via DB2Connection.ConnectionString property's keyword, DB2ConnectionStringBuilder property, db2dsdriver.cfg config file.
        Values supported for LockTimeout keyword: 
            -1 : Often indicates an indefinite wait, meaning the application will wait until the lock is granted or a deadlock occurs.
            0  : Indicates no waiting; if the lock cannot be obtained immediately, an error is returned. 
            Positive integer <= 32767 : Specifies the number of seconds to wait before timing out.
        Default setting:
            Timeout is turned off (-1), with the application waiting for a lock until either the lock is granted or deadlock occurs.

V9.0.0.300
    � CLI driver upgrade to 12.1.2.0 
    � SSLClientHostnameValidation keyword is used to control the hostname validation behavior for Db2 .NET applications. Its default value is changed to Basic from OFF.
    � KI DT421871 : Client special registers are not replayed when using WLM if CONDBAT limit is reached on Z/OS.

V9.0.0.200
    � CLI driver upgraded to 12.1.1.0 CSB 54960, please use Db2Connect 12.1 license for this package.
    � Support for QueryPrefetch keyword enables prefetching of multiple query blocks for a forward only blocked cursor.
    � KI DT421709 : On Linux platform, stored procedure call failed with SQL0902 error when stored procedure used scrollable cursor to fetch data.
    � KI DT196972 : DB2DataReader.GetValue() method should return boolean value(True/False) for boolean column data type.

Related Packages

� Net.IBM.Data.Db2 : Windows x64
� Net.IBM.Data.Db2-lnx : Linux AMD64
� Net.IBM.Data.Db2-osx : Mac ARM64 M1/M2/M3
� Net.IBM.Data.Db2-zlnx : Linux on IBM Z (Linux s390x)
� Net.IBM.Data.Db2-ppc : Linux ppc64le

Requesting Trial license

Use contact Owner option in NuGet repository for requesting Db2Connect trial license.
Note: If you are upgrading from any older Db2 .Net NuGet packages to .Net v8.0.0.400 and above, please use v12.1 Db2Connect license.

To verify connection with this package, may execute TestConn utility from Application bin path:

Usage : TestConn "<ConnectionString>" -f "<FileName>" -v

Requesting support

Please reach out to IBM Tech support for any issues in using this package:
https://www.ibm.com/mysupport/s/?language=en_US