Articles & Content
Topic: 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
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.