Replication to Mainframe Db2 OSZ

What would I need in order to setup replication between SQL2000 SP3 and MVS Subsystem running Db2 database . I mean, does it need any 3rd party tool or regular replication setup between SQL and Db2 is enoughAsk IBM for the DB2 Federated Server. If you have DB2 license, they should let you use that software free. It comes with a Replicator which allows you to replicate data from a different platform.

Replication to Mainframe Db2 OS390

Can I get drivers to setup Replication to Mainframe . I really don't want to install HIS
Thankscan someone please answer .

Thanks|||I don't think its possible without HIS.|||HIS what?

:D|||HIS stands for Host Integration Server, more from here (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074) .

Replication scenario - seeking suggestion

I have two sites. Site A and Site B

Each site has two databases

Site A

Db1

Db2

Site B

Db1

Db2

Site A Db1 has to perform transaction replication to Site A- Db2 and Site B- Db1 and Db2.

I started Site A as pubisher and distributor and Site A and Site B both as subscriber.

Site B is in a different geographical area (state).

-

Please suggest the best scenario to save bandwidth and server load for Publisher, and Distributor.

-

Earlier I thought that I will implement local replication between Site B - in between Db1 and Db2. The Sql Server does not let me set Db1 as publisher, and distributor for its local database Db2.

-

P.S. My all databases need same transactions though they are connected to different hardware at different places. So please don't question that why I need four similar databases.

You can publish to Db1 then use Db1 as a republisher to publisher to Db2.

See in Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/a1485cf4-b1c4-49e9-ab06-8ccfaad998f3.htm

Martin

|||

Thank you!!

looks good.

For Site A - Db1

publisher, distributor and subsriber(Site A- Db2)

Db 2

Publisher Site A

Distributor Site B

Subscriber Db1

Subscriber Db2

I think, this is what you are suggesting.

|||

My suggestion would have the distributor on the same machine so:

A - DB 1 (master publisher)

A - DB 2 (subscriber)

B - DB 1 (subscriber , republisher)

