You could get rid of VSAM and use VSAM transparency. All your VSAM writes/updates are processed in DB2. You can then utilise a DB2 change capture tool of your choice.
I can help you with both... On Thu, Mar 29, 2018 at 2:03 AM, Carmen Vitullo <[email protected]> wrote: > 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 > -- Wayne V. Bickerdike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
