Articles & Content
Topic: 2007 EU
Subtopic: DB2 for z/OS
DATE: 2007-11-6 (11:45 - 12:45)
SPEAKERS: Bryan Smith (IBM Silicon Valley Lab)
This presentation reviews the basics of the RUNSTATS utility (What it does; Why you need to run it; How DB2 uses the information), and explores new statistics collected on data and indexes, including: partition level information on Data Partitioned Secondary Indexes; non-uniform distributon statistics on non-indexed columns; and historical statistics. The real-time statistics are also reviewed. Upon completion of this session, the attendee, whose skill level may range from low to high, will be able to understand how to get the most out of DB2's statistics and operate at optimal efficiency.
EXP. LEVEL: Beginner,Intermediate,Advanced
Understand what stats to use to determine when to run maintenance
Understand what many of the statistics mean
What are the new statistics in V8 and V9; why should I care about them, and how do I collect them?
Real-time stats versus RUNSTATS
How to reduce the CPU consumption for RUNSTATS
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.