Articles & Content

Archives

IBM DB2 RUNSTATS Utility and Real-Time Statistics (B05)

Topic: DB2 for z/OS

Subtopic: 2007



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

OBJECTIVES:

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



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.