Importing JObs from 8.5 back into 8.1

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sparq
Premium Member
Premium Member
Posts: 21
Joined: Wed Jun 09, 2010 6:06 am
Location: Australia

Importing JObs from 8.5 back into 8.1

Post by sparq »

We have just installed 8.5 and are learning and testing it's capabilities. We successfully migrated very simple jobs from 8.1.2 into 8.5 and used the Oracle Connector Migration tool to convert Oracle Enterprise stages to Oracle Connector stages. It worked wonderfully and so simply.

We then decided to export the jobs from 8.5 back into our 8.1.2 project and received the follwoing error message:

Code: Select all

File C:\User\XBNEWDV16\LDG_IMPORT_TEST.dsx does not appear to be a valid DataStage export file or is from an incompatible release.

A valid DataStage export file is expected to be in Windows format (i.e. using CRLF line terminators).
We tried XML, DSX and DSX-7 formats all without success. We have previously been able to migrate from 8.1.2 to 8.0 and visa-versa so expected the same.

Your thoughts pls.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Internal formats were the same in 7.5, 8.0 and 8.1 (for example the major version number for jobs was 50 if I recall correctly).

The internal format is different in 8.5 (for example looping in Transformer) and the major version number for jobs is 56.

They are incompatible.

You could try editing the Server Version property in the DSX file, but no promises. You may get an import of at least those bits that are compatible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Have you tried the ISX format?
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

8.5 is definitely not downwards compatible at all. You cannot reliably export 8.5 jobs (even with manual tweaks to the DSX or ISX) and get them to load into any prior release. If you did manually force jobs to a lower release you would be breaking the terms of your customer service contract and your support provider could refuse to provide any service on the entire DataStage system, regardless of whether an individual job had been downgraded or not.

Even at earlier releases it was risky (you had to manually strip out stages or options that weren't supported in previous releases), but now its definitely not something you should ever do.

As far as 8.5 is concerned its a one-way trip!
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
Post Reply