Articles & Content
Topic: 2007 NA
Subtopic: DB2 for LUW
DATE: 2007-5-8 (01:40 PM - 02:40 PM)
SPEAKERS: Robert Donaldson (LSSi)
DB2 provides 3 methods to compress data to conserve storage space.This presentation discusses the three methods and gives the advantages and disadvantages of each based on my experiences.Most attention is given to Data Row Compression which was introduced in DB2 v9.The older Table Null Value compression and Column Default Value compression methods are also discussed and compared.
EXP. LEVEL: Beginner,Intermediate
What does each compression option do to help reduce your data size?
Advantages and disadvantages to each of the compression options discussed based on my experiences
When to consider one of the compression options (Choose wisely, sometimes they can hurt more than help)
Performance impact on an i/o bound system and a CPU bound system
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.