Rex We have spent a lot of time looking into this. We are doing both VSAM and DB2 capture. The problem with VSAM capture is that there is no one, easy way to get VSAM change data. When the file is open to CICS, many of the products use CICS facilities to grab the change data, and pump it into logstream. But the problem in our shop is that many of the VSAM files are closed for batch nightly processing, and there I no easy way to grab those updates. The vendor says, you have to bring in CICS/VR and run all your VSAM files through it, which fixes that problem, but there is a perceived performance issue introduced with that. So, for us, for VSAM, we chose the only vendor that provides a batch solution with a File Compare utility that generates the delta change data that is then ingested into Hadoop. That runs in batch, and does a compare of current and previous and generates the change data. This implies that you have to setup an extra backup of the VSAM data in question at the intervals you need. It's working out well for us. We are using the same product to do DB2 capture, but that is pretty much a set it and forget it situation once setup.
_________________________________________________________________ Dave Jousma Manager Mainframe Engineering, Assistant Vice President david.jou...@53.com 1830 East Paris, Grand Rapids, MI 49546 MD RSCB2H p 616.653.8429 f 616.653.2717 -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of ITschak Mugzach Sent: Wednesday, March 28, 2018 2:26 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: change data capture for VSAM **CAUTION EXTERNAL EMAIL** **DO NOT open attachments or click on links from unknown senders or unexpected emails** Attunuty CDC. ITschak On Wed, Mar 28, 2018 at 12:34 AM, Pommier, Rex <rpomm...@sfgmembers.com> wrote: > Hello all, > > I'm curious if anybody can provide me with the names of any companies > that do real time change data capture of VSAM datasets. We've looked > at a couple vendors who will remain nameless to protect their and our > interests. Specifically what we're looking for is something that can > grab VSAM data records as they're being written from either batch or > CICS sources, and write the VSAM record to a log file or MQ queue so > it can be shipped off platform into a data warehouse. > > Please respond off list to me directly if you have any ideas. > > Thanks, > > Rex > > The information contained in this message is confidential, protected > from disclosure and may be legally privileged. If the reader of this > message is not the intended recipient or an employee or agent > responsible for delivering this message to the intended recipient, you > are hereby notified that any disclosure, distribution, copying, or any > action taken or action omitted in reliance on it, is strictly > prohibited and may be unlawful. If you have received this > communication in error, please notify us immediately by replying to > this message and destroy the material in its entirety, whether in electronic > or hard copy format. Thank you. > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- ITschak Mugzach *|** IronSphere Platform* *|* *Information Security Contiguous Monitoring for Legacy **| * ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN **CAUTION EXTERNAL EMAIL** **DO NOT open attachments or click on links from unknown senders or unexpected emails** This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
