Articles & Content


Taming a 1 Terabyte Table! (C07)

Topic: 2006 EU

Subtopic: DB2 for LUW

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

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.