Articles & Content
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
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.
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.