Migrating jobs from v 7.5.1 to IIS v8.1

sheema · Post by **sheema** » Wed Feb 11, 2009 10:33 am

Right now we are using datastage 7.5.1, we are planning to get the new version
IISv8.1 . Has any one migrated their jobs from 7.5.1 to IIS v8.1.
Can you please let me know what are the things to be taken care of for this migration.
If you have faced any problems migrating what where they?

Thanks
sheema

mekrreddy · Post by **mekrreddy** » Wed Feb 11, 2009 1:02 pm

I can help you but let me know what kind of migration are you doing, is that migration to new server with 8.1 installed? Or are you upgrading the 7.5 server with 8.1?

sheema · Post by **sheema** » Wed Feb 11, 2009 2:11 pm

we will be migrating all jobs in 7.5.1 into a new server which has 8.1 installed on it.

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 11, 2009 4:35 pm

Export/import is the approved technique.

devanars · Post by **devanars** » Wed Feb 11, 2009 7:57 pm

Yes Export/import is only the procedure and have to compile once imported in 8.1 version.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 12, 2009 2:27 pm

When someone says "installed" I assume that that includes setting up and testing database connectivity (perhaps even installing, configuring and testing database client software on the new DataStage server if applicable), because there would be no point in proceeding unless this had been done.

There are some components that don't get exported, such as hashed files (if you have server jobs that use these), scripts and message handlers. You need to "make arrangements" to have these moved.

sheema · Post by **sheema** » Thu Feb 12, 2009 2:32 pm

Thanks mekrreddy for your help.

Did you copy the Configuration file and the parameters file too.
How did you do that.

Any thing else which has to copied in this migration

vmcburney · Post by **vmcburney** » Thu Feb 12, 2009 9:40 pm

The only problem I've had is that it takes 3-30 days to install 8.1. 3 days if you have experts helping you or you have carried out every prerequisite and nothing goes wrong. 30 days if you don't have any experts and something goes wrong. I think it's worth paying for IBM to come in and install.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 12, 2009 10:27 pm

Even one of the IBM experts needed more than ten attempts to upgrade from 8.0.1 to 8.1. Wild horses could not extract that expert's name from me.

sheema · Post by **sheema** » Fri Feb 13, 2009 7:45 am

Thanks for the expert opinion.

mekrreddy · Post by **mekrreddy** » Fri Feb 13, 2009 8:52 am

Installing Version 8.1 is easier than installing Version 8.0.1 as V 8.0.1 has 13 patches. As you are migrating from 7.5.1 to 8.1, the process would be easy. Installing the server would take couple of hours and configuring the installation would consume more time, I suggest you go through the guide provided with the application which would help you a lot.

If you have admin access to the tool of both versions, then go to environment in project properties and make sure you define same in 8.1 as 7.5 under User Defined Environment variables with little changes to the paths mentioned.

Datastage Export/Import would take care of parameters defined.

Sql statements does not work exactly as of 7.5 in 8.1 when you join tables of Oracle database with higher version Oracle client connector. Works fine when I tried using Toad or Sql Plus but not in the stage.

Make sure Sql statements work in 8.1 from 7.5 once you are good with connectivity with database.

sheema · Post by **sheema** » Fri Feb 13, 2009 9:09 am

Thanks for the inputs mekrreddy, I will keep posting as and when we encounter any issues if you can help us resolve the problem.

Thanks again for your help.

chulett · Post by **chulett** » Fri Feb 13, 2009 9:52 am

mekrreddy wrote:Sql statements does not work exactly as of 7.5 in 8.1 when you join tables of Oracle database with higher version Oracle client connector. Works fine when I tried using Toad or Sql Plus but not in the stage.

Could you expand on this, please?

RodBarnes · Post by **RodBarnes** » Fri Feb 13, 2009 2:34 pm

ray.wurlod wrote:Even one of the IBM experts needed more than ten attempts to upgrade from 8.0.1 to 8.1. Wild horses could not extract that expert's name from me.

I had the opportunity to install 8.0 before it became 8.0.1. That took three months to work out all the bugs in the installation process.

I didn't have an IBM person on site but he had a remote connection to the server and between us we finally got it configured and working. In fairness, it wan't a DataStage issue but IIS install/configure issue on Windows 2003 with the new IIS infrastructure and webSphere overhead. We ended up uninstalling it (it was installed solely for review) and rebuilding the server.

Just last week I had time to install the latest 8.0.1. I was told that, even though it was still 8.0.1, the install process had been significantly revamped from earlier releases of 8.0.1. I was able to get it installed and configured very easily compared to the prior experience. I haven't done a lot of testing but have been successful building, compiling, and excuting jobs as well as importing from 7.5.

Planning to upgrade this server to 8.1 when I can get my hands on it.

JoshGeorge · Post by **JoshGeorge** » Tue Feb 17, 2009 3:42 pm

DSParams file to be copied from 7x to 8.1 ????

sheema wrote: Did you copy the Configuration file and the parameters file too.
How did you do that.

mekrreddy wrote: Datastage Export/Import would take care of parameters defined.