Articles & Content

Archives

DB2 Compression and performance impact (G11)

Topic: DB2 for LUW

Subtopic: 2010



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



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.