Articles & Content

Archives

Even More Compression in DB2! (F14)

Topic: 2009 NA

Subtopic: DB2 for LUW



DATE: 2009-5-15 (10:30 AM - 11:30 AM)
SPEAKERS: Mike Winer (IBM Software Group)

Deep Compression was first delivered in DB2 9.1, with enhancements provided in DB2 9.5. More compression capabilities are planned for DB2ís next release, further reducing disk usage and storage costs:1. Compression of Indexes; 2. Compression of Temporary Tables; 3. Compression of XML Data; 4. Compression compatibility with Replication (Change Data Capture), enable row compression on replicated tables; 5. Inline LOB data in base table row.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Learn how Index Compression can reduce storage and costs in your database environment. A variety of compression techniques are applicable, and will be described along with the tooling provided to estimate and track compression results.

Storage for temp table spaces can be reduced with temp table compression. Learn how compression of temps will enable DB2 to consume less temp space (particularly but not restricted to warehouse environments) and reduce storage costs.

XML data could be inlined in the base table row and participate in row compression in DB2 9.5. Enhancements planned for DB2ís next release enable the same compression capabilities to apply to XML data which is not inlined.

Participants will learn about compression for replicated tables, planned for DB2ís next release.

LOB column data within the base table row is planned for DB2ís next release, through implicit and explicit inlining capabilities. Attendees will learn how this will not only save on total storage, but significantly improve DML performance as well.



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.