Articles & Content

Archives

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

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

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



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.