IBM Data and AI Ideas Portal for Customers


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:

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


Status Not under consideration
Workspace Db2 for z/OS
Created by Guest
Created on May 20, 2021

New ZPARM for SYSTIMESENSITIVE Bind Option

Please reference CASE TS005056787 (Temporal Table access path in Plan_Table does not match dynamic explain). This bind option which is set for using a Temporal Timestamp Register was set with a DEFAULT to YES by IBM for all binds that exclude this Option, which for us is ALL of our static binds.

Recently we experienced many False negatives when using pathchecker and running our own home grown reports that read from our system level PLAN_TABLE that all of our packages explain data ends up. Our reports are showing misleading scans, index usage on Temporal History tables when a query CLEARLY DOES NOT access the temporal history data because it DOES NOT use the AS OF timestamp ....... in the query.

With this option set to YES, The DBRM will show two instances of the SQL statement for the exact same QUERYNO (one for base temporal and one for History temporal access) whether or not the query references the History temporal data.

Anyway, if you read through the referenced CASE, we are requesting for a ZPARM to allow the CLIENT to decide what the default for this Bind option should be, not IBM. The client best knows how this register will be or will NOT be used in their shop.


Bottom line, is the work around was NOT easy to change this bind option in ALL of our static programs referencing Temporal tables. A Mass rebind was NOT feasible as we found out that in order to change this option in a mass rebind, we need to TURN OFF PLANMGMT, which is not an option for us. So the only way we were able to do this is to work with our Changeman team to have them put in a change to force this option to NO for any program compiles/binds as they are changed for upcoming application releases. this is not a fast solution, but the only one we that was feasible for us to use.

IBM has been involved in this discussion in detail and recommended the same, that we open an AHA to get this ZPARM created for SYSTIMESENSITIVE Bind option.

Needed by Date Jun 30, 2021
  • Admin
    Janet Figone
    Sep 3, 2021

    Thank you for submitting this Db2 for z/OS enhancement request.

    After giving the request a comprehensive review, we have determined that we cannot include it as a candidate in an upcoming product deliverable because it is not consistent with the product direction planned within the next 24 month forecast. Consequently, we will not be implementing this request.

    We appreciate your input to the Db2 for z/OS development team. We also hope that you will continue to submit ideas for improvements as customer feedback is a key component to shaping the future direction of Db2 for z/OS.

    Sincerely,

    Db2 for z/OS Team