Using db2pd—DB2 problem determination tool

db2pd is an abbreviation for the DB2 problem determination tool. It is very useful for detecting various problems and has almost negligible impact on the database and instance, because it does not rely on memory latches for inspection. It inspects the memory structures without interfering with the database engine.

Getting ready

db2pd has plenty of options used for retrieving information about operating systems, dynamic SQL, table statistics, database partitions, and also including information about storage, configuration, recovery processes, HADR status, and many more. There are two possible methods to use db2pd, in interactive mode or executing from the command line with options.

How to do it...

1. Further, we will cover some common options and diagnostics. To gather information about the operating system using db2pd, execute the following command:

   [db2inst1@nodedb21 ~]$ db2pd -osinfo
   
   Operating System Information:
   
   OSName:   Linux
NodeName: nodedb21...