Topic: Code Place
Subtopic: DB2 for LUW
IDUG EU 2004 session entitled [Monitoring Your Database With Just SQL Scripts] and are intended to give you samples. The scripts cover performance tuning including bufferpool, sort, package cache, top sql, long running sql, lock wait, lock chains, lock memory usage, lock timeout and escalations and page cleaners. Monitoring database health including log space usage, storage allocations, and health monitor alarms.
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.