DB2 and WLM Service Class
Hi, I have one Db2 utility job is running in a service class (vel 50, imp 4) anthr db2 utility job in a service class(vel 30,imp 4). Does Db2 give them same service, if other factors remain constant? Both the utility jobs are doing the same thing. Thanks, Vatsal -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 and WLM
Wrong. Stored Procedures continue to run in Stored Procedures Address Spaces. They are stored procedures, and they run in address spaces. Stored procedures do not run in the (one and only one per DB2 subsystem) DDF address space. In the original DB2 support for stored procedures, all stored procedures ran in a single DB2 managed SPAS. This address space was started (optionally) at DB2 initialization, and all stored procedures ran in this address space. However, with later releases of DB2, support was added for executing stored procedures and user defined functions (UDF's) in WLM managed stored procedure address spaces, by defining DB2 specific WLM application environments. However since these are DB2 specific, they are still stored procedure address spaces. What is no longer recommended (and for DB2 9, not supported) is the DB2 managed SPAS, so all stored procedures must run in a WLM application environment. One requirement for WLM stored procedures is the use of RRSAF, in ! place of CAF for DB2 connectivity. RRSAF requires that the RRS logstreams be defined, which in turn require SYSPLEX definitions, even if in MONOPLEX mode. With DB2 9, SQL stored procedures can be defined as "native" which allows them to run in the DB2 DBM1 address space rather than in a WLM address space. Wayne Driscoll Product Developer NOTE: All opinions are strictly my own. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Ted MacNEIL Sent: Tuesday, March 18, 2008 3:02 PM To: IBM-MAIN@bama.ua.edu Subject: Re: DB2 and WLM >Something about stored procedures and separate address spaces. The FM's I've >searched don't give me a clear picture of what is what. First, Stored Procedure Address Spaces have been replaced with Distributed Data Facility (DDF) address spaces. SPAS is still supported, but IBM recommends that you use DDF. Start with the WLM reference which explains Application Environments (a requirement for DDF). It will point you to the proper manuals for configuring DB2 & RRSF (a requirement for the extended Call Attach Facility -- CAF). - Too busy driving to stop for gas! -- 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 -- 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
Re: DB2 and WLM
Since it seems to be my mission in life... Stored procedures run in stored procedured address spaces. This is true whether the requests are are made locally to the system (or plex), or received remotely via DDF. There used to be a single subsystem address space commonly known as "SPAS." The newer alternative is called... ***> WLM-managed stored procedure address space <*** A set of one or more WLM-managed stored procedure (started task) address spaces of a given name are known as an "application environment." See option 9 on the WLM main menu. Countless hours of confusion could be eliminated by using the terminology precisely as it is used in the literature. db -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Hal Merritt Sent: Tuesday, March 18, 2008 2:18 PM To: IBM-MAIN@bama.ua.edu Subject: DB2 and WLM I am getting a request from my DB2 guy to set up WLM and make appropriate RACF entries for something that is optional in 1.7, required in 1.8, and, I think, dropped in 1.9. Something about stored procedures and separate address spaces. The FM's I've searched don't give me a clear picture of what is what. We don't use stored procedures, so I am a little confused why we have set up that envionment. Can someone point me to a FM that will lead me to the path of enlightenment? Thanks!! NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- 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 -- 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
Re: DB2 and WLM
On 18 Mar 2008 18:23:27 GMT, Hal Merritt <[EMAIL PROTECTED]> wrote to IBM-Main about "DB2 and WLM": > I am getting a request from my DB2 guy to set up WLM and make > appropriate RACF entries for something that is optional in 1.7, > required in 1.8, and, I think, dropped in 1.9. > Something about stored procedures and separate address spaces. The > FM's I've searched don't give me a clear picture of what is what. > We don't use stored procedures, so I am a little confused why we have > set up that envionment. > Can someone point me to a FM that will lead me to the path of > enlightenment? Hal: you might check the DB2 chapter in the Redbook "System Programmer's guide to: Workload Manager" (SG24-6472). There's likely a chapter, or two, in the DB2 Admin guide as well. Maybe he can tell where he's reading from. If you're not using stored procedures, he might be doing DDF ie. JDBC, etc. DB2 stored procedures are moving from being run in the DB2 SP a/s to separate WLM address spaces ie. DB2 SPAS is now deprecated. (your para 1 except DB2 v6, 7, & 8) For WLM managed, stored procedures, you need a WLM ApplEnv so the a/s will get started/stopped per demand. (I believe that it's 2hrs inactivity before the last STC disappears.) We use the STDATA in Racf Class(Facility) to provide the proper userid. friendly *Warning*: don't include NumTcbs in the ApplEnv Parm as shown in examples. Instead, leave it for the JCL proc where it can be easily changed without requiring a WLM policy activation each time. Only place items that are invariant (rock solid, unchanging) such as DB2SSN and ApplEnv. ps. I believe there are sample stored procedures - and maybe a Rexx builder - provided with DB2. He might be trying them out for size. --> signature = 6 lines follows <-- Neil Duffee, Joe SysProg, U d'Ottawa, Ottawa, Ont, Canada telephone:1 613 562 5800 x4585 fax:1 613 562 5161 mailto:NDuffee of uOttawa.ca http:/ /aix1.uottawa.ca/ ~nduffee "How *do* you plan for something like that?" Guardian Bob, Reboot "For every action, there is an equal and opposite criticism." "Systems Programming: Guilty, until proven innocent" John Norgauer 2004 -- 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
Re: DB2 and WLM
>Something about stored procedures and separate address spaces. The FM's I've >searched don't give me a clear picture of what is what. First, Stored Procedure Address Spaces have been replaced with Distributed Data Facility (DDF) address spaces. SPAS is still supported, but IBM recommends that you use DDF. Start with the WLM reference which explains Application Environments (a requirement for DDF). It will point you to the proper manuals for configuring DB2 & RRSF (a requirement for the extended Call Attach Facility -- CAF). - Too busy driving to stop for gas! -- 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
Re: DB2 and WLM
NOTICE: All information in and attached to the e-mail(s) below may be proprietary, confidential, privileged and otherwise protected from improper or erroneous disclosure. If you are not the sender's intended recipient, you are not authorized to intercept, read, print, retain, copy, forward, or disseminate this message. If you have erroneously received this communication, please notify the sender immediately by phone (704-758-1000) or by e-mail and destroy all copies of this message (electronic, paper, or otherwise). Thank you. They probably need the Application Environment defined in WLM for the DB2 address space. Try http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/ com.ibm.db2.doc.admin/dwlmenv.htm. Watch the wrap. This is from the DB2 Info Center. I just did a search on applenv wlm. Larry Gray Large Systems Engineering Lowe's Companies 336-658-7944 -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Hal Merritt Sent: Tuesday, March 18, 2008 2:18 PM To: IBM-MAIN@bama.ua.edu Subject: DB2 and WLM I am getting a request from my DB2 guy to set up WLM and make appropriate RACF entries for something that is optional in 1.7, required in 1.8, and, I think, dropped in 1.9. Something about stored procedures and separate address spaces. The FM's I've searched don't give me a clear picture of what is what. We don't use stored procedures, so I am a little confused why we have set up that envionment. Can someone point me to a FM that will lead me to the path of enlightenment? Thanks!! NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- 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 -- 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
DB2 and WLM
I am getting a request from my DB2 guy to set up WLM and make appropriate RACF entries for something that is optional in 1.7, required in 1.8, and, I think, dropped in 1.9. Something about stored procedures and separate address spaces. The FM's I've searched don't give me a clear picture of what is what. We don't use stored procedures, so I am a little confused why we have set up that envionment. Can someone point me to a FM that will lead me to the path of enlightenment? Thanks!! NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- 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