Thanks, Mark. I was already familiar with the basic concept of stored procedures; I mainly was confused about why there was a WLM address space associated with them. The link provided by Rolf Ernst explained it pretty well, although I will probably have to read it three or four times to really understand it well. The link, for those who may have missed his message, is: http://www-306.ibm.com/software/tivoli/features/ccr2/ccr2-2004-10/feature-db2.html
Key quotes: "Stored procedures and user defined functions (UDFs) use infrastructure defined and provided by WLM. And WLM application environments define and manage WLM-managed stored procedure address spaces." "When an application issues an SQL CALL to invoke a stored procedure, DB2 queues the request to WLM. WLM manages stored procedure request queues, and sends them to the appropriate application environment address spaces defined within WLM." "The benefit of this approach is that the stored procedure processing capacity will be dynamically scalable. This approach also provides considerable granularity for stored procedure prioritization and control." Thanks, Jon <snip> "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." </snip> ---------------------------------------------------------------------- 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
