How to convert the server jobs into pX jobs

basu.ds · Post by **basu.ds** » Tue Feb 05, 2008 3:16 am

Hi Can any one help me that how to convert server jobs into PX jobs

ray.wurlod · Post by **ray.wurlod** » Tue Feb 05, 2008 3:48 am

There are two methods.

1. Analyze the logic of the server jobs and write parallel jobs to implement that logic. You could, of course, hire a competent consultant to do this.

2. Give IBM a lot of money to do the same for you. They call it (their "service") "conversion tools" but most of it is outsourced/offshored and performed by humans.

vmcburney · Post by **vmcburney** » Tue Feb 05, 2008 10:13 pm

Pick the low hanging fruit. Identify your longest and slowest jobs and convert those, leave the rest as server jobs. Server jobs and parallel jobs can co-exist quite happily and on smaller data volumes Server jobs may be faster due to faster start up times. Do the conversion yourself so you learn how parallel jobs work.