Articles & Content


Taming a 1 Terabyte Table! (C07)

Topic: DB2 for LUW

Subtopic: 2006

DATE: 2006-10-3 (15:15 - 16:15)
SPEAKERS: Paul Turpin (Wachovia)

When table size gets in the Terabyte range a number of issues arise. Doing maintenance (runstats, reorg, backup, restore, etc) on the objects can be quite tricky. Getting good performance on queries of the table can be very difficult. The DBA must use all the tools at their disposal to solve the maintenance issues and performance issues.

EXP. LEVEL: Beginner,Intermediate,Advanced


Database partitioning

Index design

Utility challenges

Backup/restore issues

Union all view

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.