PH14688: DB2 NATIVE REST NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 Native RESTFul Services enhancement.
  ***************************************************************
  Additional Symptoms and Keywords:
   DB2REST Epic 80922 e80922 Epic80922
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of DB2 for z/OS native RESTful                     *
  * services.                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR provides updates to DB2                            *
  * native RESTful services to allow the                         *
  * promotion of services from a                                 *
  * development to a production                                  *
  * environment.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  This APAR adds the new options COPY, COPYVER, and OPTIONS to
  the DSN BIND SERVICE subcommand.  These new options allow a
  user to copy existing REST services to local or remote Db2
  servers.
  
  Before you begin:
  - See BIND SERVICE (DSN) for information about required
    authorization to issue the BIND SERVICE subcommand.
    Additionally, you must hold the COPY privilege or its
    equivalent at the local server.
  - The local server must be at least Db2 12 with REST services
    versioning enabled.
  - When copying to another location, the remote server must be
    at least Db2 12 with REST services versioning enabled.
  - Only versioned services can be copied.  Copying of
    version-less services is unsupported.
  
  Procedure:
  To copy a REST service, specify the new collection-id using the
  SERVICE option.  Use the COPY and COPYVER options to specify
  the collection-id, service name, and version-id of an existing
  REST service you want to copy from.  Other bind options may be
  optionally specified, see BIND SERVICE (DSN) for more options
  information.
  
  Examples:
  To copy the existing REST service "simpleTests"."simpleSelect1"
  with a version-id of V1, to another collection-id "finalTests"
  on the local server, issue the following DSN subcommand.
  
    BIND SERVICE("finalTests")
    COPY("simpleTests"."simpleSelect1")
    COPYVER(V1)
  
  The following example copies the existing REST service
  "payroll"."getEmployeeSalary" with a version-id of Ver2, to a
  remote server with the location-name PRODSYS.  The new service
  has the same collection-id as the original service.  The
  QUALIFIER option is also specified for the new service which
  determines the implicit qualifier for unqualified names of
  tables, views, indexes, and aliases contained in the service
  created on the PRODSYS system.  Lastly, the DESCRIPTION option
  is used to describe the newly copied service.
  
    BIND SERVICE(PRODSYS."payroll")
    COPY("payroll"."getEmployeeSalary") COPYVER(Ver2)
    QUALIFIER(PRODQUAL)
    DESCRIPTION('This is the PRODSYS copy of getEmployeeSalary')
  

Problem conclusion

• This APAR adds the new options COPY, COPYVER, and OPTIONS to
  the DSN BIND SERVICE subcommand to enable the promotion of
  services from a development to a production environment.
  Refer to the Db2 for z/OS documentation in the IBM Knowledge
  Center for complete information about the updated Db2 native
  REST services support.
  

Temporary fix

Comments

• This APAR adds the new options COPY, COPYVER, and OPTIONS to
  the DSN BIND SERVICE subcommand to enable the promotion of
  services from a development to a production environment.
  Refer to the Db2 for z/OS documentation in the IBM Knowledge
  Center for complete information about the updated Db2 native
  REST services support.
  

APAR Information

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

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

  UI65644

Modules/Macros

• DSNLJDSN DSNECP54 DSNTBAPM DSNLJACC DSNTIAM  DSNTBAS2 DSNLXRCM
  DSNFCDIR DSNLXRCS DSNLJEMG DSNFTDIR DSNEMTXT DSNTBCM5 DSNTBAP1
  DSNTBCM  DSNTBCM4 DSNTBCM2 DSNECP48 DSNECP49 DSNLJMUS DSNTBAP
  DSNTBMSG DSNTBAR  DSNTBAS  DSNLXRUW DSNTAC1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI65644

     UP19/10/17 P F910

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.