PH34544: NEW FUNCTION UPDATE OF DB2 NATIVE RESTFUL SERVICES SUPPORT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New function update of Db2 native RESTful services support.
  
  
  Additional keywords and symptoms:
  ********************************
  DB2REST REST RESTFul DDFREST
  RESTSERVICEDEFAULT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of Db2 for z/OS native RESTful                     *
  * services support.                                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR provides an update to Db2                          *
  * native RESTful services that will                            *
  * allow users to modify the service                            *
  * version to be used as the                                    *
  * "default service version" for a                              *
  * Db2 native REST service.                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The previously delivered Db2 native REST service versioning
  support sets the first created instance of each service as
  being the "default service version".  There is currently no
  supported way for customers to change the default service
  version without having to drop and recreate the REST service
  versions in a different order.  Requiring Database
  Administrators to drop and recreate multiple existing
  production REST services results in unnecessary application
  outages and is making it difficult for users to manage
  Db2 services.
  

Problem conclusion

Temporary fix

Comments

• This APAR delivers a new RESTSERVICEDEFAULT bind option
  which can be used with the REBIND PACKAGE DSN subcommand
  to change the REST service "default service version"
  attribute for an existing Db2 REST service.
  The new RESTSERVICEDEFAULT bind option will ONLY be
  allowed for the REBIND PACKAGE DSN subcommand, and ONLY
  when the package being rebound is a REST service package.
  The general description of the new RESTSERVICEDEFAULT bind
  option is provided in this APAR.  For more information about
  this enhancement and complete documentation of the new
  RESTSERVICEDEFAULT bind option, see the description of this
  APAR in the Db2 for z/OS documentation:
  https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/
  wnew/src/tpc/db2z_12_enhancements.htm
  RESTSERVICEDEFAULT bind option
  ==============================
  The RESTSERVICEDEFAULT(YES) bind option determines that the
  specified REST service package version, as identified by the
  PACKAGE option, will be modified to be the default service
  version for the service.
  This option can only be used when rebinding a "versioned"
  REST service package on the local Db2 system and is
  invalid when used for any other package type.
  Specifically, the REST service package being rebound, as
  specified by the PACKAGE bind option, must specify a valid,
  non-empty string version-id.  In addition, if a
  location-name is specified in the PACKAGE bind option,
  the location-name must be the location name of the local
  Db2 system.
  Usage Notes:
  ============
  If this RESTSERVICEDEFAULT option is specified and the
  package being rebound is not a local, "versioned" REST
  service package, Db2 will issue an error message.
  The RESTSERVICEDEFAULT option is not allowed when using
  asterisk (*) wildcarding for any portion of the package
  name values used in the PACKAGE option.
  Db2 does not perform any validation of REST service
  version compatibility when changing the default service
  version.
  The Db2 REST service versioning support allows each
  version of a REST service to be created using a different
  SQL statement, with different input and output parameters,
  and different bind options.  This means that your REST
  client applications may require code changes to be
  compatible with a new default version of a REST service.
  Db2 does not check or validate REST service version
  compatibility when changing the default service version.
  It is recommended that you compare the JSON request and
  response schemas between the current and new default REST
  service version to determine if there are any incompatible
  differences before changing the default service version of
  a REST service.
  Examples:
  =========
  Rebind existing local REST service package
  MyServices.createCustomer.(v2) to be the default service
  version for the MyServices.createCustomer REST service.
  REBIND PACKAGE("MyServices"."createCustomer".(v2))
     RESTSERVICEDEFAULT(YES)
  Rebind existing local REST service package
  payroll.getEmployee.(v3), which is located at local
  location STLEC1, to be the default service version for
  the payroll.getEmployee REST service.
  REBIND PACKAGE(STLEC1."payroll"."getEmployee".(v3))
     RESTSERVICEDEFAULT(YES)
  

APAR Information

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

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

  UI75327

Modules/Macros

• DSNTBAP  DSNLJDSN DSNLJEMG DSNLJACC DSNLJMUS DSNECP45 DSNFTDIR
  DSNLJECK DSNLXRCS DSNTBCM4 DSNFCDIR DSNTBMSG DSNTBRB2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI75327

     UP21/05/18 P F105

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.