Page 1 of 1

Can we use a Parallel shared container inside a Server Job

Posted: Wed Oct 27, 2004 9:08 am
by ashcar
I have a server job with a server shared container inside it ..it takes 9 hrs for extraction and sorting of data and now i want to optimize just the shared container which does the sorting
so can i build a parallel shared container inside a server job

Posted: Wed Oct 27, 2004 3:30 pm
by ray.wurlod
If you don't have the Parallel Extender software installed, the answer is a definite NO.
If you do have the Parallel Extender software installed, the answer is still, as far as I am aware, NO.

What you could do, on the other hand, is to effect parallelism in your server job by using parallel streams, each processing a subset of the data. Parallel streams can be implemented within a job, or by using multiple instances of the job. In the latter case, make the constants in the WHERE clause job parameters.

Your other alternative if you have Parallel Extender installed is to write a parallel job. This - provided you have the resources (multiple CPUs is the bare minimum requirement) - ought to give you the best throughput.