DB2 and WLM Service Class

2010-10-19 Thread vatsal raicha
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

DB2 and WLM

2008-03-18 Thread Hal Merritt
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

Re: DB2 and WLM

2008-03-18 Thread Gray, Larry - Larry A
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

Re: DB2 and WLM

2008-03-18 Thread Ted MacNEIL
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

Re: DB2 and WLM

2008-03-18 Thread Neil Duffee
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

Re: DB2 and WLM

2008-03-18 Thread Dave Barry
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

Re: DB2 and WLM

2008-03-18 Thread Wayne Driscoll
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

SYSMDUMP in DB2 SP WLM

2007-09-11 Thread Don Imbriale
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

Re: SYSMDUMP in DB2 SP WLM

2007-09-11 Thread Wayne Driscoll
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

Re: SYSMDUMP in DB2 SP WLM

2007-09-11 Thread Imbriale, Donald
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

Re: SYSMDUMP in DB2 SP WLM

2007-09-11 Thread Edward Jaffe
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.) ;-)

Re: SYSMDUMP in DB2 SP WLM

2007-09-11 Thread Edward Jaffe
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

Re: SYSMDUMP in DB2 SP WLM

2007-09-11 Thread Don Imbriale
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

Re: SYSMDUMP in DB2 SP WLM

2007-09-11 Thread Ray Mullins
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

Re: SYSMDUMP in DB2 SP WLM

2007-09-11 Thread Ted MacNEIL
(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

Fw: [DB2-L] WLM SP Abend Mystery

2007-05-24 Thread Steve Grimes
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

Re: [DB2-L] WLM Service Definition for DDF Thread

2006-04-24 Thread Steve Grimes
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 SI