Walker News

Using IBM DB2 Monitoring Tool db2pd To Document Database Server Profile

One of the jobs of system administrator is to profile each server. This could be a simple job, but sometime it’s not as simple as it seems to be, especially for junior administrator.

Strictly speaking, db2pd is a monitoring tool, not a special utility to generate database server profile.

However, this IBM DB2 utility retrieves information from database system memory sets which some of the information are useful for documenting server profile.

For example, db2pd -osinfo reports the number of physical CPU and related information (single core or multiple core, CPU core speed, CPU load, etc), free and used memory, IPC resource (shared memory, semaphore, and message queue), etc. (See “How to detect a single or multi-core CPU is installed in Linux“).

Similar to db2level, db2pd -V or db2pd -version reports the DB2 version and FixPak level related information.

The db2pd -inst output the detail of DB2 instance level information, such as database uptime, database manager configuration, etc.

To view most information in single output, db2pd -everything tells you all information found on all database partitions.

If you only interested in a particular database called sample, first establish a connection to the target database, e.g. db2 connect to sample in this example. Then, proceed to db2pd command, such as:

To view buffer pools setup and related information (In DB2 version 9.1, db2pd also provides bufferpool statistics, such as hit ratio):
db2pd -db sample -bufferpools

To view table spaces type (SMS or DMS) and associated table space containers statistics (total useable pages, used pages, free pages). The db2pd command output seems to be easier for me to write a shell script to automatic recording table space utilization statistics :-)
db2pd -db sample -tablespaces

For more db2pd related information, refer to IBM DB2 Information Center Home of respective version. For example:

db2pd of DB2 version 8.2 for Linux, UNIX, and Windows operating systems (LUW).
db2pd of DB2 version 9.1 for Linux, UNIX, and Windows operating systems (LUW).
db2pd of DB2 version 9.5 for Linux, UNIX, and Windows operating systems (LUW).

Custom Search

2017  •  Privacy Policy