Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Docs for Derby to DB2 migration v4.x

Questions
Tags
Users
Badges
john norris
(207●3●40●44) Sep 05 '13, 5:19 a.m.

Hi, I am migrating data in a Derby to DB2. RTC 4.0.1. On Linux.

The manual at Installing > Installing the Rational solution for CLM > Setting up the database > Setting up a DB2 database, section 3 states "Important: Run the createTables command only if this is a new installation". This is not a new installation of RTC but they are new DB2 databases. So the comment is a little obscure (to me!). Do I need to run createTables?

Also in sections 2g and 2h, why do the values need to change to full pathnames? And does this apply to Linux or only Windows (which are used in the examples)?

Regards,

John

0 votes

2 answers
7,103 views
0 votes

Accepted answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) Sep 05 '13, 6:09 a.m.
John,

please refer to the product help: https://jazz.net/help-dev/clm/topic/com.ibm.jazz.install.doc/topics/c_migrate_overview.html in the Upgrading and Migrating section to how to change the database vendor.
john norris selected this answer as the correct answer

1 vote

Comments
john norris
Sep 05 '13, 7:39 a.m.
Hi Ralph, thanks for the quick reply. I did read that - as I mentioned above it is problems with the actual help that I was asking the question on. The link you gave are the latest notes but they are the same as the ones I read. So my questions are really very specific to the notes whose link you posted. Regards, John

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Sep 05 '13, 7:56 a.m.
The point the help is making, is: don't run the -crateTables against a DB that has content. If you do, your content is gone. If you move from Derby to another vendor, you have to do a repotools export of your db's. Then you need to set up your new target databases and finally do a repotools import of your exported DB's. Since your new DB is empty, you can safely run a create tables, and I think you have to. I am not sure if the DB import with repotools runs a -createtables, if it does, no harm done if your DB has them already.

john norris
Sep 05 '13, 12:16 p.m.
Thanks Ralph, the problem for me was using "new installation" - to me installation means RTC whereas if "new databases" had been used then that would have been clearer. Have you any ideas on the other part of my original question about the indices entry in the teamserver.properties file described in sections 2g/2h of this page in help. Regards, John

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Sep 05 '13, 1:56 p.m.
John, As long as you keep the index files where they are, or move them somewhere else and fix the properties, you should be fine.  There is a backup article in the deployment wiki with gory details. And a library article.  The index files just need to be consistent with the export of the DBs. I would suggest to chose an absolute path outside of the server install folders. Just in case you upgrade and want to delete the old files you won't accidentally delete the index files and then have to reindex.

One other answer

Permanent link
john norris
(207●3●40●44) Sep 05 '13, 12:30 p.m.

Actually it looks as though repotools -import does create the tables as I get this message

Do you wish to continue? Enter Y to confirm.
y
Creating the tables for the database ....;" without indices.

Perhaps the without indices comment goes back to my question above about the indices value in the properties file

0 votes

Comments
Kevin Ramer
Sep 05 '13, 3:19 p.m.
I think those indices are actually table indexes for the db2 tables.

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Sep 05 '13, 5:19 a.m.

Question was seen: 7,103 times

Last updated: Sep 05 '13, 3:19 p.m.

Confirmation Cancel Confirm