Can 2 different RQM applications share same DB?
2 answers
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
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.
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
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