IBM Support

PI59532: JCC APPLICATION GET SQLCODE4499N IF QUERY INSIDE CALLED SP GETS OFFLOADED TO IDAA AND SP OUTPUTPARM IS DEFINED AS LOB.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • JCC application ERRORCODE=-4499 if query inside a called SP
    gets offloaded to IDAA and SP output parm is defined as LOB.
    ***************************************************************
    Additional Symptoms and Keywords:
     DB2IDAA IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K IDAAV5R1/K
     DB2LOB DB2SP
     SQLCODE -30081 SQLCODE30081 SQL30081N
     ERRORCODE -4499 ERRORCODE4499N SQLSTATE 08001 SQLSTATE08001
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users of the IBM Data Analytics      *
    *                 Accelerator (IDAA).                          *
    *                 DB2 11 for z/OS users only.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following symptoms may occur when   *
    *                      calling a remote stored procedure which *
    *                      offload queries to IDAA.                *
    *                      . CALL statement receives SQLCODE       *
    *                        -30081                                *
    *                      . IBM Data Server Driver for JDBC and   *
    *                        SQLJ Message: Insufficient data.      *
    *                        ERRORCODE=-4499, SQLSTATE=08001       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An application connects to a DB2 11 for z/OS server and calls a
    stored procedure defined with a LOB (datatype is CLOB or BLOB)
    output parameter.  The stored procedure offloads a query to IDAA
    and also sets a return value into the LOB output parameter.
    After the stored procedure finishes, DB2 failed to return the
    LOB output parameter to the calling application due to an
    internal error handling the query offload.  This results in the
    CALL statement receiving SQLCODE -30081, or in the case of IBM
    Data Server Driver for JDBC and SQLJ applications, a Message:
    Insufficient data.  ERRORCODE=-4499, SQLSTATE=08001.
    

Problem conclusion

  • DB2 has been changed to return LOB output parameters for stored
    procedures that perform query offloads.
    

Temporary fix

Comments

  • ×**** PE16/05/20 FIX IN ERROR. SEE APAR PI62727  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PI59532

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-03-22

  • Closed date

    2016-04-11

  • Last modified date

    2016-07-21

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

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

    UI36933

Modules/Macros

  • DSNLXROP
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI36933

       UP16/04/26 P F604

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Document information

More support for: DB2 for z/OS

Software version: B10

Reference #: PI59532

Modified date: 21 July 2016


Translate this page: