Net.IBM.Data.Db2-lnx 9.0.0.400

About

This package is for connecting to IBM Data Servers when connecting from .NET Core applications using .NET 9.

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

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