db2pd troubleshooting guide

01 February,2015 by Jack Vamvas

DB2 troubleshooting with db2pd

Db2pd is one of my favourite DB2 troubleshooting tools.  I use these commands on a daily basis.

There are many occasions where I’ve used information from these commands to troubleshoot DB2 issues.

Useful information about database logs

db2pd -db DB_NAME –logs

DB2 database lock information

 db2pd -db DB_NAME  –locks

DB2 database configuration information

 db2pd –db DB_NAME  –dbcfg

DB2 hadr information

 db2pd -db DB_NAME  -hadr

Database Partition Memory Controller Statistics

db2pd –dbptnmem

Get DB2 level

db2pd -V or db2pd –version

Get OS information

Db2pd –osinfo

Get almost everything

Db2pd –everything

Get tablespace containers statistics – total useable pages, used pages, free pages,tablespaces type

Db2pd –tablespaces –db DB_NAME

Findlongest running query – when db2pd is your only option

--find db2agent consuming high CPU.

db2pd –edu

--use the EDU ID find the application and sql code

db2pd –app -dyn

Get DB2  instance uptime

Db2pd –

 

Read More on DB2 troubleshooting

DB2 database hangs on db2 connect - use db2pd to troubleshoot

Analyzing a DB2 trap file - DBA DB2

DB2 - SQL1035N The database is currently in use - DBA DB2

 

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

Share:

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 on db2pd troubleshooting guide

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