It's all about the answers!

Ask a question

Converting from Derby Database to DB2 for RQM


anoop mc (74811200221) | asked Apr 08 '10, 10:38 a.m.
Hi,

We have installed and Configured RQM with Derby Database and now we are in the process of converting Derby Database to DB2.

Referring to one of the document which said

"Run repotools to copy the contents of the Jazz repository from the Derby database described by teamserver.properties to the DB2 database described by teamserver.db2.properties.

The scripts, repotools.sh for Linux, and repotools.bat for Windows are packaged in the directory JazzInstallDir/server. The following is an example command using repotools. See the repotools documentation for more information.
repotools -copy toFile=temp.tar target.teamserver.properties=teamserver.db2.properties"

After running the command

I am getting the below error message
C:\Program Files\IBM\RQM20\server>repotools -copy toFile=temp.tar target.teamser
ver.properties=teamserver.db2.properties
Repo Tools
Rational Quality Manager, Version 2.0.0.1 (I20091024_1657)
Jazz Foundation - Jazz Team Server, Version 1.0.0.1 (I20090914-1300)

Rational Jazz Team Server (RQM) - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: repositoryDB
CRJAZ1364I Initial database connection successful
Db Product Name: Apache Derby
Db Product Version: 10.3.3.1 - (677131)
Db URL: jdbc:derby:repositoryDB
Jdbc Driver Name: Apache Derby Embedded JDBC Driver
Jdbc Driver Version: 10.3.3.1 - (677131)
CRJAZ8192I: Fulltext Index Location: C:\Program Files\IBM\RQM20\server\workitemi
ndex\fulltext_index
CRJAZ8190E: The fulltext index location property (indexLocation) should point to
an absolute directory but is currently set to 'workitemindex'
CRJAZ1205I The URL "file:teamserver.db2.properties" is not valid or cannot be op
ened.

Any suggestions please

3 answers



permanent link
Joerg Moeller (9677) | answered Apr 13 '10, 11:25 a.m.
I'm having the same problem.

Regards
Joerg

permanent link
Joerg Moeller (9677) | answered Apr 13 '10, 11:30 a.m.
Try the complete filename like

target.teamserver.properties="C:\Program Files\IBM\JazzTeamServer\server\conf\jazz\teamserver.db2.properties"

That worked for me ;-)

Regards
Joerg

permanent link
Sergio Polastri (3111515) | answered Aug 26 '10, 10:54 a.m.
Try the complete filename like

target.teamserver.properties="C:\Program Files\IBM\JazzTeamServer\server\conf\jazz\teamserver.db2.properties"

That worked for me ;-)

Regards
Joerg


doesn't work for me... any help?

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.