Articles & Content
Topic: DB2 for LUW
DATE: 2006-10-2 (13:30 - 14:30)
SPEAKERS: Steve Rees (IBM Toronto Lab)
It can be difficult to recall and apply performance tuning rules you've seen in print or at a conference. In this session, we review many of these techniques, and then we describe and demonstrate a set of free, portable and easy-to-use sample scripts for performance monitoring. These scripts simplify monitoring of areas like bufferpools, locking, SQL, etc., and can be used as-is, or as a basis for further customization.
EXP. LEVEL: Beginner,Intermediate,Advanced
The scripts: portable, simple, flexible -not fancy
Building on DB2's monitoring capabilities
Perf diagnostic 'rules' and how we script them
A bit more advanced: extending past monitor data
Live demo: we run the scripts & find the problems!
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.