Keep db2 tables in sync

Asked By jasonf frater 10 points N/A Posted on - 10/28/2012

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.

Regards,

Jasonf Frater

 

• Status: Open
• Question Views: 879
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Feedback

Answered By Ornelas Harris 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.

About Ornelas Harris

Questions
2

Answers
50

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 11/09/2012
• Question Category: Feedback