IBM Support

IT03661: SQL0911N when statement contains an embedded SELECT despite CLI/ODBC "CONCURRENTACCESSRESOLUTION" KEYWORD

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • With database configuration CUR_COMMIT set to AVAILABLE and
    IBMᄅ Data Server Provider for .NET (DB2 .NET provider)
    connection string with keyword ConcurrentAccessResolution set to
    Currentlycommitted
    or
    DB2ᄅ Call Level Interface (DB2 CLI) driver with configuration
    keyword ConcurrentAccessResolution set to "1" ("currently
    committed")
    an application will abnormally terminate with the following
    query
    if there is an uncommitted update on table yyy:
    
    INSERT INTO xxx (SELECT , , FROM yyy)
    
    The error message is:
    SQL0911N  The current transaction has been rolled back because
    of a deadlock or timeout.  Reason code "68".
    
    This APAR will address this behavior and allow the driver to
    send the attribute when there are embedded Selects.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 10                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT03661

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-08-08

  • Closed date

    2015-01-29

  • Last modified date

    2015-01-29

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

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

    IT06637 IT06638

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT03661

Modified date: 29 January 2015