Scripts for Troubleshooting

The following scripts are available to help you troubleshoot.

Troubleshooting Db2 application hangs
You can use the db2_hang_analyze script to detect and analyze possible application hangs in a Db2® database. It is a Perl script located in the sqllib/samples/pd/ directory.
db2_hang_analyze - Detect and analyze possible application hangs script
Detects and analyzes possible Db2 database application hangs by using various metrics that are gathered from the db2pd command. The db2_hang_analyze script is available only on Linux® and UNIX operating systems.
db2_hang_detect - Detect, report on, and resolve Db2 database hangs script
Detects possible application hangs on a Db2 database and acts to inform and resolve the situation. db2_hang_detect is a ksh script that contains a package of hang detection tests. The db2_hang_detect script is available only on Linux and UNIX operating systems.

Parent topic: Troubleshooting tools