DB2 - Collecting data for database performance problems

30 November,2012 by Tom Collins

In DB2 database performance troubleshooting , one of the challenges is to collect the right amount and type of data to assist the DBA to get clues.   In How to report a DB2 performance problem  there are questions to think about – guiding you towards a general approach to reporting a performance problem

This post lists the information required when you’re sending me DB2 performance related queries. It gives me enough data to gain an overview of the database. It doesn’t guarantee a solution , but covers the main data sets.

Run the following from a DB2 command window


db2look -d  -e -o .ddl -a -l -f 
db2 get dbm cfg > dbmcfg.out 
db2 get db cfg for  > -dbcfg.out 
connect to  
db2 -tvf table.sql > -table.out 
db2 -tvf index.sql > -index.out 
db2 -tvf buffer.sql > -buffer.out 
db2level > db2level.out 
db2set -all > db2set.out 
db2 -tf updmon.sql 
--after this, run db2 get monitor switches 
--they should all say "ON" 
--run whatever process is causing the issue(s) 
db2 get snapshot for all on  > -dbsnap.out 
--this must be run from the same command window as step 10 
--if you can do multiple snapshots that would be better, an hour apart or 
--so while the S&P agent is running, use different output files 

--where  is the name of your database 


Please send the following files:










Read More


How to report a DB2 performance problem - DBA DB2

Database Tuning overview – Access Path Tuning

Performance Tuning series – Performance Stack - DBA DB2 ...

OLTP performance checklist - DBA DB2

Author: Rambler(http://www.dba-db2.com)


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 DB2 - Collecting data for database performance problems

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright