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
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
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
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
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
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
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
SYSMDUMP in DB2 SP WLM
We need to collect a SYSMDUMP from a DB2 SP WLM task. The SYSMDUMP DD needs to point to a disk data set. There can be multiple instances of the DB2 SP WLM task running concurrently, so there is a need to uniquely name the data set for the SYSMDUMP. GDGs don't work because there is an enqueue on the GDG base, so started tasks after the first wait. We've thought of using system symbols (since this is a started task), but there isn't enough granularity in the values of the symbols to assure uniqueness. Any thoughts on how to accomplish this? Don Imbriale -- -- 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: SYSMDUMP in DB2 SP WLM
Search the archives for some details from Ed Jaffe regarding pointing the SYSMDUMP DD to a SYSOUT dataset, and then saving it to a dataset if and only if you need it. Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Don Imbriale Sent: Tuesday, September 11, 2007 11:08 AM To: IBM-MAIN@BAMA.UA.EDU Subject: SYSMDUMP in DB2 SP WLM We need to collect a SYSMDUMP from a DB2 SP WLM task. The SYSMDUMP DD needs to point to a disk data set. There can be multiple instances of the DB2 SP WLM task running concurrently, so there is a need to uniquely name the data set for the SYSMDUMP. GDGs don't work because there is an enqueue on the GDG base, so started tasks after the first wait. We've thought of using system symbols (since this is a started task), but there isn't enough granularity in the values of the symbols to assure uniqueness. Any thoughts on how to accomplish this? Don Imbriale -- -- 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: SYSMDUMP in DB2 SP WLM
Thanks Wayne. I had searched the archives. My tests show that SYSMDUMP directed to SYSOUT, then copied to a dataset (via SDSF for example), results in a partially corrupted SYSMDUMP. Don Imbriale -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Wayne Driscoll Sent: Tuesday, September 11, 2007 12:24 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: SYSMDUMP in DB2 SP WLM Search the archives for some details from Ed Jaffe regarding pointing the SYSMDUMP DD to a SYSOUT dataset, and then saving it to a dataset if and only if you need it. *** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. *** -- 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: SYSMDUMP in DB2 SP WLM
Wayne Driscoll wrote: Search the archives for some details from Ed Jaffe regarding pointing the SYSMDUMP DD to a SYSOUT dataset, and then saving it to a dataset if and only if you need it. SYSMDUMP to sysout. The only way to fly! (Or, at least, the only way I fly.) ;-) http://bama.ua.edu/cgi-bin/wa?A2=ind0704L=ibm-mainP=R59172I=1X=- http://bama.ua.edu/cgi-bin/wa?A2=ind0704L=ibm-mainP=R59580I=1X=- -- Edward E Jaffe Phoenix Software International, Inc 5200 W Century Blvd, Suite 800 Los Angeles, CA 90045 310-338-0400 x318 [EMAIL PROTECTED] http://www.phoenixsoftware.com/ -- 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: SYSMDUMP in DB2 SP WLM
Imbriale, Donald wrote: Thanks Wayne. I had searched the archives. My tests show that SYSMDUMP directed to SYSOUT, then copied to a dataset (via SDSF for example), results in a partially corrupted SYSMDUMP. I look at many such dumps and have never experienced any corruption using this technique. The dump on spool will be byte-for-byte exactly correct. When copying to DASD for IPCS use, you need to use a tool that will not change the contents of the data. And, you must copy it to a RECFM=FBS data set. -- Edward E Jaffe Phoenix Software International, Inc 5200 W Century Blvd, Suite 800 Los Angeles, CA 90045 310-338-0400 x318 [EMAIL PROTECTED] http://www.phoenixsoftware.com/ -- 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: SYSMDUMP in DB2 SP WLM
After further research I see that the 'corruption' is the insertion of carriage control characters. This is being done by SDSF when using line command XDC, even if the correct data set attributes are specified for the output data set. Instead, I created an appropriate data set, allocated it to some DD in my TSO session, then used SDSF's XFC line command and pointed to that DD. This copies it as is, without carriage control characters. Now it is usable. Thanks Wayne and Ed. Don Imbriale -- On Tue, 11 Sep 2007 09:47:45 -0700, Edward Jaffe [EMAIL PROTECTED] wrote: Imbriale, Donald wrote: Thanks Wayne. I had searched the archives. My tests show that SYSMDUMP directed to SYSOUT, then copied to a dataset (via SDSF for example), results in a partially corrupted SYSMDUMP. I look at many such dumps and have never experienced any corruption using this technique. The dump on spool will be byte-for-byte exactly correct. When copying to DASD for IPCS use, you need to use a tool that will not change the contents of the data. And, you must copy it to a RECFM=FBS data set. -- -- 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: SYSMDUMP in DB2 SP WLM
(off-list to hide my ignorance) Hello Ed, Out of curiosity, in a situation where multiple abends occurred, how does SYSMDUMP processing handle this? Does it write multiple dumps to the dataset? (I'm guessing yes because of the nature of SYSOUT storage.) We just had a situation where, in a multi-TCB address space, the customer had only SYSUDUMP. The problem was SP 0 fragmentation below the line, and unfortunately we only got SP 0 storage associated with the two TCBs that RTM decided to dump, which you can guess made things difficult for me to track down. Luckily a couple of days ago we got another dump, from another customer, with the same below-the-line storage issues, but luckily the dumped SP 0 had a lot more info. A SYSMDUMP would have come in very handy in those environments. (Now I'm fighting an internal battle between SYSMDUMP and SYSABEND. One of our support reps has some REXX programs he's written to parse SYSUDUMP/ABEND, and I'm trying to bring them into the late 1990s with IPCS and re-writing the REXX programs to do the same thing.) Also, I'll ask just because, but does Phoenix have any openings? I like what I'm doing, but there are some issues within the company that are making me wonder if it was a good thing to take this position so quickly. Thanks and best regards, Ray Mullins -- M. Ray Mullins Roseville, CA, USA http://www.catherdersoftware.com/ http://www.mrmullins.big-bear-city.ca.us/ http://www.the-bus-stops-here.org/ German is essentially a form of assembly language consisting entirely of far calls heavily accented with throaty guttural sounds. ---ilvi French is essentially German with messed-up pronunciation and spelling. --Robert B Wilson English is essentially French converted to 7-bit ASCII. ---Christophe Pierret [for Alain LaBonté] -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Edward Jaffe Sent: Tuesday, 11 September, 2007 09:36 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: SYSMDUMP in DB2 SP WLM Wayne Driscoll wrote: Search the archives for some details from Ed Jaffe regarding pointing the SYSMDUMP DD to a SYSOUT dataset, and then saving it to a dataset if and only if you need it. SYSMDUMP to sysout. The only way to fly! (Or, at least, the only way I fly.) ;-) http://bama.ua.edu/cgi-bin/wa?A2=ind0704L=ibm-mainP=R59172I=1X=- http://bama.ua.edu/cgi-bin/wa?A2=ind0704L=ibm-mainP=R59580I=1X=- -- 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: SYSMDUMP in DB2 SP WLM
(off-list to hide my ignorance) No it wasn't! - 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
Fw: [DB2-L] WLM SP Abend Mystery
Hi -- a helpful suggestion got me past my error. Thank you! Stg - Forwarded by Steve Grimes/Systems/ais on 05/24/2007 05:37 PM - Steve Grimes/Systems/ais 05/24/2007 03:58 PM To DB2 Database Discussion list at IDUG [EMAIL PROTECTED] cc Subject Re: [DB2-L] WLM SP Abend Mystery Success! This definately got me on the right path -- thank you! I changed the PC options to ATTACH(RRSAF) and (eventually) the compile options to DYNAM and NOEXPORTALL. The execution seems to be happening now, with (typical) abends occurring due to program logic and check constraint stuff. (Probably because this program is truly NOT re-entrant.) Anyway, I'm on my way again. Thank you! Stg -- 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-L] WLM Service Definition for DDF Thread
Great tips -- thanks all. Using RMF screens (which I have access to) and looking over someone's shoulder for WLM screen's (which I don't have access to) I found that my assumptions were basically correct, but that I was looking at the wrong thing. Our production DDF thread rules are: 1 SIDBP1 2 . PN . *DDFPROD (Our test DDF thread on the same LPAR looks similar, but with DDFTEST.) DDFPROD is defined as 1 period, Imp = 2, 90% within 2 secs. DDFTEST is defined as 2 periods, 1st Period Duration=1, Imp = 3, 90% within 2 secs 2nd Period Imp = 5, Execution Velocity of 50 Using PM and RMF panals, I found my user's thread running with DDFPROD priority. So, I'm going to make my suggestion to add: 2 CI MSACCESS DDFTEST to the DBP1 definition and see where it goes. Thanks! Stg -- 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