IC90205: CLI IS NOT SENDING A COMMIT IF THE PROCEDURE BODY CONTAINS A EMBEDDED COMMIT.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • Client : V97 FP8
    Server : V10
    autocommit is ON & COMMIT ON RETURN is NO
    The procedure body contains an embedded commit as shown below
    
    UPDATE...
    COMMIT...
    UPDATE....
    OPEN CURSOR...
    
    With the procedure execution, the server will commit all the
    transactions up until the commit.
    However all the other transactions after the commit SQL will not
    be committed by the server.
    It is seen that the client also doesn't send a commit to the
    server. This is a issue.
    
    The above issue is seen for 10.1 as well.
    However the issue is resolved in Kepler as part of the implicit
    commit feature.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V10.5 or later.                               *
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 V10.5.
    CLI WILL SEND A COMMIT IF THE PROCEDURE BODY CONTAINS A
    EMBEDDED COMMIT.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90205

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-14

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

  • 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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC90205

Modified date:

2013-12-17

Translate my page

Machine Translation

Content navigation