B - DB 2 (subscriber (to B - DB 1)

Martin

|||

Thank you!!

I never tried republisher, I am running Sql Server 2000.

Let me read it, if I will have any question then I will get back.

Moreover, I could not access that help, this does not work from my computer.

This is exactly I would prefer, because otherwise it seems stupid to send data twice to the other site.

|||

Oh this is for SQL 2005 only. You need to install the SQL2005 books online to view the help link.

Martin

|||Thank you!

replication problems sql server to db2

I am experiencing problems replicating (transactional) from SQL Server
2000 sp3 to DB2 v8.2 (running on Red Hat Linux).

I have created an OLE-DB linked server to DB2. The connection connects
successfully in EM and I can query the DB2 tables using the OPENQUERY
function.

I have successfully added the linked server connection as a Subscriber.
I have now set up a Push Subscription to DB2 from one of my
Publications.

My Distribution Agent errors with:
"The process could not connect to Subscriber xxx "

Any suggestions will help, thank youI have no idea myself, but you might get a better response in
microsoft.public.sqlserver.replication.

Simon|||I have no idea myself, but you might get a better response in
microsoft.public.sqlserver.replication.

Simon

Replication performance - how to measure it ?

Hello,

could you please advice on how to measure replication performance
in Oracle, DB2 & MS SQL Server RDBMS installed in Windows servers ?
I've got two servers with databases installed and configured,
I prepared set of data using DBGEN from TPC and I already imported them
into databases.Also, I configured the replication.
Now I have to do a test with a few kind of replications method
implemented in these RDMBS, but I don't know which tool or reports or
"v$iews" should I use to measure replication performance.
The replication is configured only between the same RDBMS, I mean
Oracle <-Oracle, DB2 <-DB2 and MSSQL<-MSSQL.
Most of applications are great for checking performance of local DB,
not for replicated/distributed.
I've found description of CA Unicenter Database Performance Management
for distributed RDMBS, and I think it could be the right one, but I
can't find any demo or trial version :(
Could you please advice any place to download it, or other application,
script, description, just whatever.
Perhaps just any other idea how to check the replication mechanism
efficiency ?

Regards,
Markmjan@.interia.pl wrote:

Quote:

Originally Posted by

Hello,
>
could you please advice on how to measure replication performance
in Oracle, DB2 & MS SQL Server RDBMS installed in Windows servers ?
I've got two servers with databases installed and configured,
I prepared set of data using DBGEN from TPC and I already imported them
into databases.Also, I configured the replication.
Now I have to do a test with a few kind of replications method
implemented in these RDMBS, but I don't know which tool or reports or
"v$iews" should I use to measure replication performance.
The replication is configured only between the same RDBMS, I mean
Oracle <-Oracle, DB2 <-DB2 and MSSQL<-MSSQL.
Most of applications are great for checking performance of local DB,
not for replicated/distributed.
I've found description of CA Unicenter Database Performance Management
for distributed RDMBS, and I think it could be the right one, but I
can't find any demo or trial version :(
Could you please advice any place to download it, or other application,
script, description, just whatever.
Perhaps just any other idea how to check the replication mechanism
efficiency ?
>
Regards,
Mark

Any answer you might receive regarding Oracle depends upon which
replication mechanism you choose and which release of Oracle you're
using. Absent such information it's difficult, if not impossible, to
supply an answer.

Since you can't, or won't, supply the above mentioned information take
a trip to http://tahiti.oracle.com and start reading the documentation
for the replication mechanism and release you're using. Monitoring
instructions are usually included in these docs. I could provide
information for Streams on 9.2.0, (and possibly 10.2) but the dearth of
information in your post, as well as having my own work to complete,
causes me to send you to the manuals. Should you decide to provide
more detail I, or someone else in this newsgroup, could possibly supply
a better response to your question.

As ye sow, so shall ye reap. Provide to us, we can provide to you.
It's that simple.

David Fitzjarrell|||mjan@.interia.pl wrote:

Quote:

Originally Posted by

Hello,
>
could you please advice on how to measure replication performance
in Oracle, DB2 & MS SQL Server RDBMS installed in Windows servers ?
I've got two servers with databases installed and configured,
I prepared set of data using DBGEN from TPC and I already imported them
into databases.Also, I configured the replication.
Now I have to do a test with a few kind of replications method
implemented in these RDMBS, but I don't know which tool or reports or
"v$iews" should I use to measure replication performance.
The replication is configured only between the same RDBMS, I mean
Oracle <-Oracle, DB2 <-DB2 and MSSQL<-MSSQL.
Most of applications are great for checking performance of local DB,
not for replicated/distributed.
I've found description of CA Unicenter Database Performance Management
for distributed RDMBS, and I think it could be the right one, but I
can't find any demo or trial version :(
Could you please advice any place to download it, or other application,
script, description, just whatever.
Perhaps just any other idea how to check the replication mechanism
efficiency ?
>
Regards,
Mark

Your question, as stated, is impossible to answer with respect to
Oracle.

You have not provided a version number and replication might be
accomplished in a wide variety of ways depending on your requirements.
Among the possibilities:

Advanced Replication (many variations)
Streams (many variations)
Change Data Capture (3 different modes: Synchronous or Asynchronous?
Hotlog or Autolog?)
Data Guard (3 different modes: Maximum Protection, Maximum Availability,
and Maximum Performance)

You will find that depending on the Oracle option you choose you may
well find that neither SQL Server or DB2 has an equivalent technology.
--
Daniel A. Morgan
University of Washington
damorgan@.x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org|||On 24 Aug 2006 06:17:40 -0700, mjan@.interia.pl wrote:

Quote:

Originally Posted by

>Hello,
>
>could you please advice on how to measure replication performance
>in Oracle, DB2 & MS SQL Server RDBMS installed in Windows servers ?

Hi Mark,

For MS SQL Server, check out the subject "Monitoring Replication" in SQL
Server 2005 Books Online. Here's a link (copy and paste into the URL
field in Books Online to be taken to the subject directly):
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/f182f43a-6af8-45bc-a708-08d5f7a6984a.htm

And if you don't have Books Online installed, here's a link to the
internet copy: http://msdn2.microsoft.com/en-us/library/ms152751.aspx
--
Hugo Kornelis, SQL Server MVP|||And if you don't have Books Online installed, here's a link to the

