Server job to parallel job conversion

pandeesh · Post by **pandeesh** » Sat Apr 09, 2011 12:05 pm

Is there any methods/tools/best practices to convert a server job to parallel job?

ray.wurlod · Post by **ray.wurlod** » Sat Apr 09, 2011 4:18 pm

Analyse what it does and write it as a parallel job having regard to issues like partitioning and sorting.

pandeesh · Post by **pandeesh** » Sat Apr 09, 2011 10:45 pm

Hi Ray,

Do any vendors developed any tools for autmating the server to parallel conversion?

zulfi123786 · Post by **zulfi123786** » Sun Apr 10, 2011 4:06 am

There are utilities to convert one stage to another ex:- replace DB2 with teradata by tweaking the *.dsx file. But i guess there are NO tools for converting a server job to parallel job.

Ray must be having more details

pandeesh · Post by **pandeesh** » Sun Apr 10, 2011 4:10 am

Thanks zulfi!!

Can you give more details about the utilities to convert one stage to another stage?

(i.e) i would like to replace a hashed file stage by lookup file set stage.

Thanks

zulfi123786 · Post by **zulfi123786** » Sun Apr 10, 2011 5:50 am

These utilities are none but unix scripts(java/.net) programs that read a .dsx file in XML format and replace the content related to one stage with another stage (along with their associated properties). You can't apply the same for converting a server job to Paralle job (replacing hashfile with look up fileset).

you have to go through the content of the server job understand what it does and redo the desing with a parallel job by replacing the server stages with corresponding PX stages.

chulett · Post by **chulett** » Sun Apr 10, 2011 7:38 am

pandeesh - do me a favor and save me some work cleaning up after you all the time. There's absolutely no need to quote everything when you reply to something. There's a perfectly good Reply to topic link, please make use of it unless you really need to quote a portion of a previous text to highlight or clarify your anwer or question.

Thanks!

chulett · Post by **chulett** » Sun Apr 10, 2011 7:44 am

Now that that is out of the way, as noted there really isn't a way to reliably convert Server jobs to Parallel jobs. I believe that IBM Consulting may have some tools they've built over the years that could do some of the work but that's only for when you pay them to come in and convert them for you and then do all of the finish work to make them actual viable jobs.

As noted, the only true solution is wetware based, not software based. A person needs to understand both methodologies, the strengths of both products so they can look at one and know the best way to build something equivalent or better in the other... whichever way you need to go, or whatever tool you are converting from/to.

pandeesh · Post by **pandeesh** » Sun Apr 10, 2011 8:14 pm

Thanks craig!

jhmckeever · Post by **jhmckeever** » Thu Mar 10, 2022 4:20 am

It's a super-old topic, but anyone stumbling over this question many years later may be pleased to know that an automated conversion is about to be released. Read more at: http://s2px.mettleci.io/

DSXchange

Server job to parallel job conversion

Server job to parallel job conversion

Re: Server job to parallel job conversion