Global Data Management Forum

 View Only
Expand all | Collapse all

I have updated Db2 drivers from v1.3.0.100 to 6.0.0.300 due to enforced .NET upgrade to v6.0 and getting "IBM.Data.Db2.DB2Exception (0x80004005): ERROR [42968] [IBM] SQL1598N An attempt to connect to the database server failed because of a licensing"

  • 1.  I have updated Db2 drivers from v1.3.0.100 to 6.0.0.300 due to enforced .NET upgrade to v6.0 and getting "IBM.Data.Db2.DB2Exception (0x80004005): ERROR [42968] [IBM] SQL1598N An attempt to connect to the database server failed because of a licensing"

    Posted Mon April 17, 2023 09:32 AM

    For my customer, due to the lack of support for .Net 2, I have upgraded all their services to .NET 6 and for this reason I also had to upgrade Db2 drivers.

    I replaced "IBM.Data.DB2.Core-lnx" Version="1.3.0.100" with "Net.IBM.Data.Db2-lnx" Version="6.0.0.300" and adjusted the code to the new namespaces. Everything nicely compiles.

    But it does not work in a docker container after the upgrade.

    We are getting the following error:

    "IBM.Data.Db2.DB2Exception (0x80004005): ERROR [42968] [IBM] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968"

    I've made sure that the existing licence is still there in the right folder.

    I also tried putting the licence in the folders recommended here:

    https://community.ibm.com/community/user/datamanagement/blogs/vishwa-hs1/2020/07/12/db2-net-packages-download-and-configure

    by adding the following lines to Dockerfile:

    COPY Src/AuroraExport/db2consv_is.lic $HOME/.nuget/packages/net.ibm.data.db2-lnx/6.0.0.300/buildTransitive/clidriver/license/

    ENV DB2_CLI_DRIVER_INSTALL_PATH="$HOME/.nuget/packages/net.ibm.data.db2-lnx/6.0.0.300/buildTransitive/clidrive"

    ENV LD_LIBRARY_PATH="$HOME/.nuget/packages/net.ibm.data.db2-lnx/6.0.0.300/buildTransitive/clidriver/lib:$HOME/.nuget/packages/net.ibm.data.db2-lnx/6.0.0.300/buildTransitive/clidriver/lib/icc"

    ENV PATH=$PATH:"$HOME/.nuget/packages/net.ibm.data.db2-lnx/6.0.0.300/buildTransitive/clidriver/bin:$HOME/.nuget/packages/net.ibm.data.db2-lnx/6.0.0.300/buildTransitive/clidriver/lib:$HOME/.nuget/packages/net.ibm.data.db2-lnx/6.0.0.300/buildTransitive/clidriver/adm"

    and still getting the same error.

    I believe the licence we used with .NET 2 is still correct, it expires only in 2037.

    Here are a few non-sensitive parts of the licence - please let me know if you see any problems here:

    [LicenseCertificate]

    ...

    ProductName=DB2 Connect Unlim Ed iSeries

    ProductID=1411

    ProductVersion=11.1

    LicenseStartDate=02/15/2016

    LicenseDuration=7991

    LicenseEndDate=12/31/2037

    ...

    Please help, it's a very critical issue as the import/export features stopped working in production.



    ------------------------------
    Lukasz Szkup
    ------------------------------


  • 2.  RE: I have updated Db2 drivers from v1.3.0.100 to 6.0.0.300 due to enforced .NET upgrade to v6.0 and getting "IBM.Data.Db2.DB2Exception (0x80004005): ERROR [42968] [IBM] SQL1598N An attempt to connect to the database server failed because of a licensing"

    IBM Champion
    Posted Tue April 18, 2023 08:26 AM

    Hi Lucasz,

    Your upgraded drivers are likely version 11.5 but your license below is for 11.1

    Log on to IBM Passport Advantage (or ask your software license admins) and download the license activation kit for Db2 Connect unlimited edition. It contains a .lic file for 11.5



    ------------------------------
    Jørn Thyssen
    Principal Solutions Advisor
    Rocket Software
    ------------------------------



  • 3.  RE: I have updated Db2 drivers from v1.3.0.100 to 6.0.0.300 due to enforced .NET upgrade to v6.0 and getting "IBM.Data.Db2.DB2Exception (0x80004005): ERROR [42968] [IBM] SQL1598N An attempt to connect to the database server failed because of a licensing"

    Posted Tue April 18, 2023 09:00 AM

    The license information you have provided here is for product version 11.1 you now require a new license for product version 11.5. 

    From the Nuget package in the version folder I see 11.5 as the version of the db2 driver.


    <?xml version="1.0" encoding="UTF-8"?>
    <SoftwareIdentity name="IBM Data Server Driver for ODBC and CLI" tagId="ibm.com-6c595317370547be91661b78bedb6ad6-11.5.0" version="11.5.0" versionScheme="multipartnumeric" xml:lang="en" xmlns="http://standards.iso.org/iso/19770/-2/2015/schema.xsd" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://standards.iso.org/iso/19770/-2/2015-current/schema.xsd schema.xsd">
        <Meta persistentId="6c595317370547be91661b78bedb6ad6"/>
        <Meta generator="4-1-20200120"/>
        <Entity name="IBM" regid="ibm.com" role="licensor tagCreator softwareCreator"/>
    </SoftwareIdentity>



    ------------------------------
    Will Smith
    ------------------------------



  • 4.  RE: I have updated Db2 drivers from v1.3.0.100 to 6.0.0.300 due to enforced .NET upgrade to v6.0 and getting "IBM.Data.Db2.DB2Exception (0x80004005): ERROR [42968] [IBM] SQL1598N An attempt to connect to the database server failed because of a licensing"

    Posted Wed April 19, 2023 09:07 PM
    Thank you everyone for your input. That's very helpful!

    Kind regards,
    Lukasz