Articles & Content


First DB2 Cobra Experiences: Index Compression in SAP BI/BW (C13)

Topic: DB2 for LUW

Subtopic: 2009

DATE: 2009-10-7 (15:45 - 16:45)
SPEAKERS: Stefan Hummel (IBM Software Group), Joachim Stumpf (IBM Software group)

Data and index compression becomes more and more important with the increase of database sizes. There is not only the advantage of lower disc usage. As important is the positive effect of less I/O operations, thus the response times of user transactions and administrative tasks are lower.This session will explain the concepts of the new DB2 Index Compression feature and gives experiences made with DB2 Cobra during the beta test in a real customer environment.

EXP. LEVEL: Intermediate,Advanced


The architecture of a DB2 Storage Optimization

Analyze the database (data and indexes) in terms of compression candidates (tools and approach)

Technique to compress indexes and release physical disc space

Compression within a SAP system copy (homogenous/heterogenous)

Performance impacts

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.