It's all about the answers!

Ask a question

Moving CLM 5.x from iSeries to Windows Server and Migrating from DB2 to SQL Server

Raj K (10221924) | asked Feb 17 '17, 4:26 p.m.
retagged Feb 24 '17, 4:48 p.m. by Ken Tessier (84117)


   I have done several CLM upgrades and migrations over the last 9 years. I am thinking of two scenarios I would like to discuss how we could do this.

1) Moving CLM 5.0.2 from iSeries to Windows 2012 server. Public URI will not change, the DB2 server will not change.
(In olden days we need to rebuild the indices or copy all the indices. *** The part is while we do this we will migrate from Full WAS to Liberty Profile.
2) Upgrading from CLM 4.0.2 to 6.0.3 (all Windows) and at the same time migrating from DB2 to SQL Server or as two steps.  


One answer

permanent link
Ralph Schoon (62.7k33643) | answered Feb 20 '17, 2:47 a.m.
edited Feb 20 '17, 2:48 a.m.

In general see 

Secenario 1 See, for backup. The issue here is the different architectures especially for at e databse. See for how to migrate DB's - basically you will have to export the DB and then import it.

Scenario 2 is basically an upgrade and  explained in the interactive upgrade guide. One step in the upgrade would be similar to scenario 1. 

Raj K commented Feb 20 '17, 5:46 p.m. | edited Feb 20 '17, 5:47 p.m.

Thanks for the response.   didn't work and gets me to a page "cannot find" error.

When we migrate CLM application from IBM i (Full WAS) to Windows 2012 server (Liberty Profile) I am listing things to do.
A) I am thinking a two step Migration. CLM 502 Platform Migration from IBM i to Windows. (Can I switch from full WAS in IBM i to Liberty Profile CLM 502)
B) Upgrade from 502 to 603 in the Windows Environment. (Final resting place for CLM 603 should be liberty profile instead of the Full WAS).

Steps I am thinking :
1) Install CLM 502 in Windows Servers & Reverse Proxy. Switch the DNS alias pointing to the new IHS Reverse Proxy Server machine.
Question:  Can we use liberty Profile in 502 as eventually have to migrate from 502 to 603 after moving to Windows environment?  or should I switch from Full WAS to Liberty profile during my migration from 502 to 603 all in Windows environment?

Raj K commented Feb 20 '17, 5:47 p.m.

2) Copy the, *.rdf &, the indices directory and LDAP settings from IBM i to Windows 2012 servers for RM, CCM   etc.
3) The existing databases on DB2 for i shouldn't need change to connect from Windows Environment (except the drivers that needs to be on the windows side)? 
4) Start the application servers  & run through setup.

Is this enough to make the platform migration be successful?
Final step is Upgrade from CLM 502 to CLM 603.

Raj K commented Feb 20 '17, 5:49 p.m.

BTW, the backup procedures are almost very old. Is there a more updated version of Backup for CLM  502 & 603?

Ralph Schoon commented Feb 21 '17, 2:06 a.m.

Backup: There is not, except additional nodes there are not a lot of changes I am aware of. I use the same strategies successful for years now. If you don't have a proven backup and restore strategy yet, I would suggest to hurry up and get one.

I would suggest to test the upgrade is actually working, before you do the final one. You can use Liberty, you should make sure to understand Liberty and the settings you need e.g. LDAP, so run a test setup.

Your answer

Register or to post your answer.