Skip to content

Tag Archives: database

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.

QUIESCE command INSTANCE/DATABASE/USER/GROUP options

18-Feb-09

A quick reminder note about some features of the DB2 QUIESCE command implemented in version 8.