Articles & Content
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.