Server to PX conversion

cbres00 · Post by **cbres00** » Thu Sep 23, 2004 1:51 pm

Is there a way to easily convert a server job to a PX job?

Regards,
Cathy

kcbland · Post by **kcbland** » Thu Sep 23, 2004 2:22 pm

No. The number of qualifiers are too numerous, you're better off contemplating the design intent and going back to the functional requirements.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 23, 2004 3:47 pm

No.

There are limited ways in which server jobs can be incorporated into parallel jobs (see Parallel Job Developer's Guide, end of Chapter 2), but there's a performance penalty for doing it this way, and many restrictions on the type of server job that can be so encapsulated.

You're better off, if you need PX, to evaluate the algorithm and then to implement it purely using PX stage types.

There is also the alternative of multiple instance versions of your server jobs; you need to look after the data partitioning rules yourself, through the use of job parameters.

vbeeram · Post by **vbeeram** » Thu Sep 23, 2004 5:57 pm

Hi,
we can do while encrypting the server job in a Shared Container then we can call that into PX.

Regards
beeram

ray.wurlod · Post by **ray.wurlod** » Fri Sep 24, 2004 1:34 am

This is only true if certain restrictions are not violated. The restrictions are documented in the Parallel Job Developer's Guide.