The SPAS address space is history, so any confusion stems from using SPAS as a word in talking about WLM managed address spaces.
You can have many WLM address spaces started based on demand. IBM recommended people shift their stored procedures a couple of versions ago. Luckily, I didn't haven't worry about this, we went from zero UDFs to having several running in WLM managed address spaces. If you don't have any stored procedures and only UDFs, it can hardly be referred to as a SPAS anything, surely? I'm sure the OP is now suitably confused....Sorry... On 2/13/08, Dave Barry <[EMAIL PROTECTED]> wrote: > > SPs and UDFs, yes. But the confusion is in referring in short-hand to > the WLM address space. WLM has its own address space called "WLM." SPs > and UDFs run in the WLM-managed SPAS address space arbitrarily named in > the APPLENV definition. > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On > Behalf Of Wayne Bickerdike > Sent: Monday, February 11, 2008 10:16 PM > To: [email protected] > Subject: Re: WLM for toddlers > > Actually the terminology for SPAs applies also to UDFs (user defined > functions). > > The SQL DDL for a UDF includes the name of the external load module (8 > char load module) and the WLM environment which in some of the IBM > example code is something like WLMENV1. > > WLM starts up an address space to execute the SP or UDF. The WLM address > space is configured with number of tasks with (NUMTCB) etc. > > A simple example is the DSN8.DAYNAME UDF. The DDL is shown below: > > CREATE FUNCTION DSN8.DAYNAME > (VARCHAR(10) FOR SBCS DATA CCSID EBCDIC) RETURNS VARCHAR(9) FOR SBCS > DATA CCSID EBCDIC SPECIFIC DSN8EUDNV EXTERNAL NAME 'DSN8EUDN' > LANGUAGE C > DETERMINISTIC PARAMETER STYLE DB2SQL FENCED CALLED ON NULL INPUT NO SQL > NO EXTERNAL ACTION NO SCRATCHPAD NO FINAL CALL ALLOW PARALLEL NO DBINFO > NO COLLID WLM ENVIRONMENT DB28WLM1 ASUTIME LIMIT 5 STAY RESIDENT NO > PROGRAM TYPE SUB SECURITY DB2 STOP AFTER SYSTEM DEFAULT FAILURES INHERIT > SPECIAL REGISTERS ; > > So at our shop we have a WLM address space called DB28WLM1. The external > function is coded in C. > > ---------------------------------------------------------------------- > 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 > -- Wayne V. Bickerdike ---------------------------------------------------------------------- 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
