It's all about the answers!

Ask a question

Parallel Database for CLM


Amit Girme (1131723) | asked Jul 24 '15, 10:15 a.m.
 Hi,

We want to have a parallel database server for CLM so that if something goes wrong with our primary Database we can easily point CLM application to parallel database thereby reducing overall downtime.

How can we achieve his? As data will be added daily to primary database how this newly added data will be synchronised with Second Database server.

What are the Pro's and Cons of having two parallel databases?

Thanks in Advance!

One answer



permanent link
Simon Washbrook (67216) | answered Jul 24 '15, 10:28 a.m.
Hi Amit,

You probably want to read this page about CLM and High Availability before jumping to a database cluster.

Approaches to implementing high availability and disaster recovery for Rational Jazz environments
https://jazz.net/wiki/bin/view/Deployment/ApproachesToImplementingHAAndDR

If you search for DB2 clustering, you find quite a few articles about how to set-up parallel databases and you will learn how DB2 will synchronise they two databases automatically.

There a RedBook that goes into all the details you need:
http://www.redbooks.ibm.com/abstracts/SG246376.html

Enjoy, Simon

Comments
Amit Girme commented Jul 24 '15, 11:49 a.m.

 Hi Simon,


Thanks for the details.

We use SQL server 2008 as a database. In case of SQL can we setup parallel databases and how sql will synchronise two databases automatically?


Simon Washbrook commented Jul 27 '15, 2:32 a.m.

Hi Amit,
I'm not an expert in SQL server, however I suggest you start with this document on Microsoft's web site:

High Availability Solutions Overview
https://msdn.microsoft.com/en-us/library/ms190202%28v=sql.105%29.aspx

It states that "A SQL Server failover cluster instance appears on the network as a single computer, but has functionality that provides failover from one node to another if the current node becomes unavailable." So the database appears as a single server to RTC which probably means you do not have to modify anything in RTC for it to work.

It does go on to say that "A failover cluster does not protect against disk failure." so you will need to find a solution for this possible error condition as well.

Your answer


Register or to post your answer.