PI74515: SERVICE UPDATE OF DB2 12 NATIVE RESTFUL SERVICES 17/04/21 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2REST
  See PI74409 for DB2 11 for z/OS.
  Multiple improvements to the RESTful services support in DB2
  are being delivered.
  The following abends during RESTful services
  may occur
  04E-00D31010 DSNLILLM.DSNLIRTR 0033
  **************************************************************
  Additional Symptoms and Keywords:
   ABEND0C4 AB0C4 S00C4 0C4
    0C4-00000038 00000038 RC00000038
    0C4-0000003A 0000003A RC0000003A
     DSNLIRTR DSNLIRTR+00C34 00C34 OFFSET00C34
   ABEND04E AB04E S004E 04E
    04E-00D31010 00D31010 RC00D31010
     DSNLIRTR DSNLIRTR:0009 0009 VRADC0009 ABID0009
              DSNLIRTR:0033 0033 VRADC0033 ABID0033
    04E-00D35011 00D35011 RC00D35011
     DSNLZD00 DSNLZD00:0015 0015 VRADC0015 ABID0015
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of DB2 12 for z/OS planning to use DB2 native      *
  * RESTful services support.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Update to the DB2 12 native RESTful services support.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR provides a service update to the DB2 12 native RESTful
  services support.  In particular, this service update APAR
  addresses the following reported issues:
  - Possible ABEND 0C4,LOC=DSNLILLM.DSNLIRTR+00C34 when an
    incoming request is terminated/closed by the client with less
    then six (6) bytes being sent.  It is believed that this
    condition may be triggered by specific program behavior,
    such as network security port scanners.
  - ABEND 04E-00D31010, LOC:DSNLIRTR:0009 due to a failure during
    the WLM classification of a REST service call.  The WLM
    classify failure is caused by an incorrect value being used
    for the Procedure Name parameter.
  - ABEND 04E-00D31010, LOC:DSNLIRTR:0033 when attempting to
    create or drop a native REST service, and the input JSON
    message body contains JSON syntax errors.  The expected
    native REST response should be an error message reply
    instead of a DB2 abend.
  - Possible ABEND 04E-00D35011, LOC=DSNXGRDS.DSNLZD00:0015
    during the native REST internal describe service processing,
    caused by an uninitialized field in a DB2 internal control
    block (that was passed by module DSNLJACC).
  - The DB2 native REST service JSON parser is incorrectly mapping
    input string values of "null", "true", and "false", to the
    JSON special values of null, true, and false, respectively.
    This incorrect mapping of the input string values of "null",
    "true", and "false" by the JSON parser can result in
    incorrect input or output results (incorrout).
    To illustrate the problem, consider an input a JSON message
    body key/value pair consisting of the key "COL1" and a value
    that is the string "null", which would be represented as:
    { "COL1" : "null" }
    The DB2 native REST service JSON parser was incorrectly
    treating this example input JSON "null" string as having the
    value of JSON null.  In other words, it was incorrectly
    treating the input as if it was written as:
    { "COL1" : null }
    This incorrect JSON parser behavior would result in the
    "COL1" input having the incorrect value of SQL NULL, instead
    of the correct value of SQL character 'null'.
  

Problem conclusion

• The following changes have been made to address these problems:
  - Logic has been changed to no longer attempt to access the
    message buffer storage once the socket/connection has been
    terminated.
  - Logic has been changed to pass the expected null Procedure
    Name parameter for REST service WLM classification.
  - Syntax errors in the input JSON message body when creating
    or dropping a native REST service will now generate an
    appropriate "JSON message body contains a syntax error" reply
    message.
  - Logic has been changed to correctly initialize DB2 internal
    control block fields.
  - The DB2 native REST JSON parser logic has been changed to
    correctly distinguish between JSON input string values
    of "null", "true", and "false" and the JSON null, true,
    and false values.
  The DB2 Information APAR II14827 MUST be reviewed for
  any IMPORTANT additional documentation, and any known
  limitations or restrictions related to the DB2 native REST
  services support.
  

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:

  UI44784

Modules/Macros

• DSNLJSSG DSNLIRTR DSNLJDSC DSNLJSPS DSNLJMUS DSNLJEMG DSNLJSSP
  DSNLJXUS DSNLJGUS DSNLJACC DSNLCBFM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI44784

     UP17/03/15 P F703

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.