IBM Support

IZ58007: JCC DOES NOT SEND A COMMIT WHEN A Z/OS STORED PROCEDURE OR BATCHED QUERY RESULTSET EARLY CLOSES AND AUTOCOMMIT IS TRUE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The IBM Data Server Driver for JDBC and SQLJ (JCC driver) with
    early close does not flow the commit when the last resultset for
    a Z/OS stored procedure or a batched query resultset is closed
    and Autocommit has been set to true.
    

Local fix

Problem summary

  • Users Affected: JCC application users going to Z/OS
    databases.
    
    Problem Description:
    The IBM Data Server Driver for JDBC and SQLJ (JCC driver)
    with early close does not flow the commit when the last
    resultset for a Z/OS stored procedure is closed and Autocommit
    has been set to true.
    
    Problem Conclusion:
    The IBM Data Server Driver for JDBC and SQLJ (JCC driver)
    with early close does not flow the commit when the last
    resultset for a Z/OS stored procedure is closed and Autocommit
    has been set to true.
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 5.
    
    The Fix Pack should be applied to the client
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ58007

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-08-12

  • Closed date

    2009-12-21

  • Last modified date

    2009-12-21

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

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

    IZ58008 IZ58014

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R950 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950"}]

Document Information

Modified date:
03 October 2021