Articles & Content

Archives

DB2 Compression and performance impact (G11)

Topic: 2010 NA

Subtopic: DB2 for LUW



DATE: 2010-5-13 (01:30 PM - 02:30 PM)
SPEAKERS: Robert Donaldson (LSSiData)

This presentation discusses DB2 Native compression and describes the real world performance impact in both i/o and CPU bound workloads. (Data Row Compression, also known as Storage optimization feature.) Older Table NULL value compression and Column default value compression are also discussed but the main focus is on the new data row and index compression. DB2 compression options in DB2 9.1, 9.5 and 9.7 are compared including what data can be compressed with each version. Focus is on real world insert performance, bulk load performance, reorg sped impact, and compression ratios from my systems. Differences in usage between the versions are also discussed.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Know what compression options are available in DB2 UDB 9.1, 9.5 and 9.7.

Bulk load and insert performance impact on i/o and CPU bound databases, as welll as reorg impact. (Compared between DB2 9.1, 9.5 and 9.7)

Types of data that can be compressed in each version and real world compression rations from my Databases.

Advantages, and disadvantages as well as usability notes.

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.