Articles & Content


Point, Click and Run: Using Snapshots To Improve Performance in DB2 LUW (C09)

Topic: 2008 EU

Subtopic: DB2 for LUW

DATE: 2008-10-15 (09:30 - 10:30)
SPEAKERS: Raul Delhumeau (Spherion Corp)

The optimally tuned database has become an elusive, moving target in today's dynamic IT environments - due mainly to growth in data volume, the deployment of new applications or modifications to existing software. Due to the complexity and diversity of the applications that interact with the databases, "tuning in a vacuum" for individual applications or SQL statements is impractical and dangerous. Database snapshots allow us to analyze and review overall database health as a whole, and not as isolated applications. Database snapshots can be easily collected and analyzed to identify both existing and potential performance bottlenecks.An overview of the available snapshot monitor SQL table functions and the data provided by them will be followed by step-by-step examples on how to collect and analyze the snapshot data to implement concrete performance improvement actions. The session is focused on practical application of the reviewed concepts.

EXP. LEVEL: Intermediate


Overview of the available DB2 snapshot monitor SQL table functions and the information provided by them, along with their potential uses for performance analysis and review.

Examine the risks of "tuning in a vacuum" isolated application or SQL statements in modern IT environments where a "beneficial" change can be potentially destructive elsewhere.

Understand the elements of a basic analysis methodology using collected snapshot data to illustrate existing trends or behaviors in the current environment, as well as identifying potential bottlenecks.

Implement a practical application of the above methodology in performance analysis, using the collected data along with other DB2 components such as the explain facility or commonly available tools like MS Excel.

Reinforce the notion of database / system wide tuning (as oppossed to application or SQL statement tuning) as a real starting point for a true continuos performance monitoring and improvement process.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.