IBM Support

IC99203: ADO .NET PROGRAM CRASHES WITH ACCESS VIOLATION ERROR IN A MULTI-THREADED PROGRAM FOR MULTI ROW INSERT.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • .NET DRIVER CRASHES WITH FOLLOWING ERROR IN A MULTI-THREADED
    PROGRAM NAMED ORCAS.EXE USING MULTI ROW INSERT FEATURE:
    
    Unhandled Exception: System.AccessViolationException: Attempted
    to read or write
     protected memory. This is often an indication that other memory
    is corrupt.
       at
    IBM.Data.DB2.UnsafeNativeMethods.DB232.SQLExecDirectADONET(DB2Ex
    ecDirectPa
    rameters* pParam)
       at IBM.Data.DB2.DB2Command.ExecuteNonQueryObject(Boolean
    skipInitialValidatio
    n)
       at IBM.Data.DB2.DB2Command.ExecuteNonQueryObject()
       at IBM.Data.DB2.DB2Command.ExecuteNonQuery()
       at Orcas.TestOrcas.MultiRowInsert(DB2Connection conn) in
    c:\svtwkld\OrcasAppl
    \TestOrcas.cs:line 698
       at Orcas.TestOrcas.startSelect() in
    c:\svtwkld\OrcasAppl\TestOrcas.cs:line 19
    2
       at
    System.Threading.ExecutionContext.RunInternal(ExecutionContext
    executionCo
    ntext, ContextCallback callback, Object state, Boolean
    preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext
    executionContext, C
    ontextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext
    executionContext, C
    ontextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * .NET driver users using array insert in a multi-threaded     *
    * application.                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v97fp10 or later releases.                    *
    ****************************************************************
    

Problem conclusion

  • db2_v97fp10 contains the fix of this issue. After the fix, no
    crash has been observed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC99203

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-06

  • Closed date

    2014-11-10

  • Last modified date

    2014-11-10

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

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

    IC99205 IC99206

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC99203

Modified date: 10 November 2014