8.7 to 7.5 conversion

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

8.7 to 7.5 conversion

Post by clarcombe »

I have a server job that I wrote in 8.7. This now has to be ported to a 7.5 server.

I tried just changing the header and importing it but I managed to corrupt the project and then had to have it restored :oops:

I thought I had done this successfully for 8.1 to 7.5 but it seems 8.7 has added a whole new sequence of flags.

Question
Is there a way of retrograding a job to work with a previous version
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Did you import the whole project or just the one job and corrupted the project? I've retro-imported jobs several times and as long as they didn't use functionality not available in the version to which I imported the jobs they worked fine (although often I'd get warnings during the import process). I do know that one needs to change some subtle keywords in the header so that the file format is recognized, I believe they changed one keyword in a line from singular to plural or vice-versa but you've probably seen that already.

Is it a server or a Parallel job and does it use uncommon stages?
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Post by clarcombe »

No, its just one 8.7 server job using Hashed, text files and Oracle. I can't risk importing again without knowing exactly what I have to change.

I changed the header completely with the 7.5 header.

Is there a list of what I must change?

Thanks
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
Mike
Premium Member
Premium Member
Posts: 1021
Joined: Sun Mar 03, 2002 6:01 pm
Location: Tampa, FL

Post by Mike »

I'd guess the Oracle stage is the most likely problem.

You should create yourself a sandbox project for experimentation like this...

You might need to take out the Oracle stage and rebuild it in 7.5.

If it's just one job, you could just rebuild the whole thing in 7.5.

Mike
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Post by clarcombe »

As it is only one job, I will recreate it. But if anyone has any foolproof methods, I am all ears
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

No, I don't have a foolproof method and will keep your problems in mind next time I need to retrograde a job from 8.7 downwards. I had always assumed that if the job was imported it would work but that seems to no longer be true.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Trust me, it doesn't take much of a mistake to corrupt a project. Been there, done that, got the t-shirt. :oops:

In my case, it was a simple typo with regards to the category of the job which took the help of the awesome Karen Powers to resolve. Your issue may not have been any issue with the job itself but perhaps something in your replacement of the header itself. [shrug]
-craig

"You can never have too many knives" -- Logan Nine Fingers
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Post by clarcombe »

I have rewritten the job. Surely, it would not be too much to ask, to have IBM create a <FROM> version to <TO> version.

If I had half a mind I would do it myself, but it is friday...
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
kwwilliams
Participant
Posts: 437
Joined: Fri Oct 21, 2005 10:00 pm

Post by kwwilliams »

I can't think of a software platform that allows one to go from a higher version of software to a lower vesion of the same software. There is a lot different between 7.5 and 8.7 that would perrclude a simple from this version to that version tool. You may be able to build a job in 7.5 and port it to 8.7, but I can't conceive that the other way would ever work.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Going backwards has never been supported, but usually worked when jobs didn't use features not present in the earlier version. Backwards compatibility has always worked and been supported; we could probably load V5 and earlier server jobs on 8.7 and they would work.
It does look like we've reached a version where changes to the .dsx have become significant enough to not enable this (unsupported) modification of .dsx headers to allow forwards compatibility.

p.s. Craig, Karen and I did ATS for UniVerse together for a while, we had our own office in Westboro. It was funny, people would be afraid to come in and talk to her or call her on the phone since she could be very acerbic with what she considered to be "silly questions"; but she really knew her stuff back then and has gotten even more knowledgeable over time. But she can still be very formidable (comes from being the only girl with something like 8 older brothers!).
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

p.p.s. Sorry for continuing the off-topic-ness of this but I always enjoyed talking to Karen and she liked the "interesting" problems I would send her way on occassion. And dang, she knew that sh...tuff inside and out, down all the way to the internals. If you get a chance Arnd, pass along a "hi" from me. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply