Articles & Content
Topic: 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
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.