R: R: R: Differences between CPU values from SMF30 and DB2 stats

2013-08-09 Thread Fabio Massimo Ottaviani
Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Per conto di efinnell15 Inviato: venerdì 9 agosto 2013 09:05 A: IBM-MAIN@LISTSERV.UA.EDU Oggetto: Re: R: R: Differences between CPU values from SMF30 and DB2 stats Looking at the three page Newsletter .pdf says reply to this eMail with

Re: R: R: Differences between CPU values from SMF30 and DB2 stats

2013-08-09 Thread efinnell15
Looking at the three page Newsletter .pdf says reply to this eMail with Analyzing DB2 in Sub but doesn't give a hint as to the email? In a message dated 8/9/2013 1:43:36 AM Central Daylight Time, fabio.ottavi...@epvtech.com writes: Newsletter 4 and 5 2010. -

R: R: Differences between CPU values from SMF30 and DB2 stats

2013-08-08 Thread Fabio Massimo Ottaviani
this email? -Messaggio originale- Da: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Per conto di efinnell15 Inviato: giovedì 8 agosto 2013 23:00 A: IBM-MAIN@LISTSERV.UA.EDU Oggetto: Re: R: Differences between CPU values from SMF30 and DB2 stats Guess you could post a link or tinyurl

Re: R: Differences between CPU values from SMF30 and DB2 stats

2013-08-08 Thread efinnell15
Guess you could post a link or tinyurl where the paper could be found? In a message dated 08/08/13 12:39:40 Central Daylight Time, fabio.ottavi...@epvtech.com writes: Unfortunately I could not attach the graph because of List rules but results using SMF 100 are just a little bit lower than usi

R: Differences between CPU values from SMF30 and DB2 stats

2013-08-08 Thread Fabio Massimo Ottaviani
Message- > From: IBM Mainframe Discussion List [ <mailto:IBM-MAIN@LISTSERV.UA.EDU> > mailto:IBM-MAIN@LISTSERV.UA.EDU] > On Behalf Of Nguyen Duc > Sent: Thursday, August 08, 2013 3:45 AM > To: <mailto:IBM-MAIN@LISTSERV.UA.EDU> IBM-MAIN@LISTSERV.UA.EDU > Subject: Differ

Re: Differences between CPU values from SMF30 and DB2 stats

2013-08-08 Thread Barry Merrill
: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Differences between CPU values from SMF30 and DB2 stats There is a basic issue with DB2 statistics for CPU - they start with the first SQL statement. Everything that happens before that is not recorded in the DB2 cpu times. This is WAD. There used to be some presen

Re: Differences between CPU values from SMF30 and DB2 stats

2013-08-08 Thread Mike Bell
llment process is to go to www.idug.org and "join" IDUG. > > Charles > > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Nguyen Duc > Sent: Thursday, August 08, 2013 3:45 AM > To: IBM-MAIN@LISTSERV.UA

Re: Differences between CPU values from SMF30 and DB2 stats

2013-08-08 Thread Charles Mills
ERV.UA.EDU] On Behalf Of Nguyen Duc Sent: Thursday, August 08, 2013 3:45 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Differences between CPU values from SMF30 and DB2 stats Dear all, I am a DB2 specialist , doing some measurements i just noticed that there is a noticeable difference between DB2 C

Re: Differences between CPU values from SMF30 and DB2 stats

2013-08-08 Thread Elardus Engelbrecht
Nguyen Duc wrote: >...doing some measurements i just noticed that there is a noticeable >difference between DB2 CPU times i got from SMF30, and the times i got from >the DB2 statistics records (SMF100) about the CPU consumption of DB2 address >spaces. >With excel , the 2 graphs are parallel ,

Differences between CPU values from SMF30 and DB2 stats

2013-08-08 Thread Nguyen Duc
Dear all, I am a DB2 specialist , doing some measurements i just noticed that there is a noticeable difference between DB2 CPU times i got from SMF30, and the times i got from the DB2 statistics records (SMF100) about the CPU consumption of DB2 address spaces. I submitted the question to vario