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
Can we use a Parallel shared container inside a Server Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.