Articles & Content


Performance Toolbox: 10 scripts for faster systems (C02)

Topic: DB2 for LUW

Subtopic: 2006

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.