Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / May 2006

Tip: Looking for answers? Try searching our database.

pls help urgent

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
situ - 12 May 2006 08:07 GMT
hi all,

i have  a problem

i had one master  database a which connects to some remote server and
stores the transaction  data.
i have 2 more database of same stucture as the one above mentioned.
now my problem is i want to update or refresh the data in this two
database as the master
database get updated or changes
pls help urgently

thanks and regards
sithu
Artur - 12 May 2006 11:20 GMT
Sithu,

I suggest to use Queue-replication (marketing product name: WebSphere
Information Integrator for Replication). This is DB2 asynchronous
replication, but  with very short latency. It uses MQ (included in the
product) to transfer data.

However this is $$$ an optional $$$ product.

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
ii.doc/start/cgpch300.htm


-- Artur Wronski
paul.lapointe.xkoto@gmail.com - 15 May 2006 16:25 GMT
There are several options for replication and clustering DB2. Which one
is right depends on what you are trying to achieve, and what
constraints you are working against.

Are you trying to scale the performance of your database by off loading
reads from the master database to a read farm? (It sounds like this is
what you are doing)
Are you looking for a high availablity?
Can the secondary databases be slightly out of date, or do you need
full transactional integrity?

Autur, is right, you should look at Q-replication, and also DB2's
SQL-replcation. SQL-replication is slower, but is pretty flexible (it
may be cheaper? - I don't remember). You can use it to transform and
ship transactions to different databases other than DB2. Q-replication
is faster, but less flexible. For DB2 LUW, both are add-on products (I
think SQL-rep is included in DB2 for z/OS). If you give your db2 sales
rep a call they should be able to help you out.

Both of these are asynchronous master-slave replication products. That
means the secondary databases lag behind the master by some period of
time, from milliseconds to several seconds. The replication itself is
also not ACID compliant. For most applications this is fine, for some
it is not.

If transactional integrity is a constraint, my company (xkoto) makes a
clustering solution for DB2 that is designed to ensure transactional
integrity across a cluster of fully active database servers. We also
simply the process of reading off the secondary boxes by handling the
load balancing of reads across the cluster.

If you are interested I can send you more info.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.