Rational Workbench for CLM setup

For example, if I use DB2, do I have to create databases for each of the products or is there any way to use one database for all products in the workbench?

Hi,

you need to create a database for each product that requires a database.
If you look at the install process, outlined and detailled with links in https://jazz.net/downloads/rational-team-concert/milestones/3.0M7a on the getting started tab: for every part of the installation where a database is required in the setup, you need a new database.

I remember Jazz, RTC, RQM, RDRP.

I think it makes sense to have several databases for scalability and more deployment options.

Ralph

For example, if I use DB2, do I have to create databases for each of the products or is there any way to use one database for all products in the workbench?

I have downloaded and installed Rational Workbench for Collaborative Lifecycle Management - Common Server
V 3.0 M7a (3.0.0.CALM-I20100716-0915) into a VM and I have started up the JazzTeamServer. Now, how do I start-up CPA, RTC, RQM, or DOORS RP? Once I found the right thing to install the CLM Workbench, the installation was easy.

Hi guys.
I'm in the 'same boat' with you trying to setup CPA and experience similar issues.
First I'm stuck on setting up RQM.
Could someone do me a favor and explain the meaning of the new value ( maybe it's only new for me :D ) rqm teamserver.property file:
datawarehouse.db.vendor. I didn't see it before in RTC.
My confusion is: should I have a separate db for datawarehouse which is different from repository db? Could I use the same db? I tried to create a new db for datawarehouse but repotool -createTables created tables only for repository db.
Any explanation would appreciated.
Thanks.

I'm configuring CPA on Windows system using build V 3.0 M8 (3.0.0.CALM-I20100812-1957) running on WAS, LDAP, DB2
It looks that I somehow went through all steps in instructions and get to the step 12 from https://jazz.net/wiki/bin/view/Main/CommonProjectAdminSetupNew
It states:
Go to https://clmwb:9443/admin/web#/config and set the following properties:

* clmServerUserId -> the JazzAdmins user ID you created as part of setup
* clmServerPassword -> the password for clmServerUserId
When I follow url https://<hostname>:9443/admin/web#/config I've got error:
**
Error 500: javax.servlet.ServletException: java.lang.NullPointerException
**
Could someone plz help me? It's really frustrating ... I suggest that I misconfigured admin.properties or friends.rdf files.
I'll paste both files here:
admin.properties
#
# CPA web app's complete URL, including JEE context root (no trailing slash).
#
# Tip: If you're using your local server, declare a loopback alias other than
# 'localhost' in /etc/hosts to avoid problems.
#
# Ex. https://clmwb:9443/admin
#
com.ibm.team.jfs.app.context.frontside.url=https://clmwb:9443/admin

#
# Jazz Team Server's root services URL. For more information on root services,
# see the specification at https://jazz.net/wiki/bin/view/Main/RootServicesSpec
#
# Note: You must also configure a "friends" connection for the Jazz Team Server
# via friends.rdf.
#
# Ex. https://clmwb:9443/jazz/rootservices
#
com.ibm.team.jfs.app.context.jfs.rootservices.url=https://clmwb:9443/jts/rootservices

#
# Storage area information. These values only need to be changed if multiple CPA
# instances are backed by a common JFS. Storage area resources are indexed using
# the front-side URL (com.ibm.team.jfs.app.context.frontside.url).
#
com.ibm.team.jfs.app.context.storage.area.name=com.ibm.team.cpa
com.ibm.team.jfs.app.context.storage.area.label=Jazz Common Project Administration
**
friends.rdf
<?xml version="1.0"?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:dc="http://purl.org/dc/terms/"
xmlns:jd="http://jazz.net/xmlns/prod/jazz/discovery/1.0/"
xmlns:jfs="http://jazz.net/xmlns/prod/jazz/jfs/1.0/"
xmlns:cpa="http://jazz.net/xmlns/foundation/cpa/1.0/">
<!--
friends.rdf - Common Project Admin application friends configuration.

Change the values below to correspond to the server names and OAuth
consumer information in your Jazz application group. Note that the
'rootServices' value for your Jazz Team Server friend entry should be
the same value as the 'com.ibm.team.jfs.app.context.jfs.rootservices.url'
property in the admin.properties file.

See also <server-root>/server/conf/admin/admin.properties

For full CPA setup instructions, see:
https://jazz.net/wiki/bin/view/Main/CommonProjectAdminSetup
-->


<jd:Friend>
<dc:title>Jazz Team Server</dc:title>
<jd:rootServices rdf:resource="https://clmwb:9443/jts/rootservices" />
<jfs:oauthDomain rdf:resource="https://clmwb:9443/jts" />
<jfs:oauthConsumerSecret>CHANGE_ME_SECRET</jfs:cpa>
<jfs:oauthConsumerKey>CHANGE_ME_JTS_KEY</jfs:bbeff75718ea4969a51dc53cbfb7e9f3>
</jd:Friend>

<jd:Friend>
<dc:title>DOORS Requirements Professional</dc:title>
<jd:rootServices rdf:resource="https://clmwb:9443/rdm/rootservices" />
<jfs:oauthDomain rdf:resource="https://clmwb:9443/rdm" />
<jfs:oauthConsumerSecret>CHANGE_ME_SECRET</jfs:oauthConsumerSecret>
<jfs:oauthConsumerKey>CHANGE_ME_JTS_KEY</jfs:oauthConsumerKey>
<cpa:capability rdf:resource="http://jazz.net/xmlns/foundation/cpa/1.0/RequirementsManagement" />
</jd:Friend>

<jd:Friend>
<dc:title>Rational Team Concert</dc:title>
<jd:rootServices rdf:resource="https://clmwb:9443/ccm/rootservices" />
<jfs:oauthDomain rdf:resource="https://clmwb:9443/ccm" />
<jfs:oauthConsumerSecret>CHANGE_ME_SECRET</jfs:cpa>
<jfs:oauthConsumerKey>CHANGE_ME_CCM_KEY</jfs:dcb18485e9634f4faff76c6e3cad4c27>
<cpa:capability rdf:resource="http://jazz.net/xmlns/foundation/cpa/1.0/ChangeConfigurationManagement" />
</jd:Friend>

<jd:Friend>
<dc:title>Rational Quality Manager</dc:title>
<jd:rootServices rdf:resource="https://clmwb:9443/qm/rootservices" />
<jfs:oauthDomain rdf:resource="https://clmwb:9443/qm" />
<jfs:oauthConsumerSecret>CHANGE_ME_SECRET</jfs:cpa>
<jfs:oauthConsumerKey>CHANGE_ME_QM_KEY</jfs:f0493fed29f14cb8a4ffcad6e0dceb79>
<cpa:capability rdf:resource="http://jazz.net/xmlns/foundation/cpa/1.0/QualityManagement" />
</jd:Friend>

</rdf:RDF>
**
thanks

I installed a V3.0M7a on a VM then I found CPU load roared to nearly 100% when the Jazz server was started.

I have to install V3.0M7a on a physical server.

I have downloaded and installed Rational Workbench for Collaborative Lifecycle Management - Common Server
V 3.0 M7a (3.0.0.CALM-I20100716-0915) into a VM and I have started up the JazzTeamServer.

On 8/14/2010 7:52 PM, evoldman wrote:

Hi guys.
I'm in the 'same boat' with you trying to setup CPA and experience
similar issues.
First I'm stuck on setting up RQM.
Could someone do me a favor and explain the meaning of the new value (
maybe it's only new for me :D ) rqm teamserver.property file:
datawarehouse.db.vendor. I didn't see it before in RTC.
My confusion is: should I have a separate db for datawarehouse which
is different from repository db? Could I use the same db? I tried to
create a new db for datawarehouse but repotool -createTables created
tables only for repository db.
Any explanation would appreciated.
Thanks.

I just became aware of this forum, sorry for the delay. Are you still
having issues setting this up with the beta? If so please follow up and
I'll do my best to help.

james
CLM Reporting Team Lead

I am also trying to set up cpa but having no luck so far.I was told when i got it that it would be easy and uncomplicated to set up but its as complicated as hell.My friend is really into computers but even he finds this hard to to.

I am also trying to set up cpa but having no luck so far.I was told when i got it that it would be easy and uncomplicated to set up but its as complicated as hell.My friend is really into computers but even he finds this hard to to.

Same boat here! Every step forward leads to two steps back. I will post on my progress as I (hopefully) figure things out.

Hi guys.
I'm in the 'same boat' with you trying to setup CPA and experience similar issues.
First I'm stuck on setting up RQM.
Could someone do me a favor and explain the meaning of the new value ( maybe it's only new for me :D ) rqm teamserver.property file:
datawarehouse.db.vendor. I didn't see it before in RTC.
My confusion is: should I have a separate db for datawarehouse which is different from repository db? Could I use the same db? I tried to create a new db for datawarehouse but repotool -createTables created tables only for repository db.
Any explanation would appreciated.
Thanks.

Hi Eliya

Can you confirm what database you are planning to use, Derby, DB2, something else..

anthony