Executive summary
Even in a perfectly engineered world, things can break. Hardware that is not redundant can fail, or software can encounter a condition that requires intervention. You can automate some of this intervention. For example, you can enable your DB2 server to automatically collect diagnostic data when it encounters a significant problem. Eventually, however, a human being must look at the data to diagnose and resolve the issue. When the need arises, you can use several DB2 troubleshooting tools that provide highly granular access to diagnostic data.
Introduction
The information and scenarios in this paper shows how you can use the DB2 troubleshooting tools to diagnose problems on your server.
In large database environments, the collection of diagnostic data can introduce an unwanted impact on the system. This paper shows how you can minimize this impact by tailoring the values of a few basic troubleshooting configuration parameters such as
diagpath,
DUMPDIR, and
FODCPATH and by collecting data more selectively.
The result? When things do break, you are well prepared to make troubleshooting as quick and painless as possible.
The following DB2 troubleshooting scenarios are covered in this paper:
- Troubleshooting high processor usage spikes
- Troubleshooting sort overflows
- Troubleshooting locking issues
For each scenario, this paper shows you how to identify the problem symptoms, how to collect the diagnostic data with minimal impact to your database environment, and how to diagnose the cause of the problem.
The target audience for this paper is database and system administrators who have some familiarity with the operating system and DB2 commands.
This paper applies to DB2 V10.1 FP2 and later, but many of the features that are described here are available in earlier DB2 versions as well. For example, some of the serviceability functionality for large database environments was introduced in DB2 V9.7 FP4, and user-defined threshold detection for problem scenarios was introduced in DB2 V9.7 FP5. If you are not sure whether specific functionality is supported for your DB2 version, check the information center for that version.
Download the full report for more on troubleshooting DB2 servers.
Download the report to get started!#Db2