PH54701: DB2XML.HTTPGETCLOB MAY RETURN SQLCODE -4302

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the server returns http code 401(Unauthorized), the
  Content-Length is 0. This causes the getHttpErrorStream to
  return null. The httpGetClob does not handle the null pointer
  correctly and throws NullPointerException and may return SQLCODE
  -4302.
  
  ADDITIONAL SYMPTOMS:
  SQLCODE4302 SQLUDF DB2INCORR/K INCORROUT SQLINCORR SQLINCORROUT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 for z/OS users of HTTPGETCLOB and                    *
  * HTTPGETBLOB REST UDFs                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The HTTPGETCLOB and HTTPGETBLOB UDFs                         *
  * might return SQLCODE-4302 with                               *
  * java.lang.NullPointerException.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When the responseMsgFormat="errorTagged" is specified in the
  httpHeader attribute and the server returns a http error return
  code, the HTTPGETCLOB and HTTPGETBLOB UDFs will return
  - SQLCODE 0
  - The error message from the server, in the following format:
    <error httprc="{HTTP-status-code}">
      {error-message-returned-from-server}
    </error>
  In the case that the server response does not include the error
  message, the NullPointerException will occur.
  

Problem conclusion

• Db2 is modified to handle the empty error message case
  correctly.
  

Temporary fix

Comments

APAR Information

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

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

  UI93325 UI93326

Modules/Macros

• DSNTJRF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI93325

     UP23/09/06 P F309

• RD10 PSY UI93326

     UP23/09/06 P F309

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.