Keep db2 tables in sync

Asked By 10 points N/A Posted on -

Hi Experts,

I have database tables and trying to sync. I would like to know how to keep db2 tables in sync? Please suggest me with proper guidance. Thanks.


Jasonf Frater


Answered By 5 points N/A #166538

Keep db2 tables in sync


There are number of ways by which you can keep two db2 tables in sync.

1. DB2 Replication.

2. Standby database using Log Shipping.

3. HADR (It is new in Stinger).

4. Hardware HA (using Sun Cluster / Veritas Cluster / HACMP / etc.)

5. Stop db2 on both nodes and then run rsync on instances, fenced and admin home directories. When done, restart db2.

HADR would be the best way to keep 2 DB2 databases in sync. When you use with the new client, just re-route and it should minimize any possible downtime.

This link has some more information on this topic.

I thought it would be useful for you.

Check it out.

Login/Register to Answer

Related Questions