Articles & Content


IBM DB2 RUNSTATS Utility: What's Old, What's New, What's a FREQVAL? (I05)

Topic: 2008 NA

Subtopic: DB2 for z/OS

DATE: 2008-05-20 (09:15 AM - 10:15 AM)
SPEAKERS: Ka Chun Ng (IBM Silicon Valley Laboratory)

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. 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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.