Skip to content

Tag Archives: performance

Leveraging DB2 Snapshot Administrative Views


This article will show the DB2 LUW version 9 administrator how to use Unix shell scripts to build a home-grown database performance history system without resort to third-party tools. Shell scripts are used to automate performance capture and provide 24×7 monitoring support. The author also provides 40 views representing calculated common metrics of the resulting performance history data.

db2pd: Rapidly Evolving DB2 Performance Tool


db2pd is a relatively new DB2 LUW performance monitoring and troubleshooting tool introduced with DB2 version 8.2. Because it retrieves information from DB2 memory sets, it does not issue latches and is therefore a very low-cost means of monitoring DB2. We present an overview of new features that have been rolled out steadily since db2pd was introduced.