Skip to content

Tag Archives: version 9

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.

UPDATE: DB2 Health Monitor Problems

17-Feb-09

This post details a serious problem encountered running DB2 Health Monitor version 9. It might be resolved using DB2 registry variable DB2_HMON_DFT_STACK_SZ.