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,
Post an idea
Upvote ideas that matter most to you
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
Hi!
The answer to question 1 is an emphatic yes. It is a typical REBIND Scenario - If I rebind, will it kill me in production? yes or no. With RESTFul services, as of now, you must jump off of the cliff without checking for your parachute!
The answer to question 2 is also an emphatic yes! This is a typical BIND Scenario. You change one tiny thing in your SQL, that requires a BIND of course, but you would still like to "try out" the Access Path before it goes live. The Db2 Optimizer is very clever indeed and it sees that you are in Spufi doing an explain or you are BINDing a static SQL for batch and gives different access paths.
So with both of these things supported it would bring RESTful completely up to par with normal SQL!
Many thanks!
Roy
Hi Roy, Db2 for z/OS Development has a few more questions for you regarding this request:
Is this request for access paths for native REST services that already exist? If that is what's being asked, if Db2 were to allow REBIND PACKAGE() EXPLAIN(ONLY) against an existing native REST service package, would that satisfy the request?
Is there any requirement for EXPLAIN(ONLY) of a native REST service which does not exist? For example, BIND SERVICE() NAME() EXPLAIN(ONLY) would populate the explain tables without actually creating the service.
Please let us know. Thanks!
Hi!
As I wrote the TYPE column is wrong but I do not really card about that...
The pain point is the missing EXPLAIN(ONLY). For any static package you can issue an EXPLAIN(ONLY) to get a full explain of the all the statements within. You cannot do this for restful services which is a serious loss of functionality.
Cheers
Roy
Hello Roy, The Db2 for z/OS development team reviewed this enhancement request and has the following feedback for you:
There are at least 2 features being requested.
Adding a new special catalog SYSPACKAGE TYPE value for REST packages, is declined.
"Make restful services the same as static packages" - this is a general statement. Can you identify other items that you think are lacking or are missing from our native rest services?
Can you modify this idea, or add an idea for the EXPLAIN(ONLY) function to ensure clarity on the expectation of what we'd consider delivering?
Thank you,
The Db2 for z/OS Development team