IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Add a new idea Subscribe
Status Delivered
Workspace Db2 for z/OS
Created by Guest
Created on Jun 21, 2021

RELATED IDEAS

Alias for REST Services

Db2 REST services, with versioning enabled, sets the first service created via the BIND SERVICE command to be the default service.

at this stage the URL and the REST service are in sync and the URL need not reference the version as DB2 will invoke the default version anyway e.g.

rest service: INVOKE_A_REST_SERVICE (V1 - and this is the default version)

URL: http://domain/services/qual/INVOKE_A_REST_SERVICE


if we need to change the rest service and a new version is created say e.g. V2

NOW to be able to invoke this we have to now change the URL to:

URL: http://domain/services/qual/INVOKE_A_REST_SERVICE/V2

if V2 is not used then DB2 will invoke the V1 which is the default.


this means that the URL now needs to be changed wherever it is being used and this could be multiple applications which may be owned by various diff teams etc.


to avoid the application change we either free the old version OR manually update the ISDEFAULT column in DSNSERVICE table (this is not documented and I assume not supported).


another pain point is the version could be a string of characters (site specific e.g. date, ts based etc). these characters are in most cases meaningless to the applications that only want to call a named REST service e.g.

URL: http://domain/services/qual/INVOKE_A_REST_SERVICE/V2 (V2 does not add any value to the URL from the application perspective)

another e.g. here could be:

URL: http://domain/services/qual/INVOKE_A_REST_SERVICE/V2.ABCDEF.TS1

Needed by Date Oct 1, 2021
  • Admin
    Janet Figone
    Reply
    |     Sep 9, 2021

    Hi Dhirendra, Very sorry for the confusion. Here is the correct APAR information

    PH34544: NEW FUNCTION UPDATE OF DB2 NATIVE RESTFUL SERVICES SUPPORT

    ****************************************************************
    * 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.                                     *
    ****************************************************************
  • Guest
    Reply
    |     Jul 1, 2021

    hi Janet,

    the APAR mentioned talks about FTBs for non unique indexes.

    "With APAR PH30978 applied, Db2 12 at function level 508 or higher now supports fast index traversal (FTB) for non-unique indexes."

    Is this the correct APAR or does this APAR deliver more than FTB enhancements

  • Admin
    Janet Figone
    Reply
    |     Jun 30, 2021

    We are pleased to inform you this idea is solved but using a different approach than what was suggested. Please refer to Aha! idea DB24ZOS-I-951 for details, and APAR PH30978 which sets the default version of a REST service. Thank you.

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.