DSXchange

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

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

Hi Ray,

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

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

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

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.

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!

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.

Thanks craig!

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/