IBM Support

IC78331: SQL0751N WHEN A JCC APPLICATION CALLS A STORED PROCEDURE WITHIN AN XA TRANSACTION, 1- PHASE COMMIT USING TYPE 4 JCC DRIVER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When a JCC application utilizing DB2 V9.7 Type 4 JCC driver,
    invokes a stored procedure running on DB2 z/OS within an XA
    transaction using single phase commit, the driver is
    supposed to flow RDBCMTOK=TRUE, but it incorrectly
    flows RDBCMTOK=FALSE indicating that the driver doesn't allow
    the SQL statement to commit resulting in SQL0751N (Routine
    routine-name(specific name specific-name) attempted to execute a
    statement that is not allowed)
    

Local fix

Problem summary

  • Fixed in IBM Data server driver for JDBC& SQLJ for DB2 on LUW
    V9.7 Fix Pack 7.
    

Problem conclusion

  • Upgrade to IBM Data server driver for JDBC& SQLJ for DB2 on LUW
    V9.7 Fix Pack 7 or above.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC78331

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-30

  • Closed date

    2014-04-04

  • Last modified date

    2014-04-04

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

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

    IC78921 IC78928

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78331

Modified date: 04 April 2014