In general, there will be very little CPU time recorded in the DB2 Address Spaces, except for the DDR address space, because CPU time consumed in DB2 is recorded in the address space OF THE CALLER, i.e., the Batch Job or the CICS region that called DB2, so the SMF 101 (DB2ACCT) data is the only safe source of who is consuming DB2 CPU time.
Barry Herbert W. "Barry" Merrill, PhD President-Programmer MXG Software Merrill Consultants 10717 Cromwell Drive Dallas, TX 75229 ba...@mxg.com http://www.mxg.com - FAQ has Most Answers ad...@mxg.com - invoices/PO/Payment supp...@mxg.com - technical tel: 214 351 1966 - expect slow reply, use email fax: 214 350 3694 - prefer email, still works -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Mike Bell Sent: Thursday, August 08, 2013 12:21 PM To: 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 presentations on what was included in DB2 cpu and why. I haven't looked for them in a long time. Maybe someone on DB2 listserv has a better memory or keeps better notes. Mike On Thu, Aug 8, 2013 at 8:39 AM, Charles Mills <charl...@mcn.org> wrote: > Do you know that there is a DB2-specific mailing list where lots of > serious DB2 performance heavyweights hang out? > > I believe the enrollment 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.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 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 various performance specialists at IBM (authors of > presentations at CMG ...) but none of them noticed this before. > This is the second MVS site that i notice the differences , so i don't > think that there is a bug behind that. > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Mike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
