Docs for Derby to DB2 migration v4.x
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
Accepted answer
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.
Comments
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
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.
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
John,
One other answer
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
