In this blog we will see and learn about one of the important db2 tool which a DBA use it on daily basis. The db2pd command is a powerful tool for monitoring and administering DB2 Linux, UNIX and Windows databases and instances. You can use this tool to keep track of transactions, table spaces, table statistics, dynamic SQL, configuration settings and much, much more.
We can use plenty of options with db2pd 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. Below are few examples of troubleshooting DB2 issues using db2pd :
1) To get DB2 instance uptime
db2pd -
2) To get OS information
db2pd -osinfo
3) To get DB2 level
db2pd -V
db2pd -version
4) To get almost everything db2 databases details
db2pd -d <database name>
db2pd -everything
5) To get useful information about database logs
db2pd -db <database name> -logs
6) To get db2 database lock information
db2pd -db <database name> -locks
7) To get more diagnostic lock information
db2pd -db <database name> -locks -transactions -applications -dynamic
8) To capture all pending locks
db2pd -wlocks -db <database name>
If you got any locks here then you can use the -apinfo option with db2pd to capture detailed runtime information about the lock owner and lock waiter
db2pd -apinfo 21 -db <database name>
9) To get db2 database configuration information
db2pd -db <database name> -dbcfg
10) To get db2 hadr information
db2pd -db <database name> -hadr
11) To get tablespace containers statistics – total useable pages, used pages, free pages,tablespaces type
db2pd -tablespaces -db <database name>
12) To determine which application runs out of table space
db2pd -tcbstats -db <database name>
13) To view memory statistics of database partitions
db2pd -dbptnmem
14) To monitor memory usage.
db2pd -memblock
15) To verify whether recovery is in progress
db2pd -db <database name> -recovery
16) To determine the amount of resources that the transaction is using
db2pd -db <database name> -transactions
17) To monitor log usage
db2pd -db <database name> -logs
18) To view database bufferpool information.
db2pd -db <database name> -bufferpools
19) To get database application information.
db2pd -db <database name> -applications
20) To view dumps page cleaner related information from a database
db2pd -db <database name> -cleaner
21) To view the settings of the database configuration parameters.
db2pd -db <database name> -dbcfg
22) To view the settings of the database manager configuration parameters.
db2pd -dbmcfg
23) To get the fully resolved split diagnostic path.
db2pd -diagpath
24) To lists all EDUs in the instance.
db2pd -edus
25) To view the information about table and data partition reorganization of the connected database.
db2pd -db <database name> -reorg
26) To view the information about the status of the RUNSTATS utility on table and associated indexes of the connected database.
db2pd -db <database name> -runstats
That's all in this post. If you liked this blog and interested in knowing more about IBM Db2. Please Like, Follow, Share & Subscribe to www.ImJhaChandan.com.