[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbintegrator_public_public

Title:	DB Integrator Public Conference
Notice:	Database Integration - today! Kit/Doc info see note 36
Moderator:	BROKE::ABUGOV

Created:	Mon Sep 21 1992
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1171
Total number of notes:	5187

1122.0. "@PC in non-Digital machine" by nomahs::ESHIH () Tue Feb 04 1997 02:51

Hi,

I will use two phase commit in two databases. One database
is RDB V4.2 in VAX/VMS machine, and the other one is Oracle V7.3 
in IBM/AIX.Application is written by powerhouse in VAX/VMS.

I suggest customer to buy our RDB transparent gateway for Oracle7. I just 
want to sure this suggestion is right or wrong. There is any other
solution ? Which version of gateway I should order ?


Can the RDB replication option(DEC data distributor) replicate database 
to Digital Unix and non-Digital Unix machine?

Thanks in advance 

echo

T.R	Title	User	Personal Name	Date	Lines
1122.1	If no 2pc, the V7 gateway to Oracle will work	BROKE::ABUGOV		`Tue Feb 04 1997 08:37`	16
	Hi Echo, Th Rdb Transparent Gateway to Oracle does not support two phase commit. You can use the Rdb Transparent Gateway to access the Oracle database on AIX (customer will need SQLnet on the VMS box). If they want to access join data from both Rdb and Oracle they will need DataBase Integrator also. The replication option can be used to move data from Rdb into Oracle pretty much anywhere. Hope this helps, Dan
1122.2	the version of replication option	nomahs::ESHIH		`Tue Feb 04 1997 22:59`	4
	Hi , thanks for your quick support. I just want to know which version of RDB replication option can support RDB V4.2 ? echo
1122.3	Replication Option requirements	BROKE::PROTEAU	Jean-Claude Proteau	`Wed Feb 05 1997 09:39`	41
	Hello, I'll answer for the Replication Option. There are bascially two modes of data transfer, REPLICATION and EXTRACTION. I bring this up because it is relevent to which product version you use. REPLICATION transfers data changes incrementally. Each time a transfer cycle is started, only the changes to data rows (inserts, updates, deletes) are copied to the destination tables. This is the method most popular with our customers. The REPLICATION method only works for Rdb data sources and the Rdb database must be on the same system or cluster as is the Replication Option. EXTRACTION is a complete refresh of the data each time the transfer is reexecuted. The EXTRACTION method can work with any data source that we support, whether it is local to where the Replication Option is installed or remote from it. The version of the Replication Option that coincides with Rdb 4.2 is VAX Data Distributor 2.4 (that was the product name and version when it was released as a product from Digital. VDD 2.4 is no longer available nor is it supported. In addition it wasn't until a later version of the product that transfers to Oracle7, Digital UNIX, and via TCP/IP were supported. To use the Replication Option to transfer from an Rdb 4.2 source database into an Oracle7 target database on a Digital UNIX system, you have two choices: 1) Convert the Rdb 4.2 database to Rdb 7.0 (6.1 would do, but why bother) and use ROR 7.0 on the same system. I didn't check your version of VMS; we have minimum requirements there too. 2) Install ROR 7.0 on a third VMS system. Use the EXTRACTION method to transfer data from the remote Rdb 4.2 database into the Remote Oracle7 database. The Rdb Transparent Gateway to Oracle can be located either on the same machine as the Replication Option or on the Digital UNIX system.