Db2 troubleshooting tools

This section explores two key monitoring and troubleshooting tools: db2pd and dsmtop.

The db2pd command

You can use the Db2 problem determination tool, db2pd, to obtain troubleshooting information from database system memory sets, without acquiring any lock or latch in the database. Since the db2pd tool works directly with memory, it is possible to retrieve information that is changing as it is being collected using minimal Db2 engine resources.

If the database is running in a Massively Parallel Processing (MPP) setup, a pureScale configuration, or an HADR setup, this command must be run on all the nodes or members of the cluster. However, if you have logical partitions within one physical server...