DB2 DDF and OMVS

2007-09-24 Thread Kelman, Tom
We are seeing an increase in DB2 DDF processing. At the same time we are seeing an increase in CPU utilization for the OMVS workload. Are they related? Does DB2 DDF processing utilized Unix Systems Services and OMVS? We are at DB2 v7. Tom Kelman Commerce Bank of Kansas City (816) 760-7632

Re: DB2 DDF and OMVS

2007-09-24 Thread John Giltner
Kelman, Tom wrote: We are seeing an increase in DB2 DDF processing. At the same time we are seeing an increase in CPU utilization for the OMVS workload. Are they related? Does DB2 DDF processing utilized Unix Systems Services and OMVS? We are at DB2 v7. Tom Kelman Commerce Bank of Kansa

Re: DB2 DDF and OMVS

2007-09-25 Thread Knutson, Sam
Hi Tom, If this is enough for you to notice have you looked at weather you could offload enough time on a zIIP engine to justify one or more? You can specify in IEAOPTxx to measure the zIIP eligible time even without having a zIIP and get a pretty good idea what you can offload if you have the co

Re: DB2 DDF and OMVS

2007-09-25 Thread Ed Finnell
In a message dated 9/25/2007 7:29:25 A.M. Central Daylight Time, [EMAIL PROTECTED] writes: having a zIIP and get a pretty good idea what you can offload if you have the correct service installed. /* PROJECT USE OF ZIIP ENGINES */ PROJECTCPU=YES >> Guess the other side of coi

Re: DB2 DDF and OMVS

2007-09-25 Thread Kelman, Tom
> Posted by Sam Knutson > > Hi Tom, > > If this is enough for you to notice have you looked at weather you could > offload enough time on a zIIP engine to justify one or more? You can > specify in IEAOPTxx to measure the zIIP eligible time even without > having a zIIP and get a pretty good idea

Re: DB2 DDF and OMVS

2007-09-25 Thread Horne, Jim - James S
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

Re: DB2 DDF and OMVS

2007-09-25 Thread Leon Schwering
Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Horne, Jim - James S Sent: September 25, 2007 11:17 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: DB2 DDF and OMVS NOTICE: All information in and attached to the e-mail(s) below may be proprietary, confidential

Re: DB2 DDF and OMVS

2007-09-25 Thread Kelman, Tom
Leon, The value is at offset 128 in the Processor Accounting Section of the SMF type 30 record. It is variable CPUZIETM in the JOBS and STEPS datasets of Barry Merrill's MXG system if you build a performance database with that software. I've found out that I have another problem trying to get th

Re: DB2 DDF and OMVS

2007-09-29 Thread Kenneth E Tomiak
I do not have the specifics, but I know while running DB2 V7 we were able to run SMF data through a 'special' program, I sent the output to someone else in our company, and they did the zIIP analysis. Not knowing the source of the 'special' program I am not going to pass it around. Not wanting t

Re: DB2 DDF and OMVS

2007-09-29 Thread Brian Peterson
This is not correct. zIIP sizing analysis can be done using DB2 Version 7. See the below description of how IBM can perform zIIP analysis using tools and the data needed as input. http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS2841 Brian On Tue, 25 Sep 2007 11:17:05 -0400,

Re: DB2 DDF and OMVS

2007-09-30 Thread Martin Packer
The difference between what you get with DB2 V7 and SMF 101 vs DB2 V8 and PROJECTCPU might be interesting... I believe the former would be from measuring the appropriate CPU for DDF and ESTIMATING from there - and might be detailed enough to tell you which applications. (I've not seen the outpu

Re: DB2 DDF and OMVS

2007-10-01 Thread Kelman, Tom
> On Tue, 25 Sep 2007 11:17:05 -0400, Horne, Jim - James S wrote: > > > > >Tom, > > > >You are absolutely right - zIIP analysis requires DB2 v8. Once you've > >got DB2 v8 running you can do what Sam recommended. > > > >Jim Horne > > On Saturday, 29 Sep 2007 10:27 Brian Peterson wrote: > > This