IBM Support

IC64540: 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 AFFECTED:
    All
    
    PROBLEM DESCRIPTION:
    See ERROR DESCRIPTION
    
    PROBLEM SUMMARY:
    See ERROR DESCRIPTION
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC64540

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-13

  • Closed date

    2009-12-15

  • Last modified date

    2010-12-11

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

    IC64539

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

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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 December 2010