Tuning and Monitoring Database System Performance
Most DB2 systems go through something of a “performance evolution”. The system must first be configured, both from hardware and software perspectives. In many ways, this sets the stage for how the system behaves when it is in operation. Then, after the system is deployed, a diligent DBA monitors system performance, in order to detect any problems that might develop. If such problems develop, we come to the next phase – troubleshooting. Each phase depends on the previous ones, in that without proper preparation in the previous phase, we are much more likely to have difficult problems to solve in the current phase.
This paper presents DB2 system performance best practices following this same progression. We begin by touching on a number of important principles of hardware and software configuration that can help ensure good system performance. Then we discuss various monitoring techniques that help you understand system performance under both operational and troubleshooting conditions. Lastly, because performance problems can occur despite our best preparations, we talk about how to deal with them in a step-wise,methodical fashion.
Date:July 30, 2013
Share this page with colleagues and friends: Click the social media icons on the right side of this page to share it to your favorite social networks.
- Learn more about the Information Management best practices.
- Learn more about the DB2 for Linux, UNIX, and Windows best practices.
- Visit the DB2 Version 10.5 Information Center.
About the Authors
|Steve Rees is Senior Technical Staff Member focusing on DB2 pureScale and Optim Data Studio performance. He has worked on DB2 performance for over 15 years, with the last four on DB2 pureScale software.|
|Olaf Depper is a member of the DB2 SAP platform team at the IBM Research and Development Lab in Boeblingen, Germany. He has over 14 years of experience with DB2 for Linux, UNIX, and Windows in SAP environments. Olaf is responsible for the DB2 administration and performance tuning workshops that his team offers world-wide.|
|Naveen Kumar Singh is a Senior Software Engineer at IBM India Software Labs. He is part of the DB2 Development Continuing Engineering team, and has been focussing on the engine monitoring infrastructure since 2009.|
|Gang Shen is an Executive IT Specialist in IBM Software Group. He has worked on DB2 for Linux, Unix and Windows since 1995.|
|Roman B. Melnyk, Ph.D., is a senior member of the DB2 Information Development team. Roman edited Harness the Power of Big Data: The IBM Big Data Platform (McGraw-Hill, 2013), Warp Speed, Time Travel, Big Data, and More: DB2 10 for Linux, UNIX, and Windows New Features (McGraw-Hill, 2012), and Apache Derby - Off to the Races (Pearson Education, 2006). Roman co-authored DB2 Version 8: The Official Guide (Prentice Hall Professional Technical Reference, 2003), DB2: The Complete Reference (Osborne/McGraw-Hill, 2001), DB2 Fundamentals Certification for Dummies (Hungry Minds, 2001), and DB2 for Dummies (IDG Books, 2000).|