Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  CDC on Workgroup Edition?

    Posted Tue March 18, 2025 05:33 AM

    Is it possible to use CDC on Workgroup Edition or is it an Enterprise feature?

    Thanks in advance,

    -Snorri



    ------------------------------
    Snorri Bergmann
    ------------------------------


  • 2.  RE: CDC on Workgroup Edition?

    Posted Tue March 18, 2025 09:22 AM

    1. Triggers
    2. Auditing
    3. Third-party tools



    ------------------------------
    Suman Suhag Dev Bhoomi Uttarakhand University
    Business Development Intern
    GAO Tek Inc.
    Jhajjar, Haryana, India
    ------------------------------

    Original Message


  • 3.  RE: CDC on Workgroup Edition?

    Posted Tue March 18, 2025 09:40 AM

    Hi,

    CDC (Change Data Capture) is typically an Enterprise feature.
    Availability on Workgroup Edition is unclear.
    Check official documentation for confirmation.
    Contact support for specific edition details.



    ------------------------------
    Suman Suhag
    Jhajjar, Haryana, India

    ------------------------------

    Original Message


  • 4.  RE: CDC on Workgroup Edition?

    Posted Tue March 18, 2025 09:43 AM

    It is certainly possible to use CDC on Workgroup Edition.  It does work.

    The bigger question is whether it can be done under the Informix licensing.  I fully expect that it can because Workgroup licensing does allow HDR/RSS (limited to 2 secondaries), ER, and Continuous Log Restore, so allowing CDC seems logical.  Still, check with whoever you get your licenses from.



    ------------------------------
    Mike Walker
    xDB Systems, Inc
    www.xdbsystems.com
    ------------------------------

    Original Message


  • 5.  RE: CDC on Workgroup Edition?

    Posted Wed March 19, 2025 05:32 AM

    I only dabble in licensing matters but I would say 'no' or at least 'probably not' based on https://www.iiug.org/en/2019/10/08/compare-informix/

    At the bottom of the table there is a row for InfoSphere® Change Data Capture. You don't have to buy that product to use CDC of course: you can write your own C or Java program. However, the fact it is not available for use with Workgroup Edition suggests to me that the Infomix component of this stack - CDC - is what is not available.

    As has been suggested elsewhere I would speak to IBM, HCL or your reseller, whoever you deal with for licensing.

    Ben.



    ------------------------------
    Benjamin Thompson
    ------------------------------

    Original Message


  • 6.  RE: CDC on Workgroup Edition?

    Posted Wed March 19, 2025 05:53 AM
    Edited by Snorri Bergmann Wed March 19, 2025 09:00 AM

    Hi and thank you all.

    Probably this is an Enterprise feature. However, I find very strange that IBM/HCL do not provide a detailed table/document describing which features are NOT available in each edition.
    Some of the features (CPU VPs, SHMEMEM etc) are disabled/limited on the binary level but others are disabled on the Licensing level like CLR. 
    This InfoSphere reference is not conclusive because the product name is mentioned, not "CDC" explicitly. Maybe InfoSphere needs some other Enterprise features to work.

    Best regards,

    -S



    ------------------------------
    Snorri Bergmann
    ------------------------------

    Original Message


  • 7.  RE: CDC on Workgroup Edition?

    Posted Fri March 21, 2025 05:12 AM
    Edited by Snorri Bergmann Fri March 21, 2025 05:12 AM

    After some digging I found this:
    https://www.cursor-distribution.de/en/sales-informix/ibm-licensing-informix/ibm-license-informix-workgroup-edition-en/1416-ibm-informix-workgroup-edition-v14-10-xc10-en

    CDC is not mentioned in "Prohibited components". (And neither is CLR btw.)



    ------------------------------
    Snorri Bergmann
    ------------------------------

    Original Message