View previous topic :: View next topic
|
Author |
Message |
rakesh_mishra18
New User
Joined: 15 May 2006 Posts: 23 Location: Jamshedpur
|
|
|
|
Hi,
Why we need WLM for Stored Procdeure. I mean, WLM is just a load balancing manager.
Rgds,
Rakesh |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
Quote: |
WLM is just a load balancing manage |
and DB2 is just a file processing manager. Both statements are about equally true and equally misleading.
WLM can manage initiators (allowing more or fewer jobs into the system), prioritize work load (such as allow online work to have priority over batch), and otherwise manage the various resources of the system. Furthermore, it is not really optional -- one mode or the other, it is running on your system. |
|
Back to top |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
|
|
|
|
Its not always needed.
V7 DB2 had the option to use SPAS instead of WLM.
V9 Db2, if you use native SQL procedure then it doesn't need WLM.
I am not exactly sure why WLM is needed such as, for external host language stored procs. Though WLM certainly has its advantages as Robert mentioned. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
Workload Manager is part of z/OS. Whether you use native SQL or not, the address space(s) are being managed by WLM -- always. |
|
Back to top |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
|
|
|
|
Robert Sample wrote: |
Workload Manager is part of z/OS. Whether you use native SQL or not, the address space(s) are being managed by WLM -- always. |
True. I guess I should have written WLM-managed-stored-procedure-address-space everytime I said WLM.
In that sense, native SQL procs will not require this separate WLM-managed-stored-procedure-address-space
Since DB2 subsystem started tasks and address spaces are also managed by z/OS WLM, I guess the old DB2 managed stored proc address space(SPAS) was also indirectly managed by WLM although not usually called WLM managed.
If so then the native SQL procs although don't require a separate address space directly managed by WLM, are not entirely independent of WLM. This part has been a bit confusing for me. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
Simple rule of thumb: if it is running in an address space on a z machine, WLM is managing it -- because WLM manages all address spaces on the machine. |
|
Back to top |
|
|
rakesh_mishra18
New User
Joined: 15 May 2006 Posts: 23 Location: Jamshedpur
|
|
|
|
Thanks a lot..its very much clear now. |
|
Back to top |
|
|
|