Articles & Content
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
Commonly asked questions about the stats
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.