DB2 for z/OS

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

May 14, 2010 03:00 PM

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

pdf file
NA10F13.pdf   352 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.