It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,953
×13
×4

question asked: Oct 07 '12, 8:26 p.m.
question was seen: 4,829 times
last updated: Oct 10 '12, 4:54 a.m.

Related questions

Can 2 different RQM applications share same DB?

1
Bharat Patel (81●12●39●43) | asked Oct 07 '12, 8:26 p.m.

We have installed RQM 4.0 in 2 different machine. i.e. Machine 1 and Machine 2.

Can this two RQM  application connect to same Database? I mean two RQM application can share same Database?

2 answers

Most liked answers ↑|Newest answers|Oldest answers

2
permanent link
Jared Russell (1.3k●1●20●19) | answered Oct 08 '12, 5:30 a.m.
edited Oct 08 '12, 5:31 a.m.
 Database server yes, physical database no*.

When you connect a Jazz based app such as RQM to a database the application generates a unique ID which is stored in both the database itself, and the teamserver.properties file of the application. If the second machine then tries to connect to the same DB it will see that the DB already has an ID and give you an error about the repo lock ID not being correct.

Even if you were to connect two machines to the same DB, you would likely encounter all sorts of concurrency issues as the applications would be caching stale data.

* I believe the only exception to this is if you're running the servers in a cluster in which case there are certain steps you can take to allow each node in the cluster to connect to the same DB.
Comments
Bharat Patel commented Oct 09 '12, 2:58 p.m. | edited Oct 09 '12, 2:59 p.m.

To give you more background, We are doing PoC for Load Balancer with 2 RQM applicaiton will connect to same DB. So if one RQM application goes down then 2nd will be up. In this scenario can 2 different RQM application share same DB? If so Can you please share if any special configuration is required for Load Balance.

We are not using any clustering.

0
permanent link
Stephane Leroy (1.4k●1●4●9) | answered Oct 10 '12, 4:54 a.m.
JAZZ DEVELOPER
Humm... If you're not using clustering, you'd need to choose for the manual failover solution (with a primary and a backup server) depicted in the following article :
https://jazz.net/library/article/722
In such configuration both (primary and backup) servers do point to the same (physical) database but please note they shall NEVER access it at the same time.

Adding this related [InfoCenter] article :
"Planning an idle standby deployment for crash recovery":
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Ft_planning_idle_standby_deployment.html

Regards,
Stephane Leroy - Jazz Jumpstart


Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.