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 Planned for future release
Components Q Replication for Z
Created by Guest
Created on Feb 28, 2018

Replication condiction

System : InfoSphere Replication Server(Q replication) is real-time database replication solution for better control of DB2 replication.
Description : Customer want to check or before image and after image condition each row processing to control special condition.
Customer want to add more condition to accurate the filter, like specify old value (before image).
They want to ignore the log records when they want to

  • Admin
    Rohit Agarwal
    Apr 5, 2020

    Adding history from RFE-33857:

    4.Davendra PaltooApr 18, 2018 12:49 PM

    From Serge:

    We are waiting for client feedback on our suggestion to add a new Capture option to consider changes to VARCHAR from empty to space as NOT a change. This request does make sense to us and is very easy to implement. I already wrote a prototype. If it meets their requirement, we could deliver or have them Beta test. I will resend you the email that we sent them.

    From email sent to the client

    "I apologize for my slow response, I have been thinking a lot about this requirement and really wish to find a solution for SFMI. I looked into the client's suggestion of supporting search_condition filters on the before values of updates, but it is too costly to implement in a reasonable time given our priorities, not to mention development resources, and it does not align well with the intended usage of search conditions. We cannot justify pushing this change forward at this point.

    Instead, I am now exploring providing a new Capture option, something like 'suppress_empty2space_changes', similar to our existing 'suppress_delete' subscription option. The idea is to consider a change for any column from empty string to space(s) as NOT A CHANGE for this column. This means that if the only changes to a row are for changing varchar columns from empty string to space-only string, then the row would not be replicated. We have not fully fleshed out the solution, but are evaluating the idea. Please let us know if this would address the problem. Can you also expand if and how the problem affects other data types?

    Our original suggestion of using IGNTRAN table to skip the transaction is best in terms of performance, because Capture does not have to materialize/process any rows for the transaction to ignore, but we do accept that the customer finds it impossible to implement. This is unfortunate."

    3.Davendra PaltooApr 4, 2018 7:26 AM

    Serge has an alternative proposal. Being discussed with the client. Need comeback from Serge

    2.jazzdw userMar 15, 2018 4:07 AMSUNMI MIN wrote:

    SUNMIMIN created an attachment, SFMI_IRS_20180315.txt : http://www.ibm.com/developerworks/rfe/execute?use_case=downloadAttachment&ATTACHMENT_ID=16536&eaid=551b3007f0336dc8

    1.jazzdw userMar 9, 2018 3:17 AMSUNMI MIN wrote:

    1. The source is a SAP database? ==> Yes , customer use SAP on DB2 . 2. What tables are they merging? ==> I just have test case sample SQL. Do do you need real tables list ? ** ADD Column db2 "alter table sapsr3.test_update add column num varchar(20) not null with default ' '" db2 reorg table sapsr3.test_update 3. Can you share the merge command that they use? ==> I just have test case sample SQL. ** MERGE Statement MERGE INTO sapsr3.TEST_UPDATE AS t USING TABLE( VALUES ( 'ID1','TEST1',' ' ) ) AS p(id, name, num) ON t.id=p.id AND t.name=p.name WHEN MATCHED THEN UPDATE SET num = ' ' WHEN NOT MATCHED THEN INSERT ( t.id, t.name, t.num ) VALUES ( p.id, p.name, p.num ) ; 4. Why is the merge is generating update for every single column of the target table? ==> "Merge" task is SAP logic. 5. Is the column added a CHAR type? Is this a regular event? For what reason? ==> I heard regular event one a week and sometime it happened one a month. There is for the reason their business logic.