© Copyright IBM Corporation 2008 Trademarks
DB2 problem determination using db2top utility Page 1 of 36
DB2 problem determination using db2top utility
Optimize performance and prevent problems in complex DB2
environments
Tao Wang (taoewang@ca.ibm.com)
DB2 Advanced Technical Support
IBM
Shen Li (shenli@ca.ibm.com)
DB2 RAS/PD Software Developer
IBM
04 December 2008
Get the best possible performance in complex IBM® DB2® for Linux® and UNIX®
environments with the db2top utility. In this article, you'll learn about the advantages this tool
offers, and see how to use it for monitoring and troubleshooting. In addition, you can follow
two sample cases that illustrate how to use this tool to diagnose real problems in a production
environment.
Introduction
There are several methods to collect information and diagnose DB2 system performance issues.
The snapshot monitor is one of the most commonly used tools to collect information in order to
narrow down a problem. However, most entries in snapshots are cumulative values and show the
condition of the system at a point in time. Manual work is needed to get delta value for each entry
from one snapshot to the next.
The db2top tool comes with DB2, and can be used to calculate the delta values for those snapshot
entries in real time. This tool provides a GUI under a command line mode, so that users can get
a better understanding while reading each entry. This tool also integrates multiple types of DB2
snapshots, categorizes them, and presents them in different screens for the GUI environment.
This article introduces some commonly used screens in db2top utility in daily performance
monitoring and troubleshooting work. You'll have a chance to examine several examples that show
how to use this tool to narrow down problems in real cases. After reading this article, you will be
able to:
• Understand how the db2top utility works
剩余35页未读，继续阅读
资源评论
