Articles & Content

Archives

Space, The Final Frontier: DB2 Native Compression Options (D07)

Topic: DB2 for LUW

Subtopic: 2007



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

OBJECTIVES:

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

General considerations



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.