Did you look into Hot Standby data base or Oracle Data Guard, a feature
offered by Oracle itself. This allows you to have a standby database on a
different computer. Updates to a primary database get applied to the redo
logs of the secondary database over a tcpi/ip connection. either synchronous
or asynchronous updates may be applied over a TCP/IP connection.
You can setup Oracle on z/OS which uses VSAM LDS and send all updates from
Sun/Oracle to this Hot standBy Database on zOS/Oracle. The feature is
available from as old as Oralce 9i, among supprted releases. Here is a link
http://download-east.oracle.com/docs/cd/A91202_01/901_doc/server.901/a88808/standbygloss.htm
One can setup either synchronous (Real Time with wait till a transaction has
been applied) or Asynchronous (Real time but do not wait till a transaction)
has been applied.
Regards,
From: "McKown, John" <[EMAIL PROTECTED]>
Reply-To: IBM Mainframe Discussion List <[email protected]>
To: [email protected]
Subject: VSAM replication to Oracle?
Date: Thu, 14 Sep 2006 15:22:57 -0500
Our "business intelligence" people have stated that they need to be able
to get real-time or near-real time updates to a number of VSAM datasets
into their Sun/Oracle system. This would be from CICS and batch jobs.
Anybody know of a product to do this? They mentioned something called
DataMirror (http://www.datamirror.com), but I can't see any in depth
documentation on that site.
--
John McKown
Senior Systems Programmer
HealthMarkets
Keeping the Promise of Affordable Coverage
Administrative Services Group
Information Technology
This message (including any attachments) contains confidential
information intended for a specific individual and purpose, and its
content is protected by law. If you are not the intended recipient, you
should delete this message and are hereby notified that any disclosure,
copying, or distribution of this transmission, or taking any action
based on it, is strictly prohibited.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
