Calling DataStage Routine from Parallel job

[memrinal]

Hi,
I have a DataStage Server routine which i need to call from a PX job. I tried using everything including using transform for the same but nothing worked. can there be a round about way to call a routine from the PX job.
Currently i am using a server shared container for the purpose but would like inputs from all you people about a better way to do the same.
Thanks in advance
Mrinal

[Eric]

You can't without using a server shared container ot the Basic Transformer on the Parallel canvas. (except for before/after routines) Either way your mixing server and parallel which can reduce the performance. For best performance you would be best to write a builop/PXRoutine that does the same task.

[Sainath.Srinivasan]

If the routine is built and tested, you can create a shared container of the a server transform stage and incorporate the shared container in your PX job.

[memrinal]

If the routine is built and tested, you can create a shared container of the a server transform stage and incorporate the shared container in your PX job.

Thats what i am doing now. but i was looking for some better way to get this done. I think calling a Server shared Container in a PX job may have performance issues. Has anyone done an impact analysis for this. if yes please share the results with me. Thanks in advance.

[ray.wurlod]

Of course calling a server component will have performance issues; it runs only in a single process. There is a list of what you can and cannot do with shared containers that contain server components in the Parallel Job Developer's Guide.

[ray.wurlod]

Of course calling a server component will have performance issues; it runs only in a single process. There is a list of what you can and cannot do with shared containers that contain server components in the Parallel Job Developer's Guide.

[T42]

Yikes, Ray got bitten by the double-post bug! Not even the Great One can escape it!

[GIDs]

Hi,
I have a DataStage Server routine which i need to call from a PX job. I tried using everything including using transform for the same but nothing worked. can there be a round about way to call a routine from the PX job.
Currently i am using a server shared container for the purpose but would like inputs from all you people about a better way to do the same.
Thanks in advance
Mrinal

you can convert the routine to a buildop, as these build-op operations can still be partitioned and all that a PX stage can do