Skip to Main Content
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


Status Delivered
Created by Guest
Created on Sep 20, 2020

Alter Table Data Capure None during table mapping

When we try to map 20 tables from Remote Capture agent to kafka side, CDC product run the following commands in order.

a. ALTER TABLE "TG"."T_CARD_MASTER" DATA CAPTURE NONE

b. ALTER TABLE "TG"."T_CARD_MASTER" DATA CAPTURE CHANGES

However, for some tables, the second command failed since it requires a short lock on the table. They are the ones of the very frequently used tables. So we resulted in tables with Data Capture NONE, even though they were Data Capture CHANGES to begin with.

Needed by Date Nov 30, 2020
  • Admin
    Davendra Paltoo
    Reply
    |
    Dec 9, 2020

    IBM Update.

    This requirement has been addressed.

    Please see the release notes for further details: https://www.ibm.com/support/pages/node/1110477

    "

    Add new system parameter " alter_table_data_capture_flag_allow_turn_off" to allow/disallow a CDC source engine to turn off data capture when the table is no longer mapped in any subscription"

  • Admin
    Davendra Paltoo
    Reply
    |
    Nov 6, 2020

    IBM update

    Here is how we interpret this request

    Summary:Add new system parameter to allow/disallow a CDC source engine to turn off data capture when the table is no longer mapped in any subscription.

    Details:

    CDC source does not automatically turn off capture before it turns it on when the table is mapped for replication, and CDC only turns on capture when it detects that the table capture is not already on. CDC source turns off capture only when the table is no longer mapped for replication. The following parameter will be added to let users control if the CDC source should turn off capture - when this parameter is false, CDC source will not turn off data capture for all tables in replication. alter_table_data_capture_flag_allow_turn_off
    Use this system parameter to allow a CDC source engine to turn off data capture when the table is no longer mapped in any subscription.

    Applies to:
    All databases except for Oracle
    Values
    Set this parameter to one of the following values:
    true
    CDC will turn off table capture when the table is deleted from the last mapping containing this table.
    false
    CDC will not turn off table capture when the table is deleted from the last mapping containing this table. For MSSQL, all entities created by CDC to enable change data capture, including MSSQL publisher, publication, article, article filter, subscriber, and subscription remains.
    Default Setting
    true

    =