Articles & Content

Archives

DB2 RUNSTATS Utility: What's Old, What's New... (B09)

Topic: 2006 NA

Subtopic: DB2 for z/OS



DATE: 2006-05-10 (01:00 PM - 02:10 PM)
SPEAKERS: Bryan Smith (IBM Silicon Valley Lab; DB2 and IMS Tools)

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.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Why RUNSTATS?

Commonly asked questions about the stats

Reorg recommendations

New statistics in V8

What can you expect coming soon



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.