IBM Support

IT35521: 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:                                              *
    * Db2 CLI users executing chaining                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.5.5.1 or higher                            *
    ****************************************************************
    

Problem conclusion

  • CLI correctly reports the errors received while executing
    chaining end and do not skip reporting the errors to
    application.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT35521

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-01-14

  • Closed date

    2021-04-06

  • Last modified date

    2021-04-06

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

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

    IT35681

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RB50 PSN

       UP

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

Document Information

Modified date:
31 August 2021