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
