IBM Support

IT35681: CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When array input statements are executed through chaining and if
    first record in chaining cause any error (Ex; -803) then any
    subsequent errors are skipped which are received after executing
    rest of statements in chaining.
    
    Example:
    when multiple processes run INSERT ? ACCEPTING DUPLICATE KEYS
    statements in parallel and get deadlocked, the deadlock SQL
    error is not returned by CLI, Therefore the application is
    unaware of the implicit rollback, reporting false info to the
    user.
    From a user's perspective, this is data loss. From the db2
    traces, the server sends the SQL0911N or SQL1476N/911, but the
    same is not returned to the application
    This scenario can happen when the first record in the chain
    caused an error e.g:-803 at the server and hence subsequent
    errors like -911 that might be hit in certain scenarios are not
    reported back to the application.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL Db2 Connect Users                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v11.1.4.6 and later                               *
    ****************************************************************
    

Problem conclusion

  • Fixed in v11.1.4.6 and later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT35681

  • 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-01-25

  • Closed date

    2021-06-30

  • Last modified date

    2021-06-30

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

    IT35521

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

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"11.1"}]

Document Information

Modified date:
04 May 2022