How to report a DB2 performance problem

24 September,2011 by Tom Collins

You’re experiencing a sudden slow down in DB2 performance. Users are complaining . Many reasons could be causing this sudden slowdown .

For DB2 problems, gathering and analyzing data is not enough.  A lot of time can be wasted analyzing data not relevant to the problem.

Before you contact me to report a problem, spend some time preparing the information to assist in solving the problem. This assists me to work with you quicker in solving the DB2 performance issue.

Some suggestions to solve the problem faster are:

1)        Provide a report in plain English  of a simple specific example  of the problem. Focus on the facts.  If you have a theory about the cause of the problem ,  present it as a separate statement.  Avoid using statements such as  "the database server is very slow" , they require investigation to determine what you mean by “very slow”, and defining acceptable performance

Focus on these questions:

a)      Can you recreate the problem? If not, outline the simplest example of the DB2 performance problem

b)      Is the problem persistent?  Or random ? What time of the day is it occurring?

c)       Is everything slow or  just some activity ? Which activity is slow?

d)      When did the problem start ? Was it when migrating into Production? Have changes occurred recently , such as more users or large data import ?

e)      If multi-tier , can the problem be recreated locally ?

f)        What other applications are on the database server ?

g)      What is the impact of the performance problem on the users ?

2)       Provide information about all changes on the system in the days  before the performance problem started. Providing as much information as possible , allows me to investigate various options. Allow me to eliminate unrelated causes.

3)  Use the correct server to supply information. It is easy to accidentally collect the data on the incorrect server, especially on very large production sites. This makes it very hard to investigate the problem

 Once you’ve completed the above steps , contact me to work with you directly.  The normal procedure is I will send you some data gathering scripts about database server information and database usage.  The nature of the scripts is based on the information you send me




Author: Rambler(


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How to report a DB2 performance problem

Comments are moderated, and will not appear until the author has approved them. | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright