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
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-06-29
Closed date
2021-10-25
Last modified date
2021-10-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 CONNECT
Fixed component ID
DB2CONNCT
Applicable component levels
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"10.1"}]
Document Information
Modified date:
26 October 2021