Skip to content

Tag Archives: database administration

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.

DBA Holistic Scheduler Consciousness

26-Dec-08

To be a good production DB2 DBA, you need an awareness of ALL scheduled processes that connect with your database. In a large organization, this is not an easy task, and requires you to be proactive.