Server to PX Conversion/Migration

Govindarajan · Post by **Govindarajan** » Tue Nov 18, 2008 9:42 am

Is there any procedural way of converting all Server Jobs from 7.5.2 version to 8.0.1 version of PX, instead of re-creating equivalent PX jobs by manually?

Mike · Post by **Mike** » Tue Nov 18, 2008 10:12 am

You mean an automated procedural way? Not really.

Do you really need to convert all of your server jobs to parallel jobs? I would leave them as server jobs unless there is some compelling reason to change them.

Mike

ray.wurlod · Post by **ray.wurlod** » Tue Nov 18, 2008 3:15 pm

IBM do have some tools, but you have to buy the service and agree to your jobs being "off-shored". I support Mike's comment totally.

vmcburney · Post by **vmcburney** » Tue Nov 18, 2008 6:04 pm

Take the low hanging fruit approach. Leave them as server jobs and then convert those jobs that obviously need to run in parallel - the really long running bottleneck jobs. Redesign those jobs for parallel paying attention to where the sorts happen and what type of lookups you use - not something you would trust to a conversion tool.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 18, 2008 8:42 pm

The main tool for conversion is located between the keyboard and the chair.

Analyze the logic of the server job, identify need for parallelism (and for partitioning and sorting), then design a parallel job from scratch to re-create the logic of the server job. Forget everything you know about server jobs when doing this (or buy the Server to Parallel Transition Lab DVD from DSXchange Learning Center).