IBM Support

JR32635: THE ROLLBACK ACTION OF FEDERATED TWO PHASE COMMIT TRANSACTION FROM DB2 ZOS CLIENT TRANSACTION DOES NOT WORK .

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If the federated two phase commit (F2PC) transaction is from DB2
    zOS client, rollback an update transaction can not work for one
    phase commit (1PC) data source. The DB2 zOS client uses a type 2
    client connection as default; the F2PC transaction rollback can
    work properly against the two phase commit (2PC) data source,
    but can not work for 1PC data source. For 1PC data source,
    committing a transaction is used to end a transaction, which
    causes the rollback problem.
    Commit or rollback is taken according to the transaction intend
    to commit or rollback, which can make the F2PC transaction
    rollback work properly for both 1PC and 2PC data sources.
    
    Note: if the data source is defined as a federated two-phase
    commit data source, even if all updates of a transaction occur
    on a single data source, then it goes through federated two
    phase commit processing.? This may have potential performance
    impact on federation sever.
    

Local fix

  • Turn on two phase phase commit if possible.
    alter server <server name> options (DB2_TWO_PHASE_COMMIT 'Y')
    

Problem summary

  • Users affected:
       Users of the DB2 for LUW Homogeneous Federation Feature or
    InfoSphere Federation Server
    Problem description and summary:
       See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9.5 FixPak 5 (s091123 ). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32635

  • Reported component name

    FEDERATED RUNTI

  • Reported component ID

    5724N9703

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-08

  • Closed date

    2009-12-22

  • Last modified date

    2009-12-22

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

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

    JR32770

Fix information

  • Fixed component name

    FEDERATED RUNTI

  • Fixed component ID

    5724N9703

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
22 December 2009