Articles & Content
Topic: 2007 NA
Subtopic: DB2 for LUW
DATE: 2007-5-7 (01:40 PM - 02:40 PM)
SPEAKERS: Mike Winer (IBM Software Group)
Data growth results in increasing storage requirements, while querying and managing the data continues to take longer over time. This session will discuss a number of ways to manage database growth to reduce costs. Sampling, MQT's, and MDC tables provide ways to significantly improve query execution times. Viper introduces increased table capacity, row compression to save disk space and slow growth, and also introduces table partitioning. Tips and best practices will also be discussed.
EXP. LEVEL: Intermediate
Awareness on automatic storage and self tuning memory management - the new defaults in DB2 9
Information on DB2 9's increased table capacity via large table spaces, including a migration strategy
An overview of DB2 9's new row compression feature
An overview of DB2 9's table (range) partitioning capabilities
An understanding of logging, with tips on how to reduce log space usage and subsequent archiving
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.