Articles & Content


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

Topic: DB2 for z/OS

Subtopic: 2010

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

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.