Quote:

Originally Posted by

internet copy: http://msdn2.microsoft.com/en-us/library/ms152751.aspx
>
--
Hugo Kornelis, SQL Server MVP

Thanks for fast reply, guys.
Hugo, thanks for the link about MS SQL Server monitoring :)

DA Morgan&fitzjarrell, you're right. I'm sorry, my mistake.
Oracle version is 10gR2 10.2.0.1.0, IBM DB2 v8.1.7
and Microsoft product will be probably MS SQL Server 2005

At present I've got configured replication only for DB2,
as concerns Oracle - I'm working on it.
Actually, I'm going to test almost all kinds of replication method
offered by these RDBMS,
so I need the most uniwersal benchmark&monitoring tool for this.
I know that it's hard to advice, but believe me that since a few days
I'm just searching&looking for information about a software or
procedure to evaluate replication performance.
On usenet, ftp's, WWW, P2P, DBA forums, etc. well, just everywhere.
But it seems, that not a lot of admins need to make a replication
tests.
Thats why I decided to ask for help here .

Cheers,
Mark|||diesel wrote:

Quote:

Originally Posted by

Quote:

Originally Posted by

>And if you don't have Books Online installed, here's a link to the
>internet copy: http://msdn2.microsoft.com/en-us/library/ms152751.aspx
>>
>--
>Hugo Kornelis, SQL Server MVP

>
Thanks for fast reply, guys.
Hugo, thanks for the link about MS SQL Server monitoring :)
>
DA Morgan&fitzjarrell, you're right. I'm sorry, my mistake.
Oracle version is 10gR2 10.2.0.1.0, IBM DB2 v8.1.7
and Microsoft product will be probably MS SQL Server 2005
>
At present I've got configured replication only for DB2,
as concerns Oracle - I'm working on it.
Actually, I'm going to test almost all kinds of replication method
offered by these RDBMS,
so I need the most uniwersal benchmark&monitoring tool for this.

No such thing in the Oracle world. Different tools for different
requirements and different modes depending on your priority.

The faster the replication the more risk of data being lost. Here's
something to consider. Is the transaction completed when it is committed
on the primary box or is it completed when it is committed both locally
and at the replication site? What happens if the link between the two
goes down? Do you continue local processing and hope to catch up later
or do you stop all transactions? These are all very important questions.

To just be testing speed alone is sort of like the airplane pilot who
cuts the engines at 35,000 feet and at 1,500 feet announces to the
passengers that fuel economy is really improved.

Quote:

Originally Posted by

I know that it's hard to advice, but believe me that since a few days
I'm just searching&looking for information about a software or
procedure to evaluate replication performance.

And what I am cautioning you about is that replication performance is
a meaningless metric unless you are comparing technologies that produce
the same outcome. Not just when all is perfect but in real world
situations. I can make anything really fast if I don't care what happens
later when there is a network glitch.

Quote:

Originally Posted by

On usenet, ftp's, WWW, P2P, DBA forums, etc. well, just everywhere.
But it seems, that not a lot of admins need to make a replication
tests. Thats why I decided to ask for help here .
>
Cheers,
Mark

I hope you do help ... but I see no evidence that you are really trying
to compare apples with apples. If you don't your will produce numbers.
Meaningless numbers ... but numbers. I suspect that is not your goal.
--
Daniel A. Morgan
University of Washington
damorgan@.x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Replication of DB2 data on SQL Server

What tools are available to update SQL Server application tables from a DB2 database?
The DB2 database is on iSeries (AS/400).
Thanks in advance.you can probably create a linked server from SQL Server to DB2 and then use select statements as usual. search for db2 on the link below.

http://msdn2.microsoft.com/en-us/library/ms190479.aspx|||It really depends on the version of SQL Server you are running. Linked servers as mentioned is one option, another option is using DTS or SSIS to transfer data regulary. Unfortunately it appears that you have to pull the data from the SQL Server, I don't think the AS/400 will be able to push data to the SQL Server.|||You could write java programs to push data either way using an JDBC connectivity.

We can also look @. tools from IBM to push data to SQL Server using DB2 Information Integrator V8, IBM DB2 Replication & DataPropagator.