Skip to content

Tag Archives: snapshot

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.

Proceeding Cautiously with DB2 Event Monitors


Managing risk when using the DB2 Event Monitor. The event monitor can be tuned for reduced performance impact upon your database. You have a wide variety of options, which we detail in this post.