IBM Data and AI Ideas Portal for Customers
Hide about this portal


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 Not under consideration
Workspace Data Replication: Change Data Capture
Created by Guest
Created on Jan 17, 2017

RELATED IDEAS

Make table active on iSeries without data loss

See this idea on ideas.ibm.com

When the user changes the status of a table to active with Mark Table Capture Point in GUI, mark capture point in chcclp or System i command SETMIRSTS (*ACTV), a marker is posted to the journal and all unreplicated transactions between the end point of mirroring and the current time are lost for the table. Making the table active currently always set the internal status of the table to 2 (active pending) and the scraper does not replicate any transactions for the table until the marker in the journal is reached and the internal status is set to 3 (active)

Currently the only way to avoid data loss is to manually edit a metadata table. (On the Java platforms the dmsetbookmark command can be used to avoid data loss)

It is requested to enhance the SETMIRSTS command by adding another possible value to the STATUS parameter *RACT (meaning Resume Active). The internal metadata status flag for the table/member should be set as follows:
STATUS=*IDLE - set to 0 (parked) - current processing
STATUS=*RFSH - set to 1 (flagged for refresh) - current processing
STATUS=*ACTV - set to 2 (active pending) - current processing - where the user wants to skip transactions (e.g. during a CPYF into the table as part of a DDL change)
STATUS=*RACT - set to 3 ([resume] active ) - a new option for the status so that the journal scraper processes all transactions for the table after the mirroring end point irrespective of the marker previously left

  • Guest
    Reply
    |     May 17, 2021

    [IBM Update]

    Hi,

    Thank you for filing this requirement and for your interest in keeping CDC a vital and successful technology. We depend on your continued interest and ideas to help ensure our products keep pace with market needs and industry standards.

    Although we do agree that your request is valid, after monitoring your request for more customer demand over the last few years and applying other relevant evaluation criteria, unfortunately we won't be able to accept your request at this time. However, if there is still an important business need, we encourage you to file a new idea accompanied with any additional information that could help us prioritize the requirement in the future.

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.