IBM Support

IC94466: RETURN ERROR WHEN MULTI-TRANSPORT TM ATTEMPTS TO XACOMMIT/XAROLLBACK WHEN THERE IS WITH-HOLD CURSOR IN USE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Currently DB2 does not support cursors defined with option to
    maintain resources across multiple units of work - 'WITH HOLD'
    attribute, when using TM with multi-transport port model like
    Tuxedo. The DB2 however returns OK without any action if
    xacommit/xarollback is actually attempted by such TM and
    with-hold cursor is in use.
    
    This APAR is to change the behaviour to return XAER_RMERR back
    to TM on xacommit/xarollback instead of OK, so the incorrect
    configuration can be caught earlier. In addition to that the DB2
    will log message into db2diag.log informing about unsupported
    configuration.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * XA users.                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Please See Error Description.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please See Error Description.                                *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC94466

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-30

  • Closed date

    2013-10-02

  • Last modified date

    2013-10-02

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

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

    IC96360 IC96685

Fix information

Applicable component levels

  • R970 PSN

       UP

  • RA10 PSN

       UP

  • RA50 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC94466

Modified date: 02 October 2013