Skip to content

Tag Archives: Unix

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.

A Simple DB2 Audit System

10-Mar-09

I just wrote a small Unix script-based db2audit capture system for one of my version 9 DB2 databases. Includes full script and DDL to assemble your own system.