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

Obtain the fix for this APAR.

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 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.