Articles & Content


How a Performance Database Can Help Save the Day! (F13)

Topic: 2010 NA

Subtopic: DB2 for z/OS

DATE: 2010-5-14 (08:30 AM - 09:30 AM)
SPEAKERS: Mark Wilkinson (AMICA Mutual Insurance Company)

Come to this session to experience the value of building and maintaining a performance database (PDB). You will learn the critical steps you need to take for creating, loading and running reports from a PDB. The key benefit comes from the data you collect and from being proactive, rather than reactive. Learn to resolve issues before they become bottlenecks, You might notice performance spikes and correlate them to a new version of DB2 or a new deployed application. You can then zero in on the performance issues to identify the cause. A PDB can be the basis for capacity planning. Several examples of mining the PDB will be presented.

EXP. LEVEL: Beginner


General DB2 monitoring guidelines and basics

General DB2 trace information

Building a repository for performance data Performance Database (PDB) or a Performance Warehouse (PWH)? Why? Which? How? Where? What?

Value of a PDB and a PWH as seen from Amica Insurance

Performance Database SQL examples will be provided

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.