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