IBM Support

IC64539: SQLSETSTMTATTRW(SQL_ATTR_CHAINING_END) RETURNS 0, EVEN WHEN ONE OF THE PREVIOUS CHAINED STATEMENTS FAILED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In a CLI application several actions can be chained together.
    When one of these actions fail, the ending
    SQLSetStmtAttrW(SQL_ATTR_CHAINING_END) should not return with a
    SQL_SUCCESS (return status=0).
    
    For example, consider the following scenario:
    A SQLExecute() fails with SQL0911 deadlock and the server rolls
    back the the transaction. Since this is never reported back, the
    application continues the current transaction. This way, we can
    end up with a partially written transaction, leading to data
    loss and/or logical data inconsistency.
    
    In addition, the SQLRowCount() will report a wrong value after a
    partially committed transaction.
    

Local fix

Problem summary

  • USERS AFFETCED:
    All
    
    PROBLEM DESCRIPTION:
    See ERROR DESCRIPTION
    
    PROBLEM SUMMARY:
    See ERROR DESCRIPTION
    

Problem conclusion

  • Problem was first fixed in Version 9.1 Fix Pack 9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC64539

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-13

  • Closed date

    2010-04-16

  • Last modified date

    2010-12-11

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

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

    IC64540 IC64541 IC64680

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

  • R970 PSN

       UP

  • R980 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1"}]

Document Information

Modified date:
16 September 2021