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

CLM migration due to O/S upgrade

Questions
Tags
Users
Badges
Cliff Sadler
(62●1●7●17) Jun 10 '16, 2:18 p.m.

We are moving a current CLM 6.0.1 IFIX 01 deployment from Server2008 to Server2012, which requires a re-install of all products.

I have followed the closest subject I can find about migrating databases found here:

https://www.ibm.com/support/knowledgecenter/en/SSYMRC_6.0.1/com.ibm.jazz.install.doc/topics/t_migrate_dbs.html

I have exported the .tar files for JTS, CCM, and RM using repotools on the 2008 server.

I have installed CLM 6.0.1 on the new server, and have installed DB2, and created the databases.

Now the question is, do I first run Custom Setup to connect to the DB2 databases (which will prompt me to create tables for each database), or do I instead run repotools-xx -import for each database?  I would have to manually edit the teamserver.properties file for each database first to comment out Derby, and enable DB2.

I'm not sure what will get created during custom setup vs. the imported .tar files.  do the tables have to be created before you import tar data?  The page referenced above would lead me to think no, but I don't know what I don't know at this point.

Then another issue.  What about the IFIX patch to bring it to 01?  can I import the .tar data first, and then do the ifix patch, or do I have to do that prior to restoring my data?  In order to install the patch, I will have to start the servers at least, and then what? run setup?  No sure of the interaction between an Ifix patch and the data tables.

0 votes

1 answer
2,686 views
0 votes

Accepted answer

Permanent link
Shubjit Naik
(1.5k●1●6●13) edited
Jun 13 '16, 4:07 a.m.
 Hi Cliff

First, you have to make sure the CLM URL remains the same post migration as well. 

You dont have to run the setup again. You need to copy over the conf directory from the CLM installation to the new installation directories which includes the teamserver.properties and the indices folders as well.
If there are changes in the DB names and host, you can edit teamserver.properties and then run the repotools import.

The recommended way to migrate the data is not through the repotools export command, but DB2 backup and restore. For the application migration, you need to copy over the conf directory.

You can apply the IFIX patch first and then run repotools import. 
Cliff Sadler selected this answer as the correct answer

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jun 13 '16, 4:39 a.m.

Also see https://jazz.net/wiki/bin/view/Deployment/BackupCLM for information about the data needed.

Cliff Sadler
Jun 13 '16, 7:47 a.m.

The info I was missing I believe is in the updated BackupCLM.  when I visited this last, there was no info on Liberty, and what to backup and move to the new installation.

Had it all installed, and running, but couldn't login as a user as the Liberty Profile registry and configuration files hadn't been copied over.  I mistakenly thought that information was stored in the JTS Database.

I'll post up if I run into any other issues, but I think this may do it.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jun 13 '16, 8:08 a.m.

I did the update last Friday...... 8)
Please let me know if I missed a file. The application.xml only needs to be backed up if you changed it manually e.g. to add an application.

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
× 7,495

Question asked: Jun 10 '16, 2:18 p.m.

Question was seen: 2,686 times

Last updated: Jun 13 '16, 8:08 a.m.

Confirmation Cancel Confirm