Any experience with the MSSQL 2008 R2 Migration to DB/2 10.1? (CLM 4.0.7 to 5.0.2)
Hi,
we have a customer who currently uses CLM 4.0.7 with a MSSQL 2008 R2 database.
They also use WAS 7 at the moment.
Now they want to upgrade to CLM 5.0.2 (after GA) and need to upgrade the database and WAS as well.
What is the general sequence for this upgrade? As far as I have understood, it should be like this:
- Upgrade MSSQL2008 to MSSQL 2012
- Upgrade WAS 7 to WAS 8.0.x or higher
- Upgrade CLM from 4.0.7 to CLM 5.0.x
- Install DB2 10.1 and setup all the necessary CLM Databases (ccm, qm, rm, dw, etc.)
- Run repotools -addtables to upgrade the data model in MSSQL 2012
- Use repotools -export to create the .tar file out of MSSQL 2012
- Use repotools -import to put the .tar file into DB2 10.1
Are these steps correct?
Has anyone done this yet?
Is it possible to do the migration directly from MSSQL 2008 to DB2 10.1 without first upgrading to MSSQL 2012?
Thanks,
Ruben
we have a customer who currently uses CLM 4.0.7 with a MSSQL 2008 R2 database.
They also use WAS 7 at the moment.
Now they want to upgrade to CLM 5.0.2 (after GA) and need to upgrade the database and WAS as well.
What is the general sequence for this upgrade? As far as I have understood, it should be like this:
- Upgrade MSSQL2008 to MSSQL 2012
- Upgrade WAS 7 to WAS 8.0.x or higher
- Upgrade CLM from 4.0.7 to CLM 5.0.x
- Install DB2 10.1 and setup all the necessary CLM Databases (ccm, qm, rm, dw, etc.)
- Run repotools -addtables to upgrade the data model in MSSQL 2012
- Use repotools -export to create the .tar file out of MSSQL 2012
- Use repotools -import to put the .tar file into DB2 10.1
Are these steps correct?
Has anyone done this yet?
Is it possible to do the migration directly from MSSQL 2008 to DB2 10.1 without first upgrading to MSSQL 2012?
Thanks,
Ruben
One answer
Hi Ruben -
The steps you propose will work but you could switch to DB2 10.1 while at CLM 4.0.7 to save yourself the unwanted upgrade to MSSQL 2012.
I checked here: https://jazz.net/wiki/bin/view/Deployment/CLMSystemRequirements405406#A6_1_Database_Non_Clustered_Supp
to be sure DB2 10.1 is supported at CLM 4.0.7 (support was added in CLM 4.0.3).
Also - you can make the switch from WAS 7 to WAS 8 for CLM part of the CLM upgrade in the sense that you can leave the old profile (CLM4) in WAS 7 and create the new profile (CLM5) in WAS 8. This may or may not be approriate for your environment depending on what other applications you have deployed to WAS and if you have the resources to have 2 WAS deployments (WAS 7 and WAS 8).
We do test repotools-xxx -export and -import but on smaller databases. Will you be able to do a test run in order to determine the amount of downtime you will need for the import? That is, bring the server down to do the exports, bring the server back up for production use and on a separate install configured to use DB2 10.1, perform the import? In order to do any testing post-import, this test will have to be in a staging environment such that the URLs embedded in the data can be used safely without interrupting production work. See: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Ft_prepare_staging_env.html for more information on preparing a staging environment.
Let me know if you have additional questions -
Gail Burati