Articles & Content


DB2 Compression - A Complete Test Against a Warehouse Database System - C05

Topic: 2012 NA

Subtopic: DB2 for LUW

• This presentation shows how we have run a demanding warehouse database application system with limited resources

• Using DB2 Compression feature at table and index level, and their impact on space saving and resource usage was explored on a terabyte warehouse database system

• Examining Performance Improvement on query workloads and maintenance routines

• Benchmarking test data (normalized for comparison) to illustrate the performance impact by enabling compression feature

• Inline Large OBject (LOB) data, XML data compression, and backup compression feature were also tested

• Temp table compression data was observed

(Note: partial of the contents - table level compression result was delivered earlier)

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.