473,320 Members | 1,993 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

HADR / Q replication comparison

I have found some text on HADR / Q replication comparison. Please let
me know if you agree with the accuracy!!

HADR DB2 II Q based Replication
-------------------------------------------------------------------

Sync, async, near-sync Near real time async
whole DB2 database selected tables/columns
DDL, DML DML only
very simple to set up and manage more complex to set up and manage
similar configurations only sites can be very different
no support for unlogged LOBs can support unlogged LOBs
1 read/write site only multiple read and/or update sites
No DPF DPF ok

Nov 12 '05 #1
1 3143

Well,

I found the Q based replication rather easy to setup and really fast (being a
DBA and not a MQ specialist)
Of course, since you have the table/row level, you have more options and this
might appear more complicated.

I didn't try LOBs.

Juliane.
hi****@gmail.com wrote:
I have found some text on HADR / Q replication comparison. Please let
me know if you agree with the accuracy!!

HADR DB2 II Q based Replication
-------------------------------------------------------------------

Sync, async, near-sync Near real time async
whole DB2 database selected tables/columns
DDL, DML DML only
very simple to set up and manage more complex to set up and manage
similar configurations only sites can be very different
no support for unlogged LOBs can support unlogged LOBs
1 read/write site only multiple read and/or update sites
No DPF DPF ok

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200507/1
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: derekbarrett | last post by:
Hi all, Our business is in manufacturing, and we are running SAP on DB2 8.1, planning on upgrading to 8.2.2 within a couple of months. We are running operations 24/7, so are looking for ways to...
13
by: m0002a | last post by:
I am trying to determine whether LOB's are replciated using HADR. The following documentation from the on-line manuals http://publib.boulder.ibm.com/infocenter/db2help/index.jsp suggest that LOB's...
9
by: David W. Fenton | last post by:
See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center http://support.microsoft.com/?scid=kb;en-us;321076 This includes the Jet 4...
16
by: gumby | last post by:
I'm having trouble getting HADR to work with the sample databases on two HS20 xSeries blades, Red Hat ES4 up3, DB2 8.2.4, getting the following error. SQL1768N Unable to start HADR. Reason code...
6
by: RayRay | last post by:
I was hoping I might be able to get an answer regarding DB2 and HADR. Let me preface this by saying that I know very little about networking and I'm not familiar with the HADR product or...
3
by: Pat | last post by:
Hi - We're trying to set up an HADR pair on two databases on instances with different names on separate servers. The databases were defined as follows: CREATE DATABASE database1 ON...
1
by: lltong | last post by:
Hi all, I have 2 databases and both of them have db2 HADR set up. Now I will need to set up the bidirectional Q replication between those 2 databases. Is it a environment supported by db2? I can...
2
by: agentlease | last post by:
Hi, If the HADR state is 'Disconnected' and commit transactions to the Primary database, in the event of a Failover to the Standby database, how do we determine if it is safe i.e. how do we know...
3
by: radekus | last post by:
Hi all, I have a question, when we are doing DB2 replication or maybe doing DB2 HADR how to get know that the size/content/count of the data inside the database that have being replicate/HADR is...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.