datastage jobs migration from 8.1 to 9.1

deesh · Post by **deesh** » Tue Oct 15, 2013 2:49 am

Hi

Can any one help to me on migrating datastage jobs from 8.1 to 9.1 version, how to do migration on windows OS.

ArndW · Post by **ArndW** » Tue Oct 15, 2013 2:53 am

The topic is too big and the question a bit vague to know where to begin.

99% of porting from 8.1 to 9.1 will work seamlessly and flawlessly; perhaps even 100%. There is no need to convert your jobs as DataStage is designed to be backwards compatible.

Is this upgrade for an existing system in production? Do you need to ensure that output is identical between old and new? Do you have second maching for parallel testing?

These are just a couple of initial questions to get you thinking about what might need to be done. Once you know your requirements better you can then ask specific questions.

deesh · Post by **deesh** » Tue Oct 15, 2013 5:33 am

Hi,

At present we are developing jobs in 8.1 version, but we are planning to get 9.1 license.

So after completion of our development in 8.1 version, we are going to migrate this jobs directly into 9.1 datastage production server.

Migration : 8.1 (Development) to 9.1 (Production).

For this assignment, want to know the steps.

chulett · Post by **chulett** » Tue Oct 15, 2013 7:42 am

1. Export from 8.1
2. Import into 9.1

Are you sticking with this configuration? Doing all of your development in an older version and then running the new version only in Production?

ArndW · Post by **ArndW** » Tue Oct 15, 2013 8:40 am

chulett wrote:1. Export from 8.1
2. Import into 9.1

3. Recompile

Then Bob's Your Uncle

deesh · Post by **deesh** » Wed Oct 16, 2013 2:37 am

Hi Craig,

So, There is no problem in migration from 8.1 to 9.1 just need to do like early version.

If is there please share with me, because i dont know the architecture of 9.1 version.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 16, 2013 3:05 pm

There's no big changes to the archtecture, except that you may choose to implement another database for the DataStage Operations Console.

jdinero · Post by **jdinero** » Fri Oct 18, 2013 1:08 pm

I was told by IBM that certain functions behave different from 8.7 and 9.1. For sure, oconv and iconv have different parameters or something. I was also told to expect a significant performance hit for Server jobs from 8.7 to 9.1 (but not parallel jobs).

I am currently testing our 9.1 and running both 8.7 and 9.1 concurrently in unix.

Good luck,

Jennifer

ray.wurlod · Post by **ray.wurlod** » Fri Oct 18, 2013 2:26 pm

jdinero wrote:I was told by IBM that certain functions behave different from 8.7 and 9.1.

Can you get any more information about these? It's a terribly vague assertion not really backed up by "what's new in this release" documentation.

chulett · Post by **chulett** » Fri Oct 18, 2013 2:52 pm

I'd be shocked if foundation functions like OConv and IConv changed in any 'breaking' manner. Perhaps they would add additional optional parameters or functionality but they would be doing themselves some major damage if those functions behave differently in any detrimental sense.

Do you have any details on that as well?

vmcburney · Post by **vmcburney** » Fri Oct 18, 2013 5:19 pm

The architecture of 8.1 and 9.1 is the same but you do get some new free apps of information asset manager, blueprint director and operations console. These may require extra install steps if you want to use them. You can also move to 64 bit windows and you don't need the MKS emulation. You may be looking at a complete upgrade of IIS, operating system and database to get a faster engine.

If you have been paying your annual support then you do not need a new license, just go into passport advantage and download the latest version of the software.

There is a migration assistant but inmy experience it was easier to do a standard uninstall install import. Have a look at the operating system requirements for 9.1.

eph · Post by **eph** » Mon Oct 21, 2013 3:13 am

Hi,

I guess you are looking for that kind of documentation : technote 1459416.

I didn't found an updated version, but for example null handling has changed between 8.1 and 9.1 (in stage variables etc.), and some functions do not behave like in 8.1 (see the documentation about isvalid and its variable to revert to 8.1 behavior).

You may consider involving the ibm concierge program for your upgrade.

Eric

priyadarshikunal · Post by **priyadarshikunal** » Mon Oct 21, 2013 6:57 am

Also if you are working on SAP Plugins then you might need to do some extra work on converting from CPIC to RFC. IBM provided a tool to do that but you may need to do some additional testing and fixing.

ArndW · Post by **ArndW** » Thu Oct 31, 2013 1:55 am

Those 4 points are, as you surmised, not specific to going from one version of DataStage to 9.1, but are NLS issues that are not version specific.

jdinero · Post by **jdinero** » Thu Oct 31, 2013 11:37 am

Ok, thanks.