Articles & Content
Topic: 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.
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.