Db2

 View Only
  • 1.  cdc connection

    Posted Sat December 04, 2021 04:23 AM
    i know it is not really related to db2, but there is no community for CDC
    we have cdc connected to db2 luw on linux
    when we do a deploy of ddl in db2, we want to check if the table is replicated by cdc to avoid the subs to stop
    is there somewhere a doc that explains how to connect/consult data from cdc in the internal database/instance
    so we could lookup if the table is in the mapped table list
    I have seen some java programs to connect to access server, but is it also possible from bash, as I am not very familiar with java


    ------------------------------
    Thank for all update/help
    Best Regards, Guy Przytula
    ------------------------------

    #Db2


  • 2.  RE: cdc connection

    IBM Champion
    Posted Mon December 06, 2021 01:23 PM
    Hi Guy,

    I bet you want to look at https://www.ibm.com/docs/en/idr/11.4.0?topic=replication-command-line-processor-chcclp
    and https://www.ibm.com/docs/en/idr/11.4.0?topic=commands-understanding-command-syntax .

    But I haven't found a decent list of command parameters for that command.
    As you said, this Java program seems to enumerate all monitored subscriptions and is using a list to go through.
    https://www.ibm.com/docs/en/idr/11.4.0?topic=mode-sample-programs . Some programmer surely converts you this
    sample into some code, which returns you some XARGS compatible list.

    Cheers

    ------------------------------
    Roland Schock
    Distinguished Engineer
    ARS Computer und Consulting GmbH
    Muenchen
    ------------------------------



  • 3.  RE: cdc connection

    Posted Mon December 13, 2021 08:52 PM

    Hi,

    It's a pointbase database. 

    I have done a little exploring. There an executable that allows you to access the database and standard SQL to access the data. The database is installed in the CDC Instance/Engine path.

    I found a pointbase manual online. It's a lot easier to access than chcclp commands, but I am sure IBM would tell you not to play with the database. For me, I have hundreds of tables going to multiple databases though a list of subscriptions. Just to get a list of tables from chcclp is a chore - vs a query against a pointbase table or two. 



    ------------------------------
    Douglas Kostelnik
    Professional Consultant
    Capgemini
    Tampa FL
    ------------------------------



  • 4.  RE: cdc connection

    Posted Tue December 14, 2021 02:43 AM
    many thanks for the update
    would you mind sharing the link to that doc, or a simple example how to  start with this, and I could build on top of this example.
    I will also search myself and see if getting there


    ------------------------------
    Thank for all update/help
    Best Regards, Guy Przytula
    ------------------------------