Please contact me offline on this. John T. Abell Tel: 800-295-7608 Option 4 President International: 1-416-593-5578 Option 4 E-mail: [email protected] Fax: 800-295-7609
International: 1-416-593-5579 International Software Products www.ispinfo.com This email may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, retention, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive on behalf of the named recipient), please contact the sender by reply email and delete all copies of this message. Also,email is susceptible to data corruption, interception, tampering, unauthorized amendment and viruses. We only send and receive emails on the basis that we are not liable for any such corruption, interception, tampering, amendment or viruses or any consequence thereof. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Elardus Engelbrecht Sent: Wednesday, March 28, 2018 9:01 AM To: [email protected] Subject: 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 --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
