Datacom

  • 1.  Can we automatically send update data from DATACOM to ORACLE?

    Posted Aug 18, 2017 09:41 AM

    We are wondering whether or not there is a way to keep ORACLE tables on other platforms updated in basically real-time.  Any assistance would be appreciated.

     

    We are currently running 15.0 DATACOM-DB. CDC is not being used here; would that be something to investigate?



  • 2.  Re: Can we automatically send update data from DATACOM to ORACLE?
    Best Answer

    Posted Aug 18, 2017 09:56 AM

    Steve,

    we are currently using CDC and another software package(Informatica PowerExchange, on the mainframe & PowerCenter, on the servers) to do that.

    CDC is designed to capture the changes from Datacom table(s) and writes them to one database(2009).  you can even have multiple CDC databases(CDC_PLUS).



  • 3.  Re: Can we automatically send update data from DATACOM to ORACLE?

    Broadcom Employee
    Posted Aug 21, 2017 11:29 AM

    Another option that was available in prior releases for people in the Development Buddy program was a tool called Dataminer. In order to use this, you would have to contact Date Russell here to see if it is available for version 15.x.

     

    We also have a Knowledge Base article that talks about this some. Please review TEC433727, titled "New version of the Dataminer routines now available for CA Datacom/DB RXX-based change capture and audit reporting" for more details.



  • 4.  Re: Can we automatically send update data from DATACOM to ORACLE?

    Broadcom Employee
    Posted Aug 21, 2017 04:13 PM

    The CA Datacom "Data Miner System" set of user-contributed sample COBOL programs is independent of release, so it can be used with 15.x. It allows you to replicate changes to your CA Datacom/DB data from one MUF to another MUF or to another DBMS.  If you are interested in seeing this, we will ask that you sign a disclaimer document first.  Email me at Dale.Russell@ca.com.

     

    Dale Russell

    Director, Software Engineering



  • 5.  Re: Can we automatically send update data from DATACOM to ORACLE?

    Posted Aug 21, 2017 12:06 PM

    Hi Steve,

     

    There is a 3rd party option that our company provides to handle the Change Data Capture from Datacom to Oracle, tcVISION.  We'll be happy to organize a presentation / demo to show you how it works.

     

    You can contact me directly if you'd like, or have a look at our website.

     

    Kevin Heimbaugh

    Treehouse Software



  • 6.  Re: Can we automatically send update data from DATACOM to ORACLE?

    Posted Aug 23, 2017 10:00 AM

    Regarding CDC, is this statement true, or, possibly, are there workarounds?  (Asking because we have been using NO forever.)

     

    “When using the CDC feature, make certain that you have either specified YES for the MUF startup option RXXROLLBACK or allow RXXROLLBACK to default to YES. You cannot use the CDC feature when force check pointing is specified, that is, when RXXROLLBACK is NO or LOGRCV is NEVER.”



  • 7.  Re: Can we automatically send update data from DATACOM to ORACLE?

    Posted Aug 23, 2017 10:43 AM

    Hi Steve,

     

    Yes, it is a true statement. And I doubt there is a work-around … CDC simply requires it

     

    If you are concerned about having to run manual backward recoveries for incomplete roll-backs, we avoid that (in MUFs where completing the roll-back is not critical) by having our automated operations product intercept the “DB00109W - BACKOUT JOB-DB15#FCP NUMBER-70432 TSN-0182430B WAITING TO COMPLETE” message and issue a TSN_ABORT on the TSN number in the message. The net result is the same as with ‘RXXROLLBACK NO’: an incomplete back-out

     

    Clyde