Re: DSNDIST 91% CPU
In a message dated 3/12/2010 9:17:53 A.M. Central Standard Time, richbourg.cla...@mail.dc.state.fl.us writes: Check to see if you have a Workload Manager Service Class definition for the DDF work,(distributed). You may want to throttle that back some. >> DB/2 Tuning course? DSNZPARM has parms to throttle queries and bufferpools are critical. Craig Mullins also notes in his book(s) 70% of performance problems are 'bad' SQL queries. -- 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
Re: DSNDIST 91% CPU
Check to see if you have a Workload Manager Service Class definition for the DDF work,(distributed). You may want to throttle that back some. Hope that helps, Claude -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Jorge Arueira Campos Sent: Friday, March 12, 2010 9:57 AM To: IBM-MAIN@bama.ua.edu Subject: DSNDIST 91% CPU Hi all !!! My team of z/OS 1.8 have problem with DB2 1.8, with the address space DSNDIST 91% of CPU(Z9-BC-12MSU) , and DB2CONNECT in client. Help wellcome Thanks Jorge Arueira Campos Z/OS - Support - POLITEC São Paulo - Brazil -- 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 -- 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
DSNDIST 91% CPU
Hi all !!! My team of z/OS 1.8 have problem with DB2 1.8, with the address space DSNDIST 91% of CPU(Z9-BC-12MSU) , and DB2CONNECT in client. Help wellcome Thanks Jorge Arueira Campos Z/OS - Support - POLITEC São Paulo - Brazil -- 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