IBM Support

IZ21339: JCC DRIVER RETURNS XAER_PROTO

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • JCC driver returns XAER_PROTO for subsequent SQL statements
    after receiving -911 or -913 in the same global transaction.
    
    XA Start
    SQL 1 ----> Success
    SQL 2 ----> Receive -911
    SQL 3 ----> Success
    XA End (TMSUCCESS) ---> server is returning XAER_PROTO
    
    Correct behaviour is for JCC driver to block subsequent SQL
    statements after failing with -911 (deadlock) or -913
    (unsuccessful execution caused by deadlock/timeout)
    

Local fix

Problem summary

  • SEE ERROR DESCRIPTION.
    

Problem conclusion

  • Problem was first fixed in JCC driver v3.8.35 included with v9.1
    Fixpak 6 (s081007).  At minimum this fix should be applied to
    the client.
    

Temporary fix

  • SEE LOCAL FIX.
    

Comments

APAR Information

  • APAR number

    IZ21339

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-04-30

  • Closed date

    2009-11-06

  • Last modified date

    2009-11-06

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

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

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 November 2009