Just push the Easy button? Unfortunately it's not located in easily accessible location. 1)Hardware config WRT CPUs, CoD, Storage, ZIIPs, DASD, SSD 2)Software config WRT to Buffer use. Limiting non-production resources with throttles. 3)Craig Mullin's DB/2 book is a good starting place. He states 70% of DB/2 performance were related to bad SQL code. 4)Monitor tools. The old Platinum tools were bought by CA. Analyzer, Detector, SQL pay for themselves after a few bumps. Workload observations with RMF can hint at when your peaks will occur. End of month, sale season, market swings whatever your business is. 5)WLM can help smooth out the rough spots. Cheryl Watson's Goal Tender can point you to problems with misshapen goals and objectives. 6) Get help where applicable. Just a few pointers and observations can give leverage or reinforcement as to where you're trying to go and what you're trying to achieve. 7)Many of this and related topics are covered in Redbooks and presented at SHARE by other installations that have gone thru this or similar conundrums. 8)Keep posting, we all learn as we go. In a message dated 12/27/2013 4:58:34 A.M. Central Standard Time, elardus.engelbre...@sita.co.za writes:
No, I'm just trying to help. ;-) (I have helped in the past with our DB2 performance issues. That was traced down to bad programming practises which gobbled up our paging datasets ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
