Re: WLM for toddlers

Just a little nitpicking - enclave SRBs for distributed threads are in xxxxDIST
but the executable code for SQL and V9 native stored procedures resides in
xxxxDBM1. Off course it's all charged to the SRB ( thus to xxxxDIST ).
Mohammad


On Thu, 7 Feb 2008 19:17:28 -0500, Wayne Driscoll
<wdriscoll@xxxxxxxxxxxxxxx> wrote:

The xxxxDIST address space is the DB2 DDF address space. No user written
load modules will execute in this address space. SQL statements (and with
DB2 V9, SQL Stored Procedures) are executed in the DIST address space. All
user written stored procedures will be executed in a WLM application
environment address space, which is basically an "initiator" address space
(although, as was pointed out, WLM managed initiators are application
environments). The name of these address spaces will be installation defined.

Wayne Driscoll
Product Developer
JME Software LLC
NOTE: All opinions are strictly my own.


----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
.

Relevant Pages

  • Re: A peculiar problem
    ... > and then to execute them. ... Text manipulation in SQL Server is very hard, ... > 1.Create a batch file with isql utility using an input file and putting ... Export the generated file(with the modified stored procedures) using ...
    (microsoft.public.sqlserver.programming)
  • Re: Poor performance when executing stored procedure
    ... > Generally I would write stored procedures to do only one job. ... If SQL Server ... > which is even worse those sps can execute each other. ... > then executed spOrders which is executed in spCustomers and then got stuck ...
    (microsoft.public.sqlserver.programming)
  • I think our understandings are different
    ... He said "direct execute sql". ... To say that stored procedures are "far ... > select listingId, listingName from Property ...
    (microsoft.public.dotnet.framework.aspnet)
  • Emulate SQLServer Stored procedures in Access
    ... Is it possible to emulate SQLServer Stored procedures in Access? ... Very often this application has to execute a series of SQL statements ...
    (microsoft.public.vb.database)
  • Re: What is wrong with this? : select * from (exec sp_helpdb)
    ... And some good reasons, too. ... I have many stored procedures that perform a simple update ... Should the engine try and figure out if I merely meant to execute the ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)