a bit expensive maybe unless you already have a replication solution is replicate or FLASH the data periodically to another DASD subsystem.. just thinking out loud, you can selectively FASH volumes and break the pair manually we did something like this when I worked for State Govt I was the only solution at the time to backup DB2 and ADABAS databases
Carmen Vitullo ----- Original Message ----- From: "Rex Pommier" <[email protected]> To: [email protected] Sent: Wednesday, March 28, 2018 9:16:54 AM Subject: Re: [External] Re: change data capture for VSAM Timothy, Moving the data to the mainframe isn't an option here. We're aggregating data from several disparate systems already. We're either pushing mainframe data to an off-platform warehouse or we're pushing data from windows machines to the mainframe for aggregation. We already have the warehouse built and running, but are looking for a way to get data into it in a more real-time fashion. I'll check the CDC tool you mentioned to see if it would fit our needs. Thanks, Rex -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Timothy Sipples Sent: Wednesday, March 28, 2018 2:26 AM To: [email protected] Subject: [External] Re: change data capture for VSAM Rex, You can take that classic approach of capturing VSAM updates, pushing the data elsewhere, and then running analytics/reporting or whatever else you're doing. IBM InfoSphere Classic Change Data Capture for z/OS (5655-IM5), as a notable example, would help you do that. However, we're all learning (rapidly!) that that approach is often not a terrific solution pattern for a variety of reasons. It's usually better to bring the analytics/reporting to the data rather than the other way around for reasons of security, real-time insight, performance, and cost effectiveness. You can bring the analytics to the data using, as a notable example, IBM Open Data Analytics for z/OS (5655-OD1) featuring Apache Spark, perhaps in a federated Spark implementation. IBM Data Virtualization Manager for z/OS (5698-DVM) might also be part of the picture, separately or in combination with IODA-Z. And the IBM Db2 Analytics Accelerator (IDAA) can also be quite compelling. Yes, IDAA supports more than Db2 data. VSAM and IMS data can also be part of the IDAA. -------------------------------------------------------------------------------------------------------- Timothy Sipples IT Architect Executive, Industry Solutions, IBM Z & LinuxONE, Multi-Geography E-Mail: [email protected] ---------------------------------------------------------------------- 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 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
