On Mon, 27 Jun 2005 10:18:19 -0400, Jon Brock <[EMAIL PROTECTED]> wrote:
> This is, I'm sure, a trivial question. We have a started task running that is the "WLM-established stored procedures address space." It connects to DB2 and sits out there and does . . . stuff. What stuff? Is this some sort of caching task for DB stored procedures? If so, why is it WLM-established? Are there some other sort of stored procedures that are WLM-specific? If so, why is it specific to a DB2 subsystem? > I am assuming that it manages DB2 stored procedures and is in turn managed by WLM, perhaps being started/shut down/throttled depending on availability of system resources, something like WLM-managed initiators (which we don't use). > Does anybody have a quick explanation. Failing that, can someone point me to which Fine Manual to Read? > > Here is a part of an explanation from Craig Mullins that is on the "Ask the Experts" section of search390.com. If you are not a member you might want to sign up to be able to view the site. There is a lot more information besides this that is useful. http://search390.techtarget.com/ateQuestionNResponse/0,289625,sid10_gci96517 4,00.html (sorry for the URL wrap - I post via web interace to ibm-main) "Stored procedures are specialized programs that are executed under the control of the DBMS. You can think of stored procedures as similar to other database objects such as tables, views and indexes because they are managed and controlled by the RDBMS. But you can think of stored procedures as similar to application programs, too because they are coded using a procedural programming language." Mark -- Mark Zelden Sr. Software and Systems Architect mailto: [EMAIL PROTECTED] Systems Programming expert at http://Search390.com/ateExperts/ Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
