Articles & Content

Archives

Managing Database Growth in DB2 LUW: Pre-existing Items and New to DB2 9 (D03)

Topic: DB2 for LUW

Subtopic: 2007



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

OBJECTIVES:

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



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.