IBM Support

IZ64929: JCC DISCONNECTEXCEPTION ACTUAL CODE POINT, 47 DOES NOT MATCH EXPECTED CODE POINT, 9224 ON CALL TO DB2/Z STORED PROCEDURE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When calling a stored procedure defined on DB2 z/OS with COMMIT
    ON RETURN YES, the DB2 JCC driver may return either of the
    following Exceptions:
    
    com.ibm.db2.jcc.a.DisconnectException: Actual code point, 47
    does not match expected code point, 9224
    
    or:
    
    com.ibm.db2.jcc.a.DisconnectException: Actual code point, 0x2f
    does not match expected code point, 0x2408.
    
    This exception indicates that following the commit request
    (CMMRQSRM) in the stored procedure at the host, the JCC driver
    is expecting to receive an SQLCARD code point, but is instead
    receiving a TYPDEFNAM.
    
    In this particular scenario, the absence of the SQLCARD
    is a valid response from the DB2 z/OS host and needs to be
    accounted for by the JCC driver.
    

Local fix

  • Define the stored procedure on the host with COMMIT ON RETURN
    NO.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 z/OS stored procedures defined with COMMIT ON RETURN YES *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When calling a stored procedure defined on DB2 z/OS with     *
    * COMMIT ON RETURN YES, the DB2 JCC driver may return either   *
    * of the following Exceptions:                                 *
    *                                                              *
    *                                                              *
    *                                                              *
    * com.ibm.db2.jcc.a.DisconnectException: Actual code point, 47 *
    * does not match expected code point, 9224                     *
    *                                                              *
    *                                                              *
    *                                                              *
    * or:                                                          *
    *                                                              *
    *                                                              *
    *                                                              *
    * com.ibm.db2.jcc.a.DisconnectException: Actual code point,    *
    * 0x2f does not match expected code point, 0x2408.             *
    *                                                              *
    *                                                              *
    *                                                              *
    * This exception indicates that following the commit request   *
    * (CMMRQSRM) in the stored procedure at the host, the JCC      *
    * driver is expecting to receive an SQLCARD code point, but is *
    * instead receiving a TYPDEFNAM.                               *
    *                                                              *
    *                                                              *
    *                                                              *
    * In this particular scenario, the absence of the SQLCARD is a *
    * valid response from the DB2 z/OS host and needs to be        *
    * accounted for by the JCC driver.                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.5 FP5, or define the stored procedure on    *
    * DB2 z/OS as COMMIT ON RETURN NO.                             *
    ****************************************************************
    

Problem conclusion

  • DB2 9.5 FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ64929

  • Reported component name

    DB2 CUE ISERIES

  • Reported component ID

    5724M1500

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-11

  • Closed date

    2010-04-19

  • Last modified date

    2010-04-19

  • 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 CUE ISERIES

  • Fixed component ID

    5724M1500

Applicable component levels

  • R950 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 950

Reference #: IZ64929

Modified date: 19 April 2010