Hi Elardus, We have bounced around the idea of modifying the applications to write MQ records at the same time as the VSAM updates but that would be way too time consuming. We are currently doing was/is comparisons of some of our VSAM and are trying to get away from that. Of the two products we've looked at, one of them does just that. The other has a hook that actually grabs the data records (I think via a system hook - I wasn't involved in that POC) but we/they struggled with performance and thruput.
Rex -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Elardus Engelbrecht Sent: Wednesday, March 28, 2018 8:01 AM To: [email protected] Subject: [External] Re: change data capture for VSAM Rex Pommier wrote: >I'm curious if anybody can provide me iith 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. You got good replies, but if no-one can suit your needs, I have a possible suggestion. What about rewriting the applications to write to TWO datasets? One for your usual VSAM datasets and its friends and another dataset containing changed (new/changed/deleted) records? Yes, it is a real PITA to avoid vendors in this way beside that is double work, longer runtime, more diskspace, etc. Or do a compare of before/after changes and ship the differences to that warehouse. Of course there is that usual overhead of time-consuming comparing work. Related question: Do those vendors use 'hooks' to replace the SVCs to intercept these VSAM I/Os? I hope you can find a good solution. Groete / Greetings Elardus Engelbrecht ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN 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 [email protected] with the message: INFO IBM-MAIN
