Skip to content

Tag Archives: snapshot

Leveraging DB2 Snapshot Administrative Views

27-May-09

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

22-Oct-08

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.