IBM Support

IT37446: CLR PROCEDURE ABORTS ABNORMALLY WITH ERROR SQL1024N WHEN IT USESIBM.DATA.DB2 .NET provider

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • CLR procedure aborts abnormally when it use IBM.Data.DB2,
    IBM.Data.DB2.dll is a .NET provider/API for connecting to
    database, CLR procedure works fine if it doesn't use
    IBM.Data.DB2.
    The error is database connection failure in DB2ConnPool.Open
    
    
    IBM.Data.DB2.DB2Exception: ERROR [08003] [IBM] SQL1024N  A
    database connection does not exist.  SQLSTATE=08003
       at IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection,
    String& szConnectionString, DB2ConnSettings& ppSettings, Object&
    ppConn)
       at IBM.Data.DB2.DB2Connection.Open()
       at IBM.Data.DB2.DB2Connection.OpenNull(DB2ContextInternal
    context)
       at IBM.Data.DB2.DB2Context.DB2ContextInternal.GetCommand()
       at IBM.Data.DB2.DB2Context.GetCommand()
    
    
    
    
    As long as customer use .NET API in their CLR procedure, they
    will be impacted. Customers using C or java interface might also
    be impacted.
    This will result in procedure execution failure and db2fmp will
    be terminated and recreated.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 Connect .NET users                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V11.1.4.7 or later                                *
    ****************************************************************
    

Problem conclusion

  • Problem fixed in V11.1.4.7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT37446

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-06-29

  • Closed date

    2022-02-28

  • Last modified date

    2022-02-28

  • APAR is sysrouted FROM one or more of the following:

    IT36757

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022