dba-db2.com
DB2 - Collecting data for database performance problems

30 November,2012 by Jack Vamvas

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:

<dbname>.ddl

dbmcfg.out

<dbname>-dbcfg.out

<dbname>-table.out

<dbname>-index.out

<dbname>-buffer.out

db2level.out

db2set.out

<dbname>-dbsnap.out

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: Jack Vamvas(http://www.dba-db2.com)

Subscribe to DBA-DB2.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

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

Working...
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.

Working...

Post a comment